SQL Tutorial

SQL (pronounced as “ess-que-el”) stands for Structured Query Language.

SQL is used to modify and access data from a database and is used by most common relational database management systems like Oracle, Sybase, Microsoft SQL Server, Access, etc.

Oracle SQL Tips

<—– SQL Tutorial —–>

  1. SQL Interview Questions and Answers – 1
  2. Difference Between DDL, DML and DCL Commands
  3. What is the Difference between Truncate and Delete in Oracle
  4. How to Delete Duplicate Rows from a Table
  5. Joins – Left outer, Right outer and full outer
  6. Transpose Rows into Columns
  7. Transpose Rows to Columns/Columns to Rows in Oracle
  8. The following method will help you to create PIVOT tables in Oracle.
  9. SQL Tips: LAG and LEAD Analytic Functions
  10. Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions
  11. NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle
  12. How to Create Index in Oracle SQL with Example
  13. How to use LPAD and RPAD Function
  14. Alter Table Command in Oracle SQL
  15. Create Normal Table and Global Temporary Table in Oracle
  16. Create a Table from another Table in Oracle SQL

Time to time we update SQL tutorial so keep visiting our website……

<—– End SQL Tutorial —–>

Get Free Blogging Tips & Technology updates in your Email !!!

Subscribe via RSS feed

The following two tabs change content below.
Anil Verma
IT Blogger Tips focus on Blogging Tips, SEO Tips, Social Media, SQL Tips, PL/SQL Tips, Oracle DBA, Linux/Unix, Latest Technology, How Tos and Technical Solutions. You can find us on Facebook | Twitter |
Find on Google+

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)