When is the explicit cursor used ?
No Answer is Posted For this Question
Be the First to Post Answer
What is pl sql and why it is used for?
What are sql functions? Describe in brief different types of sql functions?
what is transaction? : Sql dba
What is partition by in sql?
What is query syntax?
Explain autonomous transaction.
mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com
What is a primary key called that is made up of more than one field?
Why use subqueries instead of joins?
how do you know if your mysql server is alive? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?