Syntax: INSERT INTO <Table-Name> ( Col1,Col2....) VALUES(Val1,Val2.

what is the syntax of INSERT command?

Question Posted / vara prasad vizag

7 Answers
10745 Views
I also Faced
E-Mail Answers

Answer Posted / vara prasad vizag

Syntax:
INSERT INTO <Table-Name> ( Col1,Col2....)
VALUES(Val1,Val2...);

Example:
INSERT INTO StudentInfo (Studno,Fname,Lname,DOB,DOJ, Gender)
VALUES(1234,'Varaprasad','Vizag','17-Nov-85','M');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we create database in oracle using command line ?

1132

if you ctreate table identity

2428

What is backup in Oracle?

1076

Name the three major set of files on disk that compose a database in Oracle?

1170

Explain the use of file option in exp command.

1177

What are the various types of snapshots ?

1082

Explain what are the characteristics of data files?

1136

How to display employee records who gets more salary than the average salary in the department?

1126

What is the max number of columns in an oracle table?

1047

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1833

How to delete all rows a table in oracle?

1119

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

Is java required for oracle client?

1047

How to create a new table in your schema?

1129

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1993