|
Question |
Rating |
View Answer |
|
State the advantage and disadvantage of Cursor?
|
|
View Answer |
|
What is trigger,cursor,functions in pl-sql and we need sample programs about it? |
|
View Answer |
|
Explain the usage of WHERE CURRENT OF clause in cursors ? |
|
View Answer |
|
What are two parts of package ? |
|
View Answer |
|
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
|
|
View Answer |
|
What is ref cursor? |
|
View Answer |
|
What is Pragma EXECPTION_INIT ? Explain the usage ? |
|
View Answer |
|
What is Mutating SQL Table? |
|
View Answer |
|
What is difference between stored procedures and application procedures,stored function and application function?
|
|
View Answer |
|
1)What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
|
|
View Answer |
|
What is TTITLE and BTITLE? |
|
View Answer |
|
What is Transaction? |
|
View Answer |
|
What is Sequences? |
|
View Answer |
|
Where the Pre_defined_exceptions are stored ? |
|
View Answer |
|
State the difference between implicit and explicit cursor's.
|
|
View Answer |
|
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ? |
|
View Answer |
|
In pl/sql functions what is use of out parameter even though we have return statement. |
|
View Answer |
|
What is Minus? |
|
View Answer |
|
How to sort the rows in SQL? |
|
View Answer |
|
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)
|
|
View Answer |