OraFAQ Forum: Training & Certification » Inserting

Home » Other » Training & Certification » Inserting

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inserting [message #360094]

Wed, 19 November 2008 10:25

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?

Report message to a moderator

Re: Inserting [message #360111 is a reply to message #360094]

Wed, 19 November 2008 11:45

Michel Cadot
Messages: 68633
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

Barbara Boehmer
Messages: 9082
Registered: November 2002
Location: California, USA

Senior Member

Perhaps because you can

INSERT INTO some_table SELECT * FROM orders;

Report message to a moderator

Re: Inserting [message #360594 is a reply to message #360149]

Fri, 21 November 2008 09:12

registereduser
Messages: 52
Registered: June 2008
Location: Toronto

Member

By that way, SELECT can be used in associate with any kind of others.

Report message to a moderator

Re: Inserting [message #360675 is a reply to message #360594]

Sat, 22 November 2008 01:20

Frank
Messages: 7901
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.

Report message to a moderator

Re: Inserting [message #360748 is a reply to message #360675]

Sun, 23 November 2008 21:21

registereduser
Messages: 52
Registered: June 2008
Location: Toronto

Member

Haha, you are right

Report message to a moderator

Previous Topic:	schema object (merged)
Next Topic:	To be callable from a SQL expression, a user-defined funcation must do what?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 15 23:11:54 CDT 2024