-
-
Inventory
How to restrict the item in INV?
-
-
-
SET Operator
What is a SET operator? What are the types what is the difference between SET operators and JOINS?
-
DOS command
How to execute DOS Commands from SQL prompt?
-
Table and Column Level Locks
How to handle the table level locks and column level locks?
-
CBO & RBO
What is CBO and RBO? What is diff between these two?
-
Explain Plan and TKPROFF
What is explain plan and what is tkproff?
-
Tune SQL Query
How can you tune the query?
-
Display time with sysdate
How to display time with sysdate?
-
Describe table without DESC Command
How to desc table data without using desc command
-
Nested and Normal Table
What is the difference between Nested Table and Normal Table?
-
Transfer AP to GL
How to transfer from AP to GL?
-
PL/SQL tables
How will implement the PL/SQL tables?
-
Oracle Water mark
What is water mark apporach in SQL?
-
SQL and PLSQL
What is the difference between SQL & PLSQL?