What is pragma autonomous transaction in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is logical backup in oracle?
Explain the use of inctype option in exp command.
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
What are the different types of databases?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the difference between sharding and partitioning?
Explain what are clusters?
What is bulk load in oracle?
What are main difference between Stored Procedure and Functions.
What's dateware house and what's clustor with practicle example
What is the parameter mode that can be passed to a procedure?