what is the syntax of INSERT command?

Answer Posted / arkchowdary

we use Dept table or Any table Insert Command

Insert into dept(Dname,deptno,location.....)values
('Darway',30,'Sweadon');

Or

Insert into dept values('&dname',deptno,'&location'....)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert character types to numeric types?

768


What are the attributes that are found in a cursor?

825


What to do if dba lost the system password?

824


what is the use of system.effective.date variable in oracle?

868


How do I find my oracle client driver version?

731


What is primefaces used for?

779


How to create a testing table in oracle?

743


What is the difference between substr & instr functions?

823


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1673


What are a collation and state the different types of collation sensitivity?

783


Can we save images in a database and if yes, how?

806


How to export data to a csv file?

831


How to create additional tablespaces for an new database?

776


Can we use bind variables in oracle stored procedure?

677


What is a synonym? What are its various types?

854