see below for code
if i define a table type, and then use bulk collect to fill it with records, i can then use the table() function to use that collection in a sql statement. the code below show...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23493326.html
Hi,
could you please explain me why it is unable to select data from SYS.ALL_TAB_PRIVS_RECD table from procedure:
Procedure code:
CREATE OR REPLACE PROCEDURE AtestProc IS
cnt number;
begin ...
http://www.experts-exchange.com/Database/Oracle/Q_23030312.html
Recieving Ora-01427 Single Row Subquery Returns More Than One Row when running this script:
Update ReservationDetail D set (D.ReservationNo) = (Select R.ReservationNo from Reservation R, Reserva...
http://www.experts-exchange.com/Database/Oracle/Q_23371922.html
Zones:
OracleDate Answered: 05/02/2008 Rating: 9.9 Views: 4
I'm trying to prevent a transaction via an exception trigger in Oracle. I have a resravtion table that hold a reservation number and a serial ID amoung other values. I will use the reservation numb...
http://www.experts-exchange.com/Database/Oracle/Q_23419013.html
I have an application that stores content to a Tablespace. Throughout the years of usage, many of the content has been archive and deleted. Doing any deletions does not make the tablespace size s...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23554018.html
Zones:
Oracle 9.xDate Answered: 07/10/2008 Rating: 9.2 Views: 0
How to check table whether value exists or not from a flat file containing two columns(file containing data), if values not exists i want to write to a file stating that value does not exists? Plea...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23674791.html
Zones:
Oracle 9.xDate Answered: 09/02/2008 Rating: 7.7 Views: 0
I have table B created as a partitioned with the same structure with table A( table A is not a partitioned table). Table A is my production table it contains lots of indexes. If i rename B to table...
http://www.experts-exchange.com/OS/Unix/Solaris/Q_23715428.html
I am getting this error periodically (most of the time, but sometimes it works).
ORA-01562: failed to extend rollback segment number 16
ORA-01650: unable to extend rollback segment R16 by 8 in...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23736042.html
Zones:
Oracle 9.xDate Answered: 10/07/2008 Rating: 8.2 Views: 15
Both of the following SQL statements give me the ORA 00933 error.
SELECT DISTINCT s.customer_name FROM depositor AS s WHERE NOT EXISTS ( (SELECT branch_name FROM branch WHERE branch_city = 'Broo...
http://www.experts-exchange.com/Database/Oracle/Q_23805758.html
Presently I am working in Oracle 8i DB.
As I face some problem in this I want to move to 9i.
Plz freinds, throw some points on 9i over 8i.
http://www.experts-exchange.com/Database/Miscellaneous/Q_20111252.html
Zones:
DatabasesDate Answered: 05/04/2001 Rating: 7.0 Views: 0