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 ......
⇒ Select Some Rows from a Table in Oracle
⇐ Select All Columns of All Rows in Oracle
2019-12-19, 1531🔥, 0💬
Popular Posts:
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...