what is the difference between an explicit cursor and select into statement?
Latest Answer: Explicit cursors are those user defined cursors in order to retrive more than one row from a table. Select into statment helps in invoking parmeters into the formal parameters. ...
How can we find the select statement is indexed or not?
Latest Answer: Use "Explain Plan" command ...
Why are we not supposed to include TCL statements in a trigger?
Latest Answer: Directly we cannot give TCL commands in triggers. But by using pragma autonomous_transaction we can give TCL commands in triggers.hope this answer satisfies you. ...
Why PL/SQL does not support retriving multiple records?
Latest Answer: In PL/SQL multiple records can be retrieved only through cursors. ...
How will you debug PL/SQL Code?
Latest Answer: 1. We can debug using toad, pl/sql developer tools. Debug option will be there in these tools. before debugging the package or anything, enable the dbms_output option.or2. Using DBMS_DEBUG Package also we can debug the pl/sql code. ...
How to fill a refcursor with dataset in C#.i want to pass a dataset as parameter and fill a refcursor with the same dataset.
Latest Answer: you need to use ODP.Net connector.In OracleCommand object add OracleParameter object with following propertiesOracleDbType = OracleDbType.RefCursor;Direction= ParameterDirection.Output;give the name of your stored procedures's refcursor parameter ...
what is the maximum size of the message that we can give in dbms_output.putline();
Latest Answer: 255 bytes was the size limits of earlier version of oracle..ie prior to 10 g ..in 10g 32767 byte is the limit.. ...
Mean I heard from Oracle 8i onwards the order of where clause condition does not matter which oracle creates the explain plan...and execute..Is it true?
Latest Answer: Yes the order is important. But it is important for the performance of the query and not for the final result. The output of the query will be the same irrespective of the order in which the join conditions are applied. Ideally the condition that filters ...
Latest Answer: Hi, Yes you can alter table after creation for adding not null constraint.syntax is :- ALTER TABLE tablenameMODIFY (column name) (datatype) NOT NULL;for eg :-ALTER TABLE EMPMODIFY ename VARCHAR2(10) NOT NULLThanks,Gunjan ...
Latest Answer: Through flash back queries you can get the data which has been deleted permanently. Different types of methods are there : Use the following links to get the complete information :http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_fl.htm ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Go Top