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 [tag:oracle10g] are assumed to be specific to this version or features introduced in this version.
0
votes
0answers
6 views
connect php to oracle 10g on xubuntu
I can't connect to oracle database 10g with php (I'm using xampp).
I used this guide to set it all up, and everything seemed to be OK but when I tried to connect I got this error:
oci_connect(): ...
1
vote
1answer
31 views
Oracle caches CLOB to Temporary Table
I have two custom types in my Oracle DB
TYPE SETTING IS OBJECT (
SETT_NAME VARCHAR2(32767),
SETT_VALUE CLOB,
);
TYPE SETTINGS_SET IS TABLE OF SETTING;
And I have simple function that ...
1
vote
1answer
16 views
Reset global database username and password
I have a global database name - ABN, Username - abntest and password - abntest123.
This password expired and all system default password have also expired. Some username and passwords for the system ...
0
votes
2answers
39 views
ORA-01476: “divisor is equal to zero” for SQL query (Oracle 10g)
I'm creating an SQL Query under oracle 10g, the result should give me something like that :
----------------------------------------------------------------------------------
TEXT VALUE1 ...
0
votes
0answers
31 views
Update on view says, 1 row(s) updated, however underlying table is not updated
My Oracle database schema is consisting of various tables, and views.
There is a Table A, and View A. View A is simply a Select on Table A with only few columns including primary key.
My user has ...
-4
votes
5answers
71 views
Merging two tables in SQL
I have two tables:
t1:
SSN NAME LAST AD SAL
-------------- ---------- ---------- ----- ----------
s1 paps 2600
s2 ...
2
votes
1answer
29 views
oracle date arithmetic returning unexpectedly large number
I have a question regarding the way that oracle does arithmetic on dates (connecting to 10g database). Given the following query:
select DateX - DateY as Number_Of_Days from table
my experience ...
-3
votes
0answers
36 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:
...
-3
votes
0answers
10 views
insert PcapPacket , divide it and then insert it into Oracle DB [closed]
*I'm developing an example of Offline-Capture jnetpcap : IDE=netbeans.
*I want that my application:
--- reads packets from a .pcap file .
----- &--- - divides every packet ...
1
vote
3answers
29 views
Oracle SQL null plus number give a null value
I'm doing some calculation using (+ operations), but i saw that i have some null result, i checked the data base, and i found myself doing something like number+number+nul+number+null+number...=null . ...
0
votes
1answer
24 views
Optimize Oracle join query on a table with large number of rows
I have a source table and an identical target table, in them we have a Rate per day, per customer, per period and we have 48 periods
for each day, so for a single customer we have 48 rows per day.
...
1
vote
1answer
34 views
ORA-02070: database does not support in this context
I'm trying to insert data from a VIEW in one DB to a table in another DB.
insert into schema.dummy_table@LINK
SELECT v1.coulmn1, v1.cloumn2, v1.clolumn5, v1.cloumn7, v1.column3
FROM user.view1 v1, ...
0
votes
1answer
16 views
Oracle 10g Cursor Error
I am intermittently getting this error:
ERROR: ORA-01000: maximum open cursors exceeded
in my VB.Net console application. The application works fine on my local machine but gets thrown in our ...
0
votes
1answer
20 views
Host .NET Web Service that uses Oracle 10g DB
I am making a Web Service in .NET that will be consumed by android apps. The Database of my existing project is in Oracle 10g and is impossible to transfer to MSSql. The problem is that to connect to ...
0
votes
2answers
30 views
Connecting to remote Oracle 10g DB without Oracle Client
I am a J2EE Developer and have little knowledge of .NET. I am making a web service that connects to a remote Oracle DB. Now the problem is that I don't want to install oracle client on my system. Is ...
