Home » RDBMS Server » Server Administration » VIEWS and Stored Procedure
VIEWS and Stored Procedure [message #370159] Tue, 26 December 2000 13:18 Go to next message
Anu
Messages: 82
Registered: May 2000
Member
Is it possible to create a VIEW on a stored Procedure in ORacle 8.1.5 ??

Thanks in advance

Report message to a moderator

Re: VIEWS and Stored Procedure [message #370162 is a reply to message #370159] Tue, 26 December 2000 13:58 Go to previous message
Lee
Messages: 56
Registered: May 1999
Member
Sure, use EXECUTE IMMEDIATE:

EXECUTE IMMEDIATE 'create view my_view as select col_1, col_2 from my_tables';

Report message to a moderator

Previous Topic: Possible to access DB2 data on MF from PL/SQLv8 on Unix?
Next Topic: Unique constraint Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:44:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.