Oracle query for data retrieve or select from table


To select or retrieve data from table SELECT statement is used.

Oracle SELECT Syntax

SELECT values
FROM tables
WHERE conditions;

Here select column_name,column_name specifies only two column data select from table.

SELECT * FROM table_name; query is for select all the data from table.

Example :

SELECT *
FROM students;
NAME AGE ADDRESS PHONE NO
Ritik 18 Berhampur 9668488256
Bilash 20 cuttack 9008434567
Akash 21 Bhubaneswar 8895021341
Nashim 20 Kendrapara 9668434567
Akhilesh 21 Baleswar 8895032456







Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe