Question to migrate from Mssql Server 7 to Oracle 8

From: Erwin jasinski <hexalog_at_wanadoo.fr>
Date: Thu, 21 Oct 1999 20:41:03 +0200
Message-ID: <7unn6l$chl$1_at_wanadoo.fr>

With MSSQL, to create a missing column, i used:

if not exists (

     select 1
     from  syscolumns, sysobjects
     where sysobjects.name = 'my_table'
       and sysobjects.type = 'U'
       and syscolumns.id = sysobjects.id
       and syscolumns.name = 'my_column'
     )

begin
 alter table my_table add my_column varchar(30) null end
go

With Oracle 8, i can't found the equivalent code to run with SQL Plus. I found the view user_table but not user_columns... I can't use "alter table..." in PL/SQL block.

Thank by advance

Erwin Received on Thu Oct 21 1999 - 20:41:03 CEST