Ravindra Reddy

• Sep 5th, 2007

Cursor is a private SQL area.. its a temporary buffer used to hold the
transactional data on it n used to manipulate multiple rows through PL/SQL block
statements.
Temporary table can hold the records permanently and we can do DML operations
on this..
ok
Cheers
Rav'i'ndra Reddy

Answer Question  Select Best Answer

Meera

• Jul 4th, 2007

The internal table is a table which is getting filled during the run time of the program...and after that there wont exist any value in that internal table whereas table is the one which contains data permanently

Answer Question  Select Best Answer

rsundararajan_in

• Jul 30th, 2007

By using wrapper class pl sql code can be protected.

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

No. but maybe associative arrays can help

Answer Question  Select Best Answer

nitingalande

 Profile Answers by nitingalande Questions by nitingalande

• Jan 13th, 2008

OCI stands for Oracle Call Interface, it is a interface api used to access oracle database from C programs. Data Guard stands for it is multiple DB servers enviornment configured for Physical as well ...

Answer Question  Select Best Answer

Rushikesh

• Sep 25th, 2007

To be callable from SQL statements, a stored function must obey the following "purity" rules, which are meant to control side effects:1. When called from a SELECT statement or a paralle...

Answer Question  Select Best Answer

dearvandna

• Sep 21st, 2007

Normally use it as sql%type or sql%rowtype. But if you are using a cursor then use it cursorname%type or cursorname%rowtype.

Answer Question  Select Best Answer

jayanthanr

 Profile Answers by jayanthanr Questions by jayanthanr

• Jan 8th, 2008

To created flat files, or read flat files in a procedure or function, the built-ins in the UTL_FILE package can be used.

Answer Question  Select Best Answer

archie123

• Aug 28th, 2007

Yes you can use commit or rollback in exception block;select * from test123;A----------51 Declare s varchar2(2); Begin update test123 set a = a+10; select a into s from test123 where a=20; exception...

Answer Question  Select Best Answer

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

There are hundreds of build-ins avialable few ones areDBMS_OUTPUT.PUT_LINE, DBMS_SQL, DBMS_DDL, DBMS_PIPE, DBMS_JOB

Answer Question  Select Best Answer

devi123

• Sep 25th, 2007

Declare the collection variable (varrys or PL/SQL tables)?as out parameter for the procedure and fetch the result set into collection variable.

Answer Question  Select Best Answer

Vaibhav Tyagi

• Sep 25th, 2007

You cannot move existing table into a cluster. You can create new tables though, including tables with the same contents as existing tables. In the second. form, query returns a set of rows which...

Answer Question  Select Best Answer

dinu78

 Profile Answers by dinu78 Questions by dinu78

• Dec 21st, 2007

1) First identify the current excecution plan by using showplan.In most cases, creating and then forcing usage of the indexes result in drastic improvement.1) Ensure that indexes(single or composite)&...

Answer Question  Select Best Answer

we have a PRIMARYKEY field with auto generation in sequence of a table of records. If we delete any one of records from the table, how can we update the table implicitly using Trigger?

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

Which table u want to update ,in case if it is the same table then write after delete  trigger on the table and select values from destination table.

Answer Question  Select Best Answer

SELECT APE.DAT_INSERT_DATE as "Payment Entry Date", Case when APE.TXT_INTERMEDIARY_CD is null or APE.TXT_PAYER_CUSTOMER_ID APE.TXT_INTERMEDIARY_CD then (Select TXT_CUSTOMER_NAME from GENMST_CUSTOMER where TXT_CUSTOMER_CD = APE.TXT_PAYER_CUSTOMER_ID) else(Select TXT_INTERMEDIARY_NAME from GENMST_INTERMEDIARY where TXT_INTERMEDIARY_CD = APE.TXT_PAYER_CUSTOMER_ID) End as "Payer Name" , APE.TXT_PAYER_CUSTOMER_ID...

joybanerjee

 Profile Answers by joybanerjee Questions by joybanerjee

• Dec 20th, 2007

create or replace procedure sql_to_procedure as declare cursor c1 is SELECT APE.DAT_INSERT_DATE as "Payment Entry Date",APE.TXT_INTERMEDIARY_CD AS "Intermediary ID",APE.TXT_PAYER_C...

Answer Question  Select Best Answer

prabhatushar

 Profile Answers by prabhatushar Questions by prabhatushar

• Oct 31st, 2007

ORA - 01426 is associated with Numeric  overflow Cause : Evalution of an value expression causes an overflow or underflow.Action : Reduce the operand

Answer Question  Select Best Answer

gan20k

 Profile Answers by gan20k Questions by gan20k

• Jan 14th, 2008

This will delete Collection (eg index by table ) in the range 6,3

Answer Question  Select Best Answer

soorajsk_84

 Profile Answers by soorajsk_84 Questions by soorajsk_84

• Dec 19th, 2007

autonomous transaction  are independent transaction exCREATE OR REPLACE PROCEDURE a1ASPRAGMA AUTONOMOUS_TRANSACTION; BEGININSERT INTO table1 VALUES('autonomous transaction');COMMIT; END;D...

Answer Question  Select Best Answer

How to pass result set using refcursor from one package procedure to another package procedure? and code also

MAQDOOMAAMER

 Profile Answers by MAQDOOMAAMER Questions by MAQDOOMAAMER

• Dec 25th, 2007

CREATE TABLE employees (empid   NUMBER(5),empname VARCHAR2(30));INSERT INTO employees (empid, empname) VALUES (1, 'Dan Morgan');INSERT INTO employees (empid, empname) VALUES (2, '...

Answer Question  Select Best Answer

What are the diffrences between Oracle 8i and Oracle 9i as a Developer, not as a DBA??

bismitapadhy

 Profile Answers by bismitapadhy Questions by bismitapadhy

• Feb 3rd, 2008

ISQl*plus and J-server is not there in oracle-8i which are there in 9iBismita

Answer Question  Select Best Answer