syntex of insert

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an identity?

646


Tell me what is the stuff and how does it differ from the replace function?

634


what is a join and explain different types of joins? : Sql server database administration

619


How to create an index on a view?

676


How to create a user to access a database in ms sql server using "create user" statements?

616






Can you type more than one query in the query editor screen at the same time?

677


Is natural join and equi join same?

617


What do you need to connect php to sql server?

638


What is the use of floor function in sql server?

655


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

674


Explain the different types of joins?

660


What are the new features are introduced in sql server 2012 reporting services?

115


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

592


What is the order in which the sql query is executed?

614


Can we call stored procedure in view in sql server?

596