Does indexing improve query performance?
How do you bind variables in pl sql?
Which data type is a composite type?
How many types of literals are available in pl sql?
What is difference between cursor and ref cursor?
what are different types of keys in sql?
Does execute immediate commit?
how to select unique records from a table? : Sql dba
What is serial sql?
What are the key differences between SQL and PL SQL?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
What is Difference Between delete and Truncate?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
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)