dbms_metadata.get_ddl in Sql*Plus [message #494076] |
Fri, 11 February 2011 05:03 |
Roachcoach
Messages: 1576 Registered: May 2010 Location: UK
|
Senior Member |
|
|
This is probably something quite trivial but I tend to use Sql Dev for things like this and the issue isn't there (yay for training wheels GUI)
Below is an output of the code I'm running, the package is much longer than is showing!
SQL> select dbms_metadata.get_ddl('PACKAGE','MVIEW_REFRESH_API','BATCHP') metad from dual;
CREATE OR REPLACE PACKAGE "BATCHP"."MVIEW_REFRESH_API"
AS
/**
How do I have it show the full output?
NB: It happens in both listed versions of sqlplus
[Updated on: Fri, 11 February 2011 05:04] Report message to a moderator
|
|
|
|
|
|
|
Re: dbms_metadata.get_ddl in Sql*Plus [message #494082 is a reply to message #494081] |
Fri, 11 February 2011 05:14 |
|
ramoradba
Messages: 2456 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
ind> select table_name||' Is the ' ||COMMENTS
2 from dict
3 where TABLE_NAME like '%SOURCE';
TABLE_NAME||'ISTHE'||COMMENTS
----------------------------------------------------------------------------------------------------
USER_SOURCE Is the Source of stored objects accessible to the user
ALL_SOURCE Is the Current source on stored objects that user is allowed to create
DBA_SOURCE Is the Source of all stored objects in the database
--------------------------------------
6 rows selected.
[Updated on: Fri, 11 February 2011 05:16] Report message to a moderator
|
|
|
|