Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / subba rao
INSERT COMMAND CAN BE USED IN TWO WAYS
1.TO INSERT ALL VALUES INTO TABLE : VALUES INSERT INTO
<TABLE NAME> VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)
2.TO INSERT INTO SPECIFIED VALUES : INSERT INTO <TABLE
NAME> (<COL_NAME1>,<COL_NAME2>...<COL_NAMEN>)VALUES
(<COL_VALUE1>,<COL_VALUE2>...<COL_VALUEN>)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to drop an existing view in oracle?
What is a read write transaction in oracle?
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.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to define an oracle cursor variable?
What is using clause and give example?
What is an external table?
How to filter out duplications in the returning rows using oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is a nvl function?
What is archive log in Oracle?
How a database is related to tablespaces?
How to create id with auto_increment on oracle?
What is a procedure in oracle?
What are the logical operations?
