I have worked with Microsoft SQL Server for the past 7 years and still enjoying working with SQL Server. Now I got a chance to explore Oracle Database and here is my experience.
- Noticed Differences
- There is NO DATABASE NAME, instead there is this
- Preferred IDE is Oracle SQL Developer
- After executing query, you need to commit in order to retain the changes.
SELECT TOP Nis not that easy compared to SQL Server.
An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.
VARCHAR is reserved by Oracle to support distinction between
empty string in future, as ANSI standard prescribes.
VARCHAR2 does not distinguish between a NULL and empty string, and never will.
If you rely on empty string and NULL being the same thing, you should use VARCHAR2.
This can be done easily by right clicking the line number section in the IDE, then
Toggle Line Numbers.
CREATE USER <UserName> IDENTIFIED BY <Password>; GRANT CONNECT , RESOURCE, DBA TO <UserName>;
We can use the inbuilt function
utl_raw.cast_to_raw which transforms a
varchar2 into a
Update TABLE_NAME SET COL_NAME = utl_raw.cast_to_raw('SOME_STRING');
I just started exploring Oracle Database, so this post can be considered as a draft for now, more coming.