What is use of package in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
How many levels can subqueries be nested in a FROM clause?
How to get the 3rd column(i.e all the data along with the column name)in a table?
Explain foreign key in sql?
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
What is self-join and what is the requirement of self-join?
Types of optimization?
Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.
How to revise and re-run the last sql command?
How do I run a program in pl sql?
Are pl sql variables case sensitive?
What are all the ddl commands?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Oracle (3253)
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)