Oracle Introduction

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



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s