Okay, I stillthink I like my own scripts to extract ddl better :)
--- Cyril Thankappan <[EMAIL PROTECTED]> wrote:
>
>
> U r right ..I still dunno 'much' about perl..
>
> as for dbms_metadata
>
> it is a built in pl/sql package
>
> saying
>
> 'select dbms_metadata.get_ddl(object_type,obj
Cyril Thankappan wrote:
>
> U r right ..I still dunno 'much' about perl..
>
> as for dbms_metadata
>
> it is a built in pl/sql package
>
> saying
>
> 'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;
>
> gives the entire ddl creation script.
>
> However, 'interes
U r right ..I still dunno 'much' about perl..
as for dbms_metadata
it is a built in pl/sql package
saying
'select dbms_metadata.get_ddl(object_type,object_name,schema_name) from dual;
gives the entire ddl creation script.
However, 'interestingly'
execute dbms_metadata.get_d
as.net> cc:
Sent by: Subject: Re: Due apologies for DDLs
[EMAIL PROTEC
dbms_metadata, a package that will let you pull ddl for objects out of
the database in a readable format.
joe
Jared Still wrote:
> For those of us that are still 9i ignorant, you will need to
> explain your comment about 'dbms_metadata'.
>
> As for 'Perl expertise', you obviously don't know
ORA-0666"Warning. You have pushed the JaredPERL button."
Cause: // You pushed the button.
Action: // Stop it.
-Original Message-
Sent: Thursday, January 03, 2002 10:15 AM
To: Multiple recipients of list ORACLE-L
For those of us that are still 9i ignorant, you will need to
expl
And also, may I point out that most of us are still on
8x and even 7x.
mkb
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> show=y gives you a very unreadable, unusable
> (without major editing)
> file.
>
>
> --- Cyril Thankappan <[EMAIL PROTECTED]>
> wrote:
> >
> > Hi
> >
> > With due a
For those of us that are still 9i ignorant, you will need to
explain your comment about 'dbms_metadata'.
As for 'Perl expertise', you obviously don't know much
about it.
Jared
On Wednesday 02 January 2002 23:55, Cyril Thankappan wrote:
> Hi
>
> With due apologies to Perl fans and shell scri
show=y gives you a very unreadable, unusable (without major editing)
file.
--- Cyril Thankappan <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> With due apologies to Perl fans and shell script
> fans,
> I have failed to understand why
> to obtain these DDLs
> the import option of "show=Y indexfile=ddl_