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, 2032🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...