Posts

Creating table & Importing data

Image
Create a table using the following steps 1) Right click on Database then click on 'New Table". ( In this Example, LAXMAN BOORUGU  is the Database) 2) Define Column names & size as data available in the data set. In this example, we are importing data from Sales CSV file. 3) We can notice how data is importing into Table.
Post a Comment
Read more

Calculating QTD in Sql (Oracle)

Image
Trunc  Function help us to  reach the first Date of specified Date Level: Date Levels: Year, Quarter, Month, Week. Calculating QTD Dates
Post a Comment
Read more

Showing 10 Records of a table with Selected Columns in SQL (Oracle)

Image
Post a Comment
Read more

Looking at Definition of Table ( Structure of Table) in SQL (Oracle)

Image
Post a Comment
Read more

Showing 10 Records a table in SQL (Oracle)

Image
Post a Comment
Read more

Creating Tables in SQL (Oracle)

Image
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.
Post a Comment
Read more