Home » Other » Training & Certification » Inserting
Inserting [message #360094] Wed, 19 November 2008 10:25 Go to next message
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
Member
From SQL*Plus, you issue this SELECT statement:

SELECT*
From orders;

You use this statement to retrieve data from a data table for __________. (Choose all that apply)

A. Updating
B. Viewing
C. Deleting
D. Inserting
E. Truncating

Answer: B, D.

Why for D?
Re: Inserting [message #360111 is a reply to message #360094] Wed, 19 November 2008 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who say that D is true?
(I don't mean it is not)

Regards
Michel

[Updated on: Wed, 19 November 2008 11:45]

Report message to a moderator

Re: Inserting [message #360149 is a reply to message #360094] Wed, 19 November 2008 16:16 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
Perhaps because you can

INSERT INTO some_table SELECT * FROM orders;
Re: Inserting [message #360594 is a reply to message #360149] Fri, 21 November 2008 09:12 Go to previous messageGo to next message
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
Member
By that way, SELECT can be used in associate with any kind of others.
Re: Inserting [message #360675 is a reply to message #360594] Sat, 22 November 2008 01:20 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
registereduser wrote on Fri, 21 November 2008 16:12
By that way, SELECT can be used in associate with any kind of others.

Not for truncating.
Re: Inserting [message #360748 is a reply to message #360675] Sun, 23 November 2008 21:21 Go to previous message
registereduser
Messages: 52
Registered: June 2008
Location: Toronto
Member
Haha, you are right
Previous Topic: schema object (merged)
Next Topic: To be callable from a SQL expression, a user-defined funcation must do what?
Goto Forum:
  


Current Time: Mon Dec 05 03:13:23 CST 2016

Total time taken to generate the page: 0.37284 seconds