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
What is an oracle database table?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
what's query optimization and without use of IN AND Exist can we get another way data from query
How to use fetch statement in a loop?
How to recover a dropped table in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Explain rename?
Write a trigger example in oracle?
what is the difference between functional dependecy and multilevel dependency?
What are the different types of partitions in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
6. Display the client name and order date for all orders using the traditional method.
How to save query output to a local file?
Can a formula column referred to columns in higher group ?
What is an oracle data file?
