1. Below SP apply for all records of the Table UPDATE <table name>

what is the syntax of UPDATE command?

Question Posted / vishal b. patel

8 Answers
12095 Views
I also Faced
E-Mail Answers

Answer Posted / vishal b. patel

1. Below SP apply for all records of the Table

UPDATE <table name> SET <column name>=<new value>

----------------
2. Below SP apply for those records which are match with
the <condition>...

UPDATE <table name> SET <column name>=<new value> WHERE
<condition>

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is merge statement used for?

985

How do I reset a sequence in oracle?

1067

How to invoke the data pump export utility?

1137

Explain oracle left join with an example?

963

How many types of table in Oracle?

1081

How many memory layers are in the oracle shared pool?

1127

How to concatenate two text values in oracle?

1072

Can we connect to ORACLE db using Windows Authentication?

1199

What is a lookup table in oracle?

947

master table and child table performances and comparisons in Oracle ?

2095

What is the database name in oracle?

988

What is an index associated with a constraint?

998

Can we commit inside a function in oracle?

933

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1972

How would you go about verifying the network name that the local_listener is currently using?

2007