Home -> Usenet -> comp.databases.oracle -> How to turn this simple SQL-Server script into Oracle equivalent?

How to turn this simple SQL-Server script into Oracle equivalent?

From: DL <DONLCS_at_YAHOO.COM>
Date: 14 Nov 2001 14:13:43 -0800
Message-ID: <f9e448cc.0111141413.5a4c83a1_at_posting.google.com> 






declare _at_c int


set _at_c = (select count(*)

         from dba_ind_columns
         where table_name='dba_constraints')


if (_at_c=0)


  create index ind_con on dba_constraints (table_name)




Thanks.



DL
Received on Wed Nov 14 2001 - 23:13:43 CET












Original text of this message