Oracle Database :: are create table using stored procedure?


	are create table using stored procedure? hai every body are u known this question are you create table using stored procedure? On Apr 13, 9:09 am, lakshmana@gmail.com wrote: > hai every body > are u known this question > are you create table using stored procedure? Please look up 'EXECUTE IMMEDIATE' in the PL/SQL documentation for your version. Please do NOT ask questions you could easily look up yourself in the documentation. Please not a properly designed application does NOT create anything through stored procedures. -- Sybrand Bakker Senior Oracle DBA -----------------------------------------------Reply----------------------------------------------- Indeed. Please don't say that you want to create a temporary table via a stored procedure as per other non-Oracle databases. -----------------------------------------------Reply----------------------------------------------- On Apr 13, 4:35 am, "dombrooks" <dombro@hotmail.com> wrote: > Indeed. Please don't say that you want to create a temporary table via > a stored procedure as per other non-Oracle databases. Lakshmana, before designing and coding any Oracle applications I suggest you take the time to read some of the official documentation especially: Application Developers Guide - Fundamentals PL/SQL User's Guide and Reference Reading these will prove very beneficial. HTH -- Mark D Powell -- -----------------------------------------------Reply----------------------------------------------- lakshmana@gmail.com wrote: > hai every body > are u known this question > are you create table using stored procedure? You can do so using either Native Dynamic SQL or the DBMS_SQL built-in package. But before you engage in a bad practice just because you can, or just because that is how it is done in other unrelated products check out Global Temporary Tables and read at least one of Tom Kyte's books from cover-to-cover. The fact that you CAN do something doesn't mean you should NOT. -- Daniel A. Morgan University of Washington damor@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org

MS Dynamics CRM 3.0

Oracle Database

are create table using stored procedure?