What action do you have to perform before retrieving data
from the next result set of a stored procedure ?
Why functions are used in sql?
what is timestamp in mysql? : Sql dba
What is acid property in a database?
Explain Connect by Prior?
how to install mysql? : Sql dba
How can we implement rollback or commit statement in a trigger?
what are the different index configurations a table can have? : Sql dba
How to select unique records from a table?
What is left inner join in sql?
What is difference between sql and excel?
What is online transaction processing (oltp)?
How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).