Can you join a table to itself?
No Answer is Posted For this Question
Be the First to Post Answer
write a qurey for finding the length of the sting.
What does truncate mean in sql?
what are the differences among rownum, rank and dense_rank? : Sql dba
How to add Foreign key in a table after the creation of the table?
In a package if we have 10 procedures or functions,How to know which will execute first?
How to convert comma separated string to array in pl/sql?
When do we use triggers?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
What does dml mean?
How do you truncate?
What is nested table in pl sql?
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).
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)