-
SQL Query Tuning Considerations
While tuning SQL query what should be taken into consideration?
-
Call PL/SQL function
How to call a PL/SQL function in another PL/SQL function? Is it possible? Give example?
-
Autonomous Transcation
What are advantages of Autonomous Transcation?
-
External Table
Define External Table
-
Load White Space Delimited Data
How to load whitespace delimited data using SQL*Loader?
-
Load Tab Delimited Data
How to load tab delimited data using SQL*Loader?
-
SQL*Loader Procedure
How to call a procedure in SQL*Loader?
-
Return Multiple Rows
How to return more than one row through functions? Explain with example.
-
How do you Optimize query
How can i choose which query is best?i.e On which factors i can choose the best query?
-
Job scheduling
How can i schedule a procedure every day at 10 pm