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

 

Advertisements

Author: tdmsql

I am a PL-Sql Developer. I am searching some sites sql studies but its bored. i like create studies note my own way. so that i created this site.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s