Site icon IT Tutorial

Oracle SQL Tutorials – Chapter 1 (Part 2 of 3)

SELECT Statement

 

SELECT STATEMENT SYNTAX

 

ORALCE HR SCHEMA & TABLES

 

SELECT ALL COLUMNS OF A TABLE

SELECT * FROM hr.employees;

 

SELECT SPECIFIED COLUMNS OF A TABLE

SELECT first_name, last_name, salary, hire_date FROM hr.employees;

 

GIVE ALIAS TO COLUMNS

 

SELECT first_name NAME, last_name SURNAME , salary “SALARY”,hire_date as “Hire Date” FROM hr.employees;

 

You can continue to read from this link ;

https://ittutorial.org/2019/04/02/oracle-sql-tutorials-chapter-1-3/

Exit mobile version