What is a merge query?
Answer / kiran r
Merge is an important SQL Statement that allows us to perform Insert, Update, Delete all at a time with out having to write separate logic. we can specify on which we need to perform merge.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain alias in sql?
Why are sql stored procedures used?
What is data abstraction in sql?
How to set up sql*plus output format in oracle?
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 is 'mysqldump'? : Sql dba
What is cursor status?
What is parameter substitution in sql?
What is a schema? How is it useful in sql servers?
what is datawarehouse? : Sql dba
How do you remove duplicate records from a table?
Explain the working of 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)