insert into (table name) values(fieldname datatype); for ex: insert

syntex of insert

Question Posted / d

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is SubQuery in SQL Server 2008

1023

What is temporal data type?

922

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

How to run sql server 2005 books online on your local system?

961

What is a trace frag?

1085

How to Update from select query in sql server?

1062

What is the usage of sign function?

1115

What are four major operators that can be used to combine conditions on a where clause?

1054

What happens if time-only values are provided as date and time literals?

1019

What do you understand by mirroring?

997

Describe how to use the linked server?

1143

define and explain the differences between clustered and non-clustered indexes.

1196

Define a cross join?

1028

What are the types of sql server?

1054

How use inner join in sql server?

1134