How can we delete records in a table using update table? - update table employee set emp_name = null where emp_id=10

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

SQL

DETAILS

Question: How can we delete records in a table using update table?

Answer: update table employee
set emp_name = null
where emp_id=10

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8461 users
Added on	4/9/2015
Views	69903
Rate it!

Question: How can we delete records in a table using update table?

Answer:

update table employee
set emp_name = null
where emp_id=10 Source: CoolInterview.com

Answered by: kanya | Date: 7/21/2010 |

Contact kanya

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Table1 Date Inv No. Sr.No. 01/04/2009 1 1 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/4/2009 5 2 table2 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 2 2 01/04/2009 2 2 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/04/2009 4 1 04/4/2009 5 2 I want sql query or PL/SQL Block to update the Sr.No. field automatically as shown in the above tables. Sr.No is not entered Manually. This sr.No. should be updated by selecting the date range i.e. from date and two date.	View Answer
	How do we select the employees detail from the table who were joined in the last 5yrs?	View Answer
	State some reasons for lack of portability?	View Answer
	State about some criticisms of SQL?	View Answer
	Explain about Data definition?	View Answer
	Explain about COMMIT and ROLLBACK?	View Answer
	Explain about the MERGE field?	View Answer
	Explain about data retrieval?	View Answer
	Explain the where clause?	View Answer
	Explain the ORDER BY clause?	View Answer
	Explain about predicates and statements?	View Answer
	State the several languages into which SQL is divided into?	View Answer
	Explain about the information and definition schemas?	View Answer
	Explain about XML related specifications?	View Answer
	Explain about the object language binding’s extension?	View Answer
	Explain about Call level interface present in SQL?	View Answer
	Explain about the original design and basics which gave life to SQL?	View Answer
	Explain about SQL?	View Answer
	Explain about SQL related to RDBMS?	View Answer
	You want to include a carriage return/linefeed in your output from a SQL script, how can you do this?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All SQL Interview Questions & Answers - Exam Mode / Learning Mode