MY Introduction:

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 knowledge.

Oracle mostly worked on Sql commands or Toad tool in last company.

I remain what are the work i did in Oracle

  1. Database creation
  2. privileges given user to the database
  3. Dump data in run command >> cmd
  4. connect user
  5. check all table using TAB commend
  6. dual command used for function check
  7. dml,ddl,dcl almost same as sqlserver
  8. cursor used
  9. dynamic datatype used in tables
  10. rownum used for get first records
  11.  i can used in query compare with two columns at a time
  12. package is used two three procedure and function combine to work single task. its easy to split and avoid redundency reduce.
  13. etc.,

i will post. what are remain my mind and what are tisk i used last company

 

Advertisements