State the difference between implicit and explicit cursor's.
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is trigger,cursor,functions in pl-sql and we need sample programs about it?
What is difference between stored procedures and application procedures,stored function and application function?
What is pl/sql?what are the advantages of pl/sql?
What is Raise_application_error ?
Explain the usage of WHERE CURRENT OF clause in cursors ?
How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
Name the tables where characteristics of Package, procedure and functions are stored ?
How to disable multiple triggers of a table at at a time?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
How many types of database triggers can be specified on a table ? What are they ?
Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
In pl/sql functions what is use of out parameter even though we have return statement.
Explain how procedures and functions are called in a PL/SQL block ?
How to debug the procedure ?
What will the Output for this Coding? Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
Explian rowid,rownum?What are the pseduocolumns we have?
State the advantage and disadvantage of Cursor?
What is Pragma EXECPTION_INIT ? Explain the usage ?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
What is TTITLE and BTITLE?
What is ref cursor?
What are two parts of package ?
What are the Restrictions on Cursor Variables?
How we can create a table through procedure ?
What will happen after commit statement ?
Can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is a database trigger ? Name some usages of database trigger ?
Give the structure of the function ?
What is difference between a PROCEDURE & FUNCTION ?
What is SQL Integrity?
What are the return values of functions SQLCODE and SQLERRM ?
The most important DDL statements in SQL are?
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
What is SQL Deadlock?
The IN operator may be used if you know the exact value you want to return for at least one of the columns.
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is trigger,cursor,functions in pl-sql and we need sample programs about it?
What is difference between stored procedures and application procedures,stored function and application function?
What is pl/sql?what are the advantages of pl/sql?
What is Raise_application_error ?
Explain the usage of WHERE CURRENT OF clause in cursors ?
How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
Name the tables where characteristics of Package, procedure and functions are stored ?
How to disable multiple triggers of a table at at a time?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
How many types of database triggers can be specified on a table ? What are they ?
Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
In pl/sql functions what is use of out parameter even though we have return statement.
Explain how procedures and functions are called in a PL/SQL block ?
How to debug the procedure ?
What will the Output for this Coding? Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;
Explian rowid,rownum?What are the pseduocolumns we have?
State the advantage and disadvantage of Cursor?
What is Pragma EXECPTION_INIT ? Explain the usage ?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
What is TTITLE and BTITLE?
What is ref cursor?
What are two parts of package ?
What are the Restrictions on Cursor Variables?
How we can create a table through procedure ?
What will happen after commit statement ?
Can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is a database trigger ? Name some usages of database trigger ?
Give the structure of the function ?
What is difference between a PROCEDURE & FUNCTION ?
What is SQL Integrity?
What are the return values of functions SQLCODE and SQLERRM ?
The most important DDL statements in SQL are?
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
What is SQL Deadlock?
The IN operator may be used if you know the exact value you want to return for at least one of the columns.
No comments:
Post a Comment