How many types of cursors are available in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is sql?
How do you run a query?
use of IN/ANY/ALL
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
What does sql stand for?
What does (+) mean in sql joins?
What is trigger point?
How does rowid help in running a query faster?
What is the size of partition table?
Can variables be used in sql statements?
pl/sql testing means what ...... explain process how to find pl/sql bugs