-
DATATYPES
1-WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?2-WHAT IS THE USE OF UROWID?3-WHAT ARE THE SUBTYPES?GIVE ANY 2 EXAMPLE?4- WHAT IS THE GENERAL STANDARD FOR DECLARATION?
-
Status of Procedure
If a procedure is referring a table and if the structure of the table is changed, lets say data type of the any column is changed, then is it possible that the status of the procedure remains valid? Explain
-
DeCode Performance
Performance wise which is a better option if-else construct or a decode? Why
-
Infinite Loop
How will you stop an infinite loop without closing the program?
-
PL SQL Procedure in Package
Procedure in package perfomes fastly over normal procedure, Explain.
-
Purpose of Ref cursor and OUT parametr in PLSQL Function?
What is the purpose of Ref Cursor and OUT Parameter in PLSQL Function? Give Examples for each?
-
How to find error line of a package at run time
How can the error line can be identified for a package at run time ?
-
Paging In Oracle
Hi All,I have requirement of sending the records based on the input received from web.I have a ref_cursor returning 30 rows..Here I am supposed to do paging on the set of records present in the above ref cursor.If web gives 1 , then I should send first 10 records in the ref cursor..If gives 2 , then I should send next 10 records in the ref cursor..similarly�..I will get some sort of indicator from...
-
-
-