Difference between SQL Server and Oracle

I. Syntax differences.

1. Table Data Replication
· Data replication in the database
Ms SQL Server
Insert into copy table name SELECT statement (copy table already exists)
Select field list into copy table name from table (copy table does not exist)
· Oracle
Insert into copy table name SELECT statement (copy table already exists)
Create Table copy table name as select statement (the copy table does not exist)

II. Object.

1. Temporary table.

Temporary tables, the main advantage is that the operation does not leave any trace, do not generate logs, so the speed is fast
· Ms SQL Server
Create Table # Table Name (...) or select field expression list into # table name from
Add # before the table name. These temporary tables are only valid during a database connection session.
· Oracle
2. Trigger.

· Ms SQL Server

Use inserted and deleted similar to the temporary table

3. Stored procedure.

· Ms SQL Server

Returns the result set.

· Oracle

The result set cannot be returned. You must use the reference cursor (ref cursor) to return the result set.