Analysis with SQL

Trunc  Function help us to  reach the first Date of specified Date Level: Date Levels: Year, Quarter, Month, Week. Calculating QTD Dates

There are several Ways of creating Tables in Oracle either creating Manually, using the Tools or Copying the Structure of other Table. 1) Manually Creating a table and inserting the data 2)  Creating a table and importing the data  Using Tool 3) Copying Structure from Other Table.