what is auto increment? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
how to get enames with comma seperated values by deptwise on emp table?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
How many columns should be in an index?
Does oracle roll back the transaction on an error?
What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.
Can ddl statements be used in pl/sql?
What is a dynamic query?
Types of cursor locks and explanation each of them ?
Can we rollback after truncate?
What is nosql db?
Give the structure of the procedure ?
What are the different types of dbmss?
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)