Hi What are the steps to be taken to use oracle instant client to connect from excel to oracle database. I have the unzipped basic instant client folder. The OS used is Windows XP. Here is my connection string: strConnection = "Driver={Microsoft ODBC for Oracle};Server=servername; Uid=username;Pwd=password;" I have ...
Hi, I ran a SQL Delete from a SQL Developer session and the delete was running for a long time since there were large number of records. Due to some Not Responding problem with SQL Developer client, i lost my session, as the SQL Developer window got closed. I do not have DBA access rights, i can not query views like v$session, v$sqlare...
I keep seeing vacancies for software developers that require EAI experience. From what I can figure, this means someone with experience developing with one of the large commercial off the shelf (COTS) packages (SAP, Oracle, SalesForce etc). As I'm not working in a company that doesn't have any of these systems, how can I gain EAI skill...
I am building an object from multiple datasources. Does anyone know whether this is possible in NHibernate and how. I should mention that one source is SQL the other ORACLE. ...
I'd like to set the v$session.program Oracle property in order to have information available in the session table. I'm using JPA with a jndi XA datasource created with an oracle-xa-ds.xml deployed in the deploy folder of Jboss, and therefore I haven't access to the constructor of the Connection. I have access to the Connection object, in...
Here's the documentation: http://download-east.oracle.com/docs/cd/B12037_01/server.101/b10759/queries003.htm Here's the execution order it describes: A join, if present, is evaluated first, whether the join is specified in the FROM clause or with WHERE clause predicates. The CONNECT BY condition is evaluated. Any remaining WHERE claus...
Hello All, Can you please guide me to the equivalent to this query in Oracle: SELECT SQL_CALC_FOUND_ROWS * FROM tableName SELECT FOUND_ROWS() as cnt Thanks ...
I need to use Enterprise Lib with Oracle to handle bulk inserts/updates/deletes through associative arrays without including the ODP.NET dll for abstraction purposes. This has to be done through C# code (not stored procs) due to an issue with dbd resources. There is an arraybindcount property for using associative arrays with Oracle, b...
I have a standard rails application, that uses a mysql database through Active Record, with data loaded through a separate parsing process from a rather large XML file. This was all well and good, but now I need to load data from an Oracle database, rather than the XML file. I have no control how the database looks, and only really nee...
I need to read a value from an Oracle database and the field has been declared as Number(38). How can I do this in C# since the Decimal type isn't big enough? ...
I have a table containing hierarchical data. There are currently ~8 levels in this hierarchy. I really like the way the data is structured, but performance is dismal when I need to know if a record at level 8 is a child of a record at level 1. I have PL/SQL stored functions which do these lookups for me, each having a select * from tb...
I get a dmp and install a Oracle XE for developing. However, when I use imp to import, the create table statements were skipped. Can anyone kindly help on the issue. The screen output were captured as follow: Many Thanks! C:\Documents and Settings\wong\Desktop>imp Import: Release 10.2.0.1.0 - Production on Mon Aug 2 22:48:32 2010 C...
Hi al, I need to optimize the following query but 'm not able to wonder how. select distinct v.codvia, v.codproine, v.codmunine, tv.SIMBOLO as SIMBOLO_TIPO_VIA, tv.NOMBRE as TIPO_VIA, c.nombrevia as NOMBRE_VIA, v.cp, m.nombre as NOMBRE_MUNICIPIO , pr.nombre as NOMBRE_PROVINCIA from tdinumvias v, ...
I am recently inclined towards in Oracle jargon and the more I am looking into the more is attracting me. I have recently come across the MODEL clause but to be honest I am not understanding the behaviour of this. Can any one with some examples please let me know about the same. Thanks in advance ...
hi, i have an old oracle database in which there is a field of type LONG(max size is 2GB) Now earlier it used to work fine but with time data we started putting was of size much more than 2GB so we started facing trouble. I can not change the field type from LONG to CLOB since that will create a lot of trouble as innumerable changes ...
I have Oracle 10gR2. I am trying to create autoincrement trigger. Here is the sample: CREATE SEQUENCE TEST_SEQ INCREMENT BY 1 START WITH 1 NOMAXVALUE / CREATE TABLE TESTER ( ID_TESTER INTEGER NOT NULL, VAL VARCHAR2(20) NOT NULL ) / CREATE OR REPLACE TRIGGER TIB_TESTER BEFORE INSERT ON TESTER FOR EACH ROW BEGIN SELECT TEST_SEQ.NEXTV...
I have a table student(id, name, department, age, score). I want to find the youngest student who has the highest(among the youngest students) score of each department. In SQL Server, I can use following SQL. select * from student s1 where s1.id in (select s2.id from student s2 where s2.department = s1.department order by age asc, sc...
i try to do pooling through PoolingContextSource http://static.springsource.org/spring-ldap/site/reference/html/pooling.html and get below error? does oracle(oid) ldap support pooling? java.lang.UnsupportedOperationException: Not supported for this implementation at org.springframework.ldap.pool.factory.PoolingContextSource.getCon...
Hi I am trying to connect from .net windows application to oracle database. Do we have to install oracle client in every system where the application is running to connect to the remote oracle database.. Thanks in advance ...
I want to parse the SQL code of a file .sql using C#. I want determinate Syntax Check of a file sql, specifically Insert, Update and Delete statements. Specifically is there any parser freely available which can parse the SQL code in C# .NET ? better is freeware, source code included, and easy use. I use Oracle ...