syntex of insert
Answers were Sorted based on User's Feedback
Answer / mahathi
insert into tablename (col1,col2,........) values
(val1,val2,........)
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / dk
Insert into tablename (c1,c1,c3,...) values(v1,v2,v3,...)
and we can also use
Insert into tablename values(v1,v2,v3,...)
but in this we must have to know numbers of columns and we
have to insert values for all not null columns
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / d
insert into (table name) values(fieldname datatype);
for ex:
insert into emp values(eno number(3),ename varchar2(20));
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jasmeet kaur
insert into table_name("column_name1","column_name2")
value("value1","value2")
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gajanan.waghode
INSERT INTO table[(cloumn [,cloumn...])]
VALUES (value[,value...]);
with this syntax only one row is inserted at a time.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is index?
What is PROJECTION Operation?
What are “unrepeatable reads”?
What is factless fact table? : sql server analysis services, ssas
Can we call stored procedure in view in sql server?
What is difference between getdate and sysdatetime in sql server 2008?
What is inner join in sql server joins?
Do you know the cursor types?
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Explain indexed views and partitioned view with their syntax.
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
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)