How to Write a Basic Select Statement in SQL Plus

You can display all the date in a table by using the select statement. By using * asterisk in a select statement it displays the data of all the columns in the table

Example 1:  select * from team;

Where team is the table name and ( * ) Asterisk is a wildcard character  which displays all the data in the table along with all the columns

oracle

Selecting Specific Columns

Example 2:

If you want to display certain columns from the team table then you need to write the name of the columns after the (*) Asterisk.Question 1) Display First_name, Sex, Age from team

Answer)        select first_name,sex,age from team;

oracle

In similar manner you can write your own statements and display the required results.

 

Leave a Reply