Is it possible in SQL to read whole table with nested table into the scalar variables (not row by row in PL/SQL)?
I have the object type:
CREATE TYPE res_period_cnt AS OBJECT (
res_period number...
http://www.experts-exchange.com/Database/Oracle/Q_10324381.html
Zones:
OracleDate Answered: 04/10/2000 Grade: B Views: 0
Is there any way to select from a refcursor in sql_plus?
If I run this at the sql prompt, can I select from the :cur bind variable to see what's in the dynaset?
EXEC SCHEMA.PACKAGE.PROC('122...
http://www.experts-exchange.com/Database/Oracle/Q_20220987.html
Zones:
OracleDate Answered: 03/07/2002 Grade: B Views: 0
I have a stored proc that has an order by variable as one of the parameters, but the sql statment won't work with it. I've tried passing the field name and the field number. Below is a partial proc...
http://www.experts-exchange.com/Database/Oracle/Q_20221146.html
Zones:
OracleDate Answered: 11/01/2001 Grade: A Views: 0
Hi,
I am using oracle9i and jdk1.4.0. I want to write a trigger that fires when a row is inserted into the table. When the trigger fires it should call a java program. I want to know how to loa...
http://www.experts-exchange.com/Database/Oracle/Q_20548570.html
Zones:
OracleDate Answered: 01/19/2004 Grade: A Views: 0
Hello there,
I need to create a procedure that compares a variable to the values in a table.
The variable(lets call it varX) needs to be hold the following values in a incremention fashion ...
http://www.experts-exchange.com/Database/Oracle/Q_21220557.html
Zones:
OracleDate Answered: 11/27/2004 Grade: A Views: 0
I am currently working on a SQL project. I have included my code, the requirements, the errors I am getting, and the questions I have.
drop table ALL_PATIENTS;
drop table PATIENT_CHARGES;
d...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_22943368.html
I want replicate data from a schema to same schema in a remote db. Only new data should be inserted, duplicates ignored.
The insert statements look fine but no data is inserted, and I get no err...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_22987023.html
rtrim(to_char( column_name,'99G999D999999'));
i must to use this format
if number is 12.123,12345600
must be shown six digits right side of number ,
if number is 12.123,100
in some situations...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23049261.html
Hello,
i hava a table contain XML string (CREATE TABLE tblControllerProjectsXML OF XMLType)
[Code Snippet]
I tried a lot of queries, but none of them work well for me.
The query that i wrot...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23049598.html
rtrim(to_char( column_name,'99G999D999999')); this code not working
if number is 12123
result 12.123,000000
but result must be 12.123
if number is 12123,123
result must be 12.123,123
if numb...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23049663.html
Zones:
PL / SQLDate Answered: 12/30/2007 Grade: A Views: 57
