OraFAQ Forum: Forms

Home » Developer & Programmer » Forms » DDL

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

DDL [message #156697]

Fri, 27 January 2006 03:01

shekhar_bhadauria
Messages: 12
Registered: June 2005
Location: delhi

Junior Member

we can use "CREATE OR REPLACE" IN VIEWS,PROCEDURE,TRIGGER, FUNCTION they all are objects, yet TABLES are also objects but we cannot use REPLACE while table creation?
i will be very thankful.

shekhar

Report message to a moderator

Re: DDL [message #156873 is a reply to message #156697]

Sun, 29 January 2006 03:15

awan
Messages: 9
Registered: September 2005
Location: Riyadh

Junior Member

can u plz make it clear .......wat actually u want to ask.....

Report message to a moderator

Re: DDL [message #156904 is a reply to message #156697]

Sun, 29 January 2006 19:30

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yes ... that is true ... probably because there are options associated with the 'drop table' statement.

David

Report message to a moderator

Re: DDL [message #156918 is a reply to message #156904]

Sun, 29 January 2006 22:35

shekhar_bhadauria
Messages: 12
Registered: June 2005
Location: delhi

Junior Member

We have DROP options with procedure,views also, then why REPLACE key word is not used with create table?

Report message to a moderator

Re: DDL [message #156920 is a reply to message #156918]

Sun, 29 January 2006 22:49

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

DROP PROCEDURE does NOT have options. DROP VIEW does NOT have options.

David

Report message to a moderator

Re: DDL [message #156934 is a reply to message #156920]

Mon, 30 January 2006 03:29

shekhar_bhadauria
Messages: 12
Registered: June 2005
Location: delhi

Junior Member

sorry to bother you again, can you describe me what type of options are you talking about. please explain me.
i will be very thank ful to you.

shekhar

Report message to a moderator

Re: DDL [message #157034 is a reply to message #156934]

Mon, 30 January 2006 16:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

An option is an 'option' as defined in the literature. Please read the documentation for the Oracle database.

May I suggest that you just ACCEPT that 'table' requires two commands, a 'drop' and a 'create', and that a 'procedure' can be handled with a single 'create or replace'. Tables contain data, procedures are self-contained.

David

Report message to a moderator

Re: DDL [message #157055 is a reply to message #157034]

Tue, 31 January 2006 01:52

shekhar_bhadauria
Messages: 12
Registered: June 2005
Location: delhi

Junior Member

thanks a lot.
i will touch you when feel any problem?
thank u again

shekhar

Report message to a moderator

Previous Topic:	Changes in Forms Property Palette are not set to what I selected
Next Topic:	What Is FormWeb.Cfg?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:32:27 CDT 2024