sama.. saya malah dapat pesan ini:
SQL> select sys.dbms_metadata.get_ddl('TABLE','rs') FROM dual;
ERROR:
ORA-31603: object "rs" of type TABLE not found in schema "OSCAR"
ORA-06512: at "SYS.DBMS_METADATA", line 1546
ORA-06512: at "SYS.DBMS_METADATA", line 1583
ORA-06512: at "SYS.DBMS_METADATA", line 1901
ORA-06512: at "SYS.DBMS_METADATA", line 2792
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
----- Original Message -----
From: Dany Agustiyanto
To: [email protected]
Sent: Thursday, December 21, 2006 3:17 PM
Subject: Re: [indo-oracle] Show create table di Oracle
kok saya coba qery tersebut error yah.
ERROR at line 1:
ORA-00904: invalid column name
Indra Armansyah <[EMAIL PROTECTED]> wrote:
SQL> set long 10000
SQL> SELECT sys.dbms_metadata.get_ddl('TABLE', 'NAMA_TABLE') FROM dual;
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: Oscar Wilyanto
To: [email protected]
Sent: Thursday, December 21, 2006 2:19 PM
Subject: [indo-oracle] Show create table di Oracle
Dear Masters,
Apakah Oracle punya perintah untuk menampilkan SQL syntax pembuatan tabel
yang sudah eksis? (di MySQL menggunakan 'show create table nama_tabel')
Thanks in Advance,
Oscar
----------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
MKD Group, www.mkdgroup.com
----------------------------------------------------------
[Non-text portions of this message have been removed]
----------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.0.409 / Virus Database: 268.15.26/594 - Release Date: 12/20/2006
[Non-text portions of this message have been removed]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
------------------------------------------------------------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and delete
this e-mail from your system. E-mail transmission cannot be guaranteed to be
secure or error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. MKD Group therefore
does not accept liability for any errors or omissions in the contents of this
message, which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
MKD Group, www.mkdgroup.com
------------------------------------------------------------------------------
[Non-text portions of this message have been removed]
