|
Related Questions |
View Answer |
|
What is Character Functions?
|
View Answer
|
|
What is Date Functions?
|
View Answer
|
|
What is NVL?
|
View Answer
|
|
How to debug the procedure ?
|
View Answer
|
|
What is trigger,cursor,functions in pl-sql and we need sample programs about it?
|
View Answer
|
|
Can Commit,Rollback ,Savepoint be used in Database Triggers?If yes than HOW? If no Why?With Reasons
|
View Answer
|
|
In pl/sql functions what is use of out parameter even though we have return statement.
|
View Answer
|
|
How we can create a table through procedure ?
|
View Answer
|
|
What is ref cursor?
|
View Answer
|
|
What is pl/sql?what are the advantages of pl/sql?
|
View Answer
|
|
State the advantage and disadvantage of Cursor?
|
View Answer
|
|
State the difference between implicit and explicit cursor's.
|
View Answer
|
|
What is difference between stored procedures and application procedures,stored function and application function?
|
View Answer
|
|
Explian rowid,rownum?What are the pseduocolumns we have?
|
View Answer
|
|
1)What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
|
2)What is meant by forward declaration in functions - PL-SQL Interview Questions & Answers">
View Answer
|
|
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
|
View Answer
|
|
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...
|
View Answer
|
|
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
|
View Answer
|
|
How to disable multiple triggers of a table at at a time?
|
View Answer
|