Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.
0
votes
0answers
7 views
asp.net with Oracle Configuration
i am traying to configure oracle with ms visual studio 2012 (asp.net).
I install Oracle DataAcces Client (220mb size). And in my asp.net project in web config I've:
<connectionStrings>
...
-3
votes
1answer
17 views
what keyword come in the blank in code? i am very confused please help me [closed]
what is the missing keyword
DECLARE
CURSOR c1 IS
SELECT * FROM DUAL;
r1 c1%ROWTYPE;
BEGIN
OPEN c1:
FETCH c1 INTO r1;
IF c1%NOTFOUND ...
-1
votes
0answers
23 views
What is the missing keyword in this code? I can't find the missing word please help me [closed]
Please help me to find the missing keyword on the place of _
Please help me
DECLARE
CURSOR c1 IS
SELECT * FROM DUAL;
r1 c1%ROWTYPE;
BEGIN
OPEN c1:
...
0
votes
1answer
23 views
What is location of built in SQL functions and Oracle Packages in Oracle Database
I want to know location of file / table where definition of Built In Functions / Packages / Procedures of Oracle are stored like MAX(), DBMS_OUTPUT etc.
-2
votes
0answers
13 views
NAS Storage for Oracle Database Archiving [closed]
We are planning to Archive our oracle 11 G database to a NAS drive .
Are there any known issues in archiving oracle datasets to NAS Storage ?
0
votes
1answer
9 views
The provider is not compatible with the version of Oracle client error (11.2 installed on dev machine, 9.2 installed on target host machine)
I've have an ASP.NET application that I developed on a machine with Oracle 11.2 installed on it. It runs fine on local host but when I publish it to a server box with Oracle 9.2 installed on it I get ...
0
votes
1answer
18 views
Oracle 11g - Updating matched rows with values from a source table
T1.LEID needs to be UPDATED with T1.ID values from
Rows in which both the MSID and the ESTID match.
I have turned my syntax around and tried several variations, but always end up with same error ...
1
vote
1answer
43 views
Why is this DELETE query so slow on Oracle?
I'm writing some database upgrade scripts, and am running into a query that takes a lot longer than I think it should:
DELETE FROM TPM_TASK WHERE TASK_TYPE='System';
This query takes over an hour, ...
0
votes
0answers
8 views
Product Information Hub base tables
I have been searching thru oracle documentation and have been unable to fine the names of the Oracle PIM base tables.
I would like to use the information in PIM for reports and web pages but have ...
0
votes
0answers
12 views
Connection with Oracle SQL Developer to Oracle 11g database on remote Windows Server 2012 machine
I have running up my oracle database 11g on server 2012,
I connected to database via oracle sql developer from my server.
Now I wanna connect to database via my home computer(windows8) also with ...
0
votes
1answer
22 views
Pl sql date intialization comparsion ++
I have requirement where i have to get data of particular day so my ideal startdate should be 2013-06-07 00:00:01 AM and end date 2013-06-07 23:59:59 AM
hence i have written code
create or replace
...
0
votes
1answer
24 views
How to modify where clause in query
Below is my current where condition
WHERE Log.Event_Type IN ('ABC_CHANGE', 'MAN_ABC_CHANGE')
Event_Type field has over 20 different data in it.
I only care about ABC_CHANGE and MAN_ABC_CHANGE.
...
0
votes
1answer
13 views
MS Access 2000 to MS Access 2007 migration
I have application in MS Access 2000.
It is connected to Oracle 9.2.06 database.
I have to migrate the application to MS Access 2007 and Oracle 11G.
I've created a blank .accdb file and imported all ...
0
votes
1answer
8 views
Oracle (11g) compound trigger not updating CLOB data field
I tried searching for answers to this but couldn't really find anything useful. Either there isn't or my searching capabilities took a knock. Regardless, here's my situation:
I have a case where I've ...
0
votes
0answers
7 views
Opening pdf document on server from oracle forms 11g
I am converting oracle forms 6i application to oracle forms 11g R2. I would like to open an a pdf document using web.show_document but it giving eror 404--Not Found error. I understand I need virtual ...
