SQL & Oracle 1

[Guest_imported]

Is there place on the Web which translates which Oracle means what in SQL. For example, if you want to get description of a table in Oracle, you say 'DESC tablename', you can't use DESC in MS SQL? What is the command?

 

[tlbroadbent]

This article contains an Oracle/SQL Server cross reference.

http://msdn.microsoft.com/library/en-us/dnsqlsm/html/oracle2sql.asp

The sp_help stored proceduren in SQL Server provides a table description.

exec sp_help mytable Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.