28 Basic Examples to Learn Oracle

28 Basic Tutorials to Learn Oracle

Oracle is a database that responds very well with excellent performance in demanding environments. Also it is a major database which along with its added features passes the ACID test, which is important in insuring the integrity of data. This is very important because data is the heart of any system in organization. In this age, to learn Oracle as well as imply its accordingly has become a must for a database expert or developer to serve an organization with her demands.

So, here I have taken little steps to bring Oracle being familiar with. I think learning oracle by examples is a matter of couple of hours, trust me & follow me.

After completing this part you will be familiarized with:

  • Connect to Oracle Database Server
  • Create & Drop User, Create,Truncate & Drop Table in Oracle Database Server
  • Insert, Update and Delete To/From a Table in Oracle Database Server
  • Select or Retrieve Data From a Table in Oracle Database Server
  • Use of Commit & Rollback and GRANT & REVOKE in Oracle Database Server
  1. How To Connect Oracle Database AS SYSDBA Example
  2. How To Unlock HR Account in Oracle Database Server Example
  3. How To Connect Oracle Database Server Example
  4. How To Show User Tables In Oracle Database Server Example
  5. How To Create USER In Oracle Database Server Example
  6. How To Drop USER In Oracle Database Server Example
  7. How To GRANT a USER In Oracle Database Server Example
  8. How To REVOKE ROLE from a USER In Oracle Database Server Example
  9. How To Disconnect From Oracle Database Server Example
  10. How To Create Table In Oracle Database Server Example
  11. How To Drop Table In Oracle Database Server Example
  12. How To Truncate Table In Oracle Database Server Example
  13. How To Insert Row In Oracle Database Table Example
  14. How To Insert Specific Columns In Oracle Database Server Example
  15. How To Select Data From Oracle Database Table Example
  16. How To Select Specific Rows From Oracle Database Server Example
  17. How To Select Specific Columns From Oracle Database Server Example
  18. How To Select Data Using Like From Oracle Database Server Example
  19. How To Use ROWNUM In Oracle Database Server Example
  20. How To Use IS NULL In Oracle Database Server Example
  21. How To Use IS NOT NULL In Oracle Database Server Example
  22. How To Ascending Sort/Order Data In Oracle Database Server Example
  23. How To Descending Sort/Order Data IN Oracle Database Server Example
  24. How To Update Data In Oracle Database Server Example
  25. How To Update Specific Rows In Oracle Database Server Example
  26. How To Delete Specific Rows Data From Oracle Database Server Example
  27. How To Delete Data From Oracle Database Server Example
  28. How To Use COMMIT ROLLBACK In Oracle Database Server Example

I hope above examples help you to learn Oracle. So what next??

  • Coming soon... Joining Tables, Grouping Data, Sub-Query, Functions, many more..

No comments:

Post a Comment

leave your comments here..