I have 4.8 years worked in Oracle Platform. Later i join another company i start work on Sql Server. Now i developing through this page i will get my knowledge back. i will improve Oracle skill.
Oracle mostly worked on Sql commands or Toad tool in last company.
I remain what are the work i did in Oracle
- Database creation
- privileges given user to the database
- Dump data in run command >> cmd
- connect user
- check all table using TAB commend
- dual command used for function check
- dml,ddl,dcl almost same as sqlserver
- cursor used
- dynamic datatype used in tables
- rownum used for get first records
- i can used in query compare with two columns at a time
- package is used two three procedure and function combine to work single task. its easy to split and avoid redundency reduce.
i will post. what are remain my mind and what are tisk i used last company