I am trying to connect to oracle database from c++ using OCCI, I am following these instructions from Mark Williams, But when I run my program it gives error as MSVCR90.dll is missing from your computer. I suppose its problem related to vc compiler maybe its trying to use vc10 and oracle dll searches for vc9 dll? The oracle version I am ...
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 ...
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...
Hi, We just recently moved our DB from 9i to 10G (Yes..better late than never and No - moving to 11g is currently not an option :-)) Details of my Oracle 10G DB are :- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production I am faced with a very wei...
I am new to Oracle, I have two tablespaces one for dev and one for live. Is there a way that I can have a variable on a Package header that contains a tablespace name, which can then be used from within the procedures defined in the package header? I need to do this as I have one tableSpace (TableSpaceA) that needs to query tables in T...
I have an Oracle function that returns a record set. I introduced parameters to the Oracle function and this is causing the front-end code to go haywire. Here's my front-end code. OracleCommand od = oc.CreateCommand(); od.CommandType = System.Data.CommandType.Text; od.CommandText = " select * from table(pkg_fet...
Can i restore different dumps(databases) on a single database created through the database configuration assistant in oracle 10g. i mean to say that the previous tablespaces must be overwritten by the new one thus saving the time to create new tablespace everytime we restore a dump file. ...
How to optimize the response time for the following query: SELECT /*+parallel */ cc.customer_id AS customer_id, cc.title1 AS title1, cc.forename1 AS forename1, cc.forename2 AS forename2, cc.surname1 AS surname1, cc.surname2 AS surname2, cc.company_flag AS company_flag,...
I have PL/SQL function that returns cursor that holds 28 columns and 8100 rows. When I execute that function from SQL Plus I got the results right away and in SQL Developer I'm running script that takes looong time (about 80 seconds). The same happen from Java code. When number of columns reduced to 2 then I got response in less than 4...
I need to find some records created in a range of quarters. For example, I'm looking for all records created between the 4th quarter of 2008 and the 1st quarter of 2010. I have this in my WHERE-clause: ...and r.record_create_date between to_date('2008 4','YYYY Q') and to_date('2010 1','YYYY Q') but Orac...
Do we have any open source tool which allow generation of excel file from database table? Actually we don't have comments in our database tables, I would be great if i can take the table def in excel file, update the comments and execute the scripts back in database. ...
i have got listing screens in my web app that pull quite a heavy of data from oracle database. Each time the listing screen loads it goes to DB and pull data. What i want is ,i want to have some caching teching technique that can extract data from DB and keep that in memory and that when any next request is made i sud be getting data.and...
How to connect Visual Studio 2005 with oracle 10g? ...
We have a oracle stored procedure that resides in oracle 10.2 database. The stored procedur contains certain inputs and outputs parameters. We are trying to create an asp.net webapplication to execute the stored procedure and bind the result that comes from the output paramerters into a gridview. But no luck. Here is what I have done so...
I've got an Oracle 10g database, and I have a third-party jar file(MQ jars). I want to be able to run a trigger in my database that ultimately runs code in store procedure to operate MQ series and sending messages. . I can't figure out how to specify a classpath for my jar file that will be recognized when I am executing trigger. How can...
Hi all, I currently have two tables that look something like this: Table 1 Id | AddressNumber | AddressStreet | AddressZip ------------------------------------------------ 1 | 50 | Fake | 60101 2 | 300 | Fake | 60101 3 | 50 | Fake2 | 60101 4 | 50 | Fake ...
Hi, I have a method void SaveApplicationData() { begin transaction update insert commit transaction } if two users call this method at same time, can these two database transaction run at same time? thanks! ...
I'm new in oracle and i don't know what is wrong with this trigger: CREATE OR REPLACE TRIGGER "propuesta_casas" BEFORE INSERT ON "PROPUESTA_TIENDA_BARRIO" FOR EACH ROW WHEN (new."CASASCAL" IS NULL) BEGIN SELECT PROPUESTA.CASAS INTO :new."CASASCAL" FROM PROPUESTA WHERE PROPUESTA.IDPROPUESTA=new.IDPROPUESTA ; END; / Er...
I have a table that outputs similar to this (although in thousands): EMPNO ENAME TRANDATE AMT ---------- ---------- --------- ------- 100 Alison 21-MAR-96 45000 100 Alison 12-DEC-78 23000 100 Alison 24-OCT-82 11000 101 Linda 15-JAN-84 16000 101 Linda 30-JUL-...