Home » SQL & PL/SQL » SQL & PL/SQL » how to create view using stored procs
how to create view using stored procs [message #226549] Sat, 24 March 2007 23:20 Go to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hai all
i have a doubt about creation of view
can i create view using stored procs, please clarify me
thanks in advance
Ram...
Re: how to create view using stored procs [message #226550 is a reply to message #226549] Sat, 24 March 2007 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Yes, but avoid the urge to do so.
VIEWS are created once.
There is little to no justification to do it from PL/SQL.
Re: how to create view using stored procs [message #226576 is a reply to message #226550] Sun, 25 March 2007 04:49 Go to previous messageGo to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
then
how to create
pls explain the method
Thnks
Ram
Re: how to create view using stored procs [message #226580 is a reply to message #226576] Sun, 25 March 2007 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
then
follow the advice
pls read the documentation (execute immediate)
Thnks
Michel
Re: how to create view using stored procs [message #226588 is a reply to message #226549] Sun, 25 March 2007 07:11 Go to previous message
ddkdhar
Messages: 68
Registered: February 2007
Member

use
execute immediate
Previous Topic: Spool only SQL query result
Next Topic: about date
Goto Forum:
  


Current Time: Sat Dec 10 05:10:33 CST 2016

Total time taken to generate the page: 0.05542 seconds