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, 1532🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...