Hello,
My company is using Oracle 10g and MS SQL Server 2008 R2.
I'm not DBA but I am assigned to run some queries against MS SQL. I am quite comfortable with SQL for basic level ( this is enough at this phase)
Now I have to play with Oracle DB. Again ... my role would be just 'basic' i.e. run some select statements, get data , maybe sometime update something ... i.e. nothing very complex.
My company policy does not allow me to install any Oracle distribution on my PC hence I decided to try Application Express as a sandbox. Well I just need to get familiar with syntax, semantic and etc. In other word I'm going to use it as a sandbox.
DBA is using SQL Developer application to work with our DB.
My questions
Where could I get reference e.g. web site or tutorial or etc with SQL syntax that would work in Application Express since some TSQL commands does not work in Oracle. As far as I understand PL/SQL syntax/commands are different than SQL but I think it'll work for my needs anyway ..
Thanks