Home » SQL & PL/SQL » SQL & PL/SQL » select statement
select statement [message #18669] Sun, 10 February 2002 18:36 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
My problem is i need a single SELECT statement which will compile all the procedures,views,packages and triggers in the user's schema. I know that
exec dbms_utility.compile_schema('SCHEMA_NAME');
will do it for me. But I need to get this done using a single SELECT statement.
Please advice.

Report message to a moderator

Re: select statement [message #18682 is a reply to message #18669] Mon, 11 February 2002 02:04 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

i am afraid there is no option like that. select statement is to select the data .u cam write dynamic pl/sql or use compile_schema.

cheers
pratap

Report message to a moderator

Previous Topic: DECODE Function
Next Topic: Can I assign an alias for a group of columns?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:50:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.