Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > oracle > answers

how to create a view inside a stored procedure

Newbie
  
Join Date: Sep 2009
Posts: 1
#1: Sep 21 '09
Hi,

Im somewhat new to oracle SP writing. I need to do the following from the SP

1. execute the query
2. create a view and populate with the result of the above query
3 query that view and take the result set to the application

your comments are much appreciated.
amitpatel66's Avatar
Moderator
  
Join Date: Mar 2007
Location: Hyderabad, India
Posts: 2,192
#2: Sep 23 '09

re: how to create a view inside a stored procedure

Check out EXECUTE IMMEDIATE statment to run DDL commands in a Stored Procedure
Reply

« previous question | next question »

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved