Why do we need view in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')
What is dense_rank?
What is synchronized subquery?
What is the difference between inner join and natural join?
How to call DDL statements from pl/sql?
What is the difference between partition and index?
What is difference between % ROWTYPE and TYPE RECORD ?
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Do we need to create index on primary key?
What is partition by in sql?
Does truncate require commit?
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)