title: what are the equivalent of these various sql table in oracle
body: <p>SQL tables:</p>
  
  <p>sys.types
  sysobjects
  syscolumns
  sysindexes
  INFORMATION_SCHEMA.COLUMNS</p>
  
  <p>Can you also help me convert this to oracle syntax</p>
  
  <pre><code>DECLARE @tableUpdateCount tinyint
  set @tableUpdateCount = 0
  /* 
  * CALCDETL.ALIAS - 1
  */
  if exists (select * from syscolumns where id = (select id from sysobjects where name = 'ABC' and type = 'U') and name = 'ALIAS' and xusertype = (select user_type_id from sys.types where name = 'nvarchar') and prec = 20)
  begin
      set @tableUpdateCount = @tableUpdateCount + 1
      print ' '
      print '1.  ABC.ALIAS exists'
  end
  </code></pre>
  
  <p>are there any tools out there that can easily convert sql-to-oracle syntax?</p>
  
  <p>Thanks!</p>