Interested to Buy Any Domain ? << Click Here >> for more details...
What is a merge query?
- 1 Answers
- 1216 Views
- I also Faced
- E-Mail Answers
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 |
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is the use of time stamp in select statement?
what are the advantages of using stored procedures? : Sql dba
How do I view tables in mysql?
What are wait events. Describe the wait event tables.
what are wild cards used in database for pattern matching ? : Sql dba
What is the difference between distinct and unique in sql?
What is sqlcontext?
What is native sql query?
how to convert numeric values to character strings? : Sql dba
What is the difference between clustered and non-clustered indexes?
-
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)
