Collections:
Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle?
✍: FYIcenter.com
If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments":
SQL> SELECT location_id, department_name FROM DEPARTMENTS; LOCATION_ID DEPARTMENT_NAME ----------- ------------------------------ 1700 Administration 1800 Marketing 1700 Purchasing 2400 Human Resources 1500 Shipping 1400 IT 2700 Public Relations 2500 Sales 1700 Executive ......
2019-12-19, 736👍, 0💬
Popular Posts:
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle dat...
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...