METHOD

PostgreSQL

Example

Here is a simple SQL command using PostgreSQL:

CREATE TABLE all_games (
  title varchar(100),
  developer varchar(100),
  year_published int
);

Output

On running the above command, no explicit output is returned on successful execution in PostgreSQL.

Explanation

The above SQL command creates a new table named all_games using CREATE TABLE statement in PostgreSQL. This table includes three columns: title (type varchar(100)), developer (type varchar(100)), and year_published (type int).

Oracle

In Oracle SQL, one of the commonly used methods is the SELECT statement, which is used to select data from a database.

Example

SELECT * FROM Employees;

Output

1   John   Doe   30
2   Jane   Doe   25
3   Alice  Smith 35
4   Bob    Jones 40

Explanation

The SELECT statement is used to select data from a database. The data that is being returned by this statement will be from the columns in the Employees table. The asterisk (*) is used to indicate that we want to select all columns.