|
Question |
Rating |
View Answer |
|
how many types of stored procedure? |
|
View Answer |
|
How one call DDL statement using stored procedures in Oracle? |
|
View Answer |
|
If get_product_name is my procedure called in my stored procedure. here in my procedure i am passing a value directly but i need to pass the value to the procedure dynamically. How it is possible? |
|
View Answer |
|
What is cursors? |
|
View Answer |
|
Explain about the RETURN statement? |
|
View Answer |
|
Explain about the process which takes place to execute a Stored routine? |
|
View Answer |
|
Explain about recursive stored procedures? |
|
View Answer |
|
Explain the benefits of running stored procedure on a database engine? |
|
View Answer |
|
Explain about the implementation of business logic in Stored procedures? |
|
View Answer |
|
Explain about the difficulties faced by the database developer in implementing pre compiled statements? |
|
View Answer |
|
Does storing of data in stored procedures increase the access time? Explain? |
|
View Answer |
|
State about the security aspects of stored procedures? |
|
View Answer |
|
State the different extensions for stored procedures? |
|
View Answer |
|
Explain about the implementation of stored procedures? |
|
View Answer |
|
What is the difference between a user defined function and a Stored procedure? |
|
View Answer |
|
What are the uses of stored procedure? |
|
View Answer |
|
what is the Difference between View and Stored Procedure? |
|
View Answer |
|
Where the procedures are stored in database? |
|
View Answer |
|
Can we use commit inside the trigger? If not then how can we save the transxaction made by the trigger? |
|
View Answer |
|
How can we call stored procedures inside store procedures? |
|
View Answer |