What is the difference between SQL and Oracle?
SQL :
- SQL Server Support only Windows and Linux operating systems.
- there is packages are not taken place in SQL server
- While It is less Powerful than Oracle
- Sql is developed by Microsoft
- It uses auto increment
- Changes in try catch sequence and capturing the error logs
- Ranking function is not same that we use in SQL
- To modify the existing procedure we are using "Alter proc Procename"
- Into keyword is used to store the table data
- we can uodate table using join on multiple table
Oracle :
- Oracle support operating system such as windows, Linux, Solaris, HP-UX, OS X,etc.
- While There is packages are that take place in Oracle
- It is more powerful than SQL server
- Developed by Oracle
- It uses Sequence
- Oracle try catch exception handling sequence are different than SQL
- Ranking function is not same that we use in Oracle
- to modify the procedure in Oracle syntax is "Create or Replace Proc ProcName"
- In oracle Into keywords is used to store the values in variable.
- We can not update table which contain the multiple table in Join.