What is procedure explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
what is the main difference between join and subqurey?
what is 'mysqladmin' in mysql? : Sql dba
Define implicit and explicit cursors.
What is mutating table error?
what are the limitations of identity column? : Transact sql
What is scope and visibility in PL/SQL?
How many types of cursors are available in pl/sql?
What is an alias command?
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
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).
what is difference between pass by value and eference by value in oracle plsql
How can I make sql query run faster?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)