HOW TO WRITE BASIC SELECT STATEMENT TO RETRIEVE DATA IN ORACLE SQL

SELECTNG DATA:

SYNTAX: Select * from <table_name>; (Note: Here * indicates all columns) or

Select col1, col2, … coln from <table_name>;

Ex:  

select * from student;

Output:

NO	NAME	MARKS
1	Visu	100
2	Vasu	200
3	Manoj	300
4	Aisu	400
5	Mohan	500
6	Manvi	600
7	Namu	500
8	Susu	300
9	Thanu	200
10	AJ	100
11	MK	(null)
12	MD	(null)

   

SELECT NO, NAME FROM STUDENT;

NO	NAME
1	Visu
2	Vasu
3	Manoj
4	Aisu
5	Mohan
6	Manvi
7	Namu
8	Susu
9	Thanu
10	AJ
11	MK
12	MD