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
Why does Oracle not permit the use of PCTUSED with indexes?
How many types of auditing in Oracle?
Explain database link?
How can we delete duplicate rows in a table?
How do I know if oracle is installed on windows?
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 happens if you set the sga too low in oracle?
How to specify default values in insert statement using oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How can we view last record added to a table?
Explain a segment?
What are the differences between lov and list item?
What is an oracle function?
How to get execution statistics reports on query statements?
How do I learn what codesets are available in oracle?
