A table in oracle have columns and rows. We have
employees table in HR schema.
Please type this in your SQL prompt
1)
Select * from employees
the above command will give you all the data from the table called employees. If you want to select only some particular columns you can also choose them in the select list.
2) Select last_name, first_name, employee_id from employees
this command will get you the three columns
data.
please note that
- select identifies which columns you choose
- from identifies which table
- SQL statements are not case sensitive (Data in tables is case sense)
- Do not abbreviate or shorten key words which come in due course.
- Use proper indentation so that your queries are always readable and
easy to understand
