Home » SQL & PL/SQL » SQL & PL/SQL » how can i create view in function??
how can i create view in function?? [message #38224] Wed, 03 April 2002 07:45 Go to next message
Abdalla Fawaz
Messages: 1
Registered: April 2002
Junior Member
how can i create view in function or procedure?

Report message to a moderator

Re: how can i create view in function?? [message #38225 is a reply to message #38224] Wed, 03 April 2002 08:12 Go to previous message
Rajarshi
Messages: 11
Registered: November 2001
Junior Member
Use this....

EXECUTE IMMEDIATE 'create view x as select * from y';

Report message to a moderator

Previous Topic: Update from multiple tables
Next Topic: Reference Cursor and wrap utility
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 08:22:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.