what is the difference between delete and truncate statement in sql? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between having clause and where clause?
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
How to fetch the rows by dynamicaly passing table name through cursor?
How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?
What is multiple partition?
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??????
what are date and time data types? : Sql dba
Types of joins?
What is substitution variable in pl sql?
What can sql server reporting services do?
What is query execution plan in sql?
Why do we need a foreign key?
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)