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
What is the difference between substr and instr?
What are the advantages of oracle 12c?
How to retrieve values from data fields in record variables?
What are the common oracle dba tasks?
Can you create a synonym without having a table?
What are the major difference between truncate and delete?
Can you drop an index associated with a unique or primary key constraint?
What is the use of aggregate functions in oracle?
What is bulk copy or bcp in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are dml statements in oracle?
What are the attributes that are found in a cursor?
Explain the use of analyse option in exp command.
How would you go about verifying the network name that the local_listener is currently using?
Explain overloading. Can functions be overloaded?