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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to write an inner join with the where clause in oracle?
does the query needs a hint to access a materialized view?
How to shutdown your 10g xe server?
How do we represent comments in oracle?
What is meant by an index?
How to grant create session privilege to a user in oracle?
How a tablespace is related to data files?
What are the different types of failures that occur in Oracle database?
What is the maximum number of triggers that can be applied to a single table?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What to do if dba lost the system password?
How to write date and time interval literals in oracle?
What is the difference between view and materialized view in Oracle?
Please explain oracle left join with an example?