Menampilkan struktur table di ORACLE

Barusan sajah penasaran dengan pertanyaan teman satu team.

“Di.. gimana caranya buat nampilin struktur table di ORACLE??” “Kalo di mysql, gw tinggal pake ‘Describe nama_table’ dan keluarannya DataTable. Tapi kok ini kalo di oracle keluar popup ya??”

Oke stelah gooling sebentar berikut syntaxnya :

1. Ms SQL Server : EXEC sp_columns @table_name = table_name;

2. My SQL : describe table_name;

3. ORACLE : select * from user_tab_columns where table_name = ‘table_name’;

 

*Anggap saja ini dokumentasi saya ya, jadi kalo lupa langsung cek blog πŸ˜€

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s