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 do you understand by a database object? Can you list a few of them?
What are the parameters that we can pass through a stored procedure?
Give the various exception types.
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is a snapshot log?
What is integrity and what is constraint??Explain with example
What is the difference between I and G in Oracle?
How to delete an existing row from a table in oracle?
Is it possible to split the print reviewer into more than one region ?
What is tns service name?
Can a formula column referred to columns in higher group ?
Point out the difference between user tables and data dictionary?
how to make an oracle object
What is where clause in oracle?
How to check the oracle tns settings?
