Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the syntax of INSERT command?

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


Please Help Members By Posting Answers For Below Questions

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325


How to write an inner join with the where clause in oracle?

1044


does the query needs a hint to access a materialized view?

1857


How to shutdown your 10g xe server?

1149


How do we represent comments in oracle?

1048


What is meant by an index?

1145


How to grant create session privilege to a user in oracle?

1001


How a tablespace is related to data files?

1109


What are the different types of failures that occur in Oracle database?

1067


What is the maximum number of triggers that can be applied to a single table?

1024


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

2022


What to do if dba lost the system password?

1172


How to write date and time interval literals in oracle?

1035


What is the difference between view and materialized view in Oracle?

1155


Please explain oracle left join with an example?

1046