SQL Environment Commands
Commands for navigating, displaying information, and managing the SQL environment in Oracle SQL.
Getting the Previous Command
Use the following command to retrieve the current system date from the Oracle database:
SQL> select sysdate from dual; SYSDATE --------- 03-NOV-24 SQL> / SYSDATE --------- 03-NOV-24
Clearning the Screen
To clear the screen, use the following command:
SQL> clear screen;
View database name
SQL> SELECT name FROM v$database; NAME --------- FREE
- The output you received (FREE) is the name of the current database you're connected to. It means that the database you’re working with is named FREE.
- In Oracle, the v$database view provides the name and other metadata for the current database instance. The name FREE was likely assigned to this database during its creation, but it doesn't have any special significance in Oracle beyond being its identifier.
Create Table
SQL> CREATE TABLE TOYS ( 2 TOY_NAME VARCHAR2(100), 3 WEIGHT NUMBER 4 ); Table created.
- The above command creates a new table named TOYS with two columns: TOY_NAME and WEIGHT
Insert Command
SQL> INSERT INTO TOYS VALUES ('Dog',1234); 1 row created.
Select Syntax
SQL> SELECT * FROM TOYS ; TOY_NAME -------------------------------------------------------------------------------- WEIGHT ---------- Dog 1234 SQL> SELECT TOY_NAME FROM TOYS ; TOY_NAME -------------------------------------------------------------------------------- Dog SQL> SELECT TOY_NAME,WEIGHT FROM TOYS ; TOY_NAME -------------------------------------------------------------------------------- WEIGHT ---------- Dog 1234