How can I delete duplicate rows?
what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )
What is pl sql block structure?
What are two parts of package ?
What is a natural join sql?
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?
How do you update a value in sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
how many triggers are allowed in mysql table? : Sql dba
what is purge command explain about oracle performance tuning
2 Answers Accenture, eCentric Solutions,
Is crud a cuss word?
what is online transaction processing (oltp)? : Sql dba
What are three advantages to using sql?