What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ?
How many types of index are there?
What is a REF CURSOR? Compare strong and week ref cursor types.
Does indexing improve query performance?
What is sql injection owasp?
why use cursors?
what are the demerits of sql?
What is a trigger in pl/sql?
What is the command used to fetch first 5 characters of the string?
What is TABLE SPACE?
Why use subqueries instead of joins?
write a procedure to find top second no from a list of numbers
Can we use distinct and group by together?