About SQL

About SQL
To perform many of its operations, EM Express submits structured query language
(SQL) statements to the database. SQL (pronounced like sequel) is an industry-standard
English-like computer programming language for querying and updating databases.
The following is an example of a SQL query that lists information about countries in a
countries table, which is owned by user hr:
SELECT COUNTRY_ID, COUNTRY_NAME FROM HR.COUNTRIES;
SQL is a powerful language that can also be used to perform a variety of database
administration tasks. The following SQL statement creates the database user nick and
assigns him a password of your choosing, represented by password:
CREATE USER nick IDENTIFIED BY password;
When performing some administrative tasks in EM Express, you can click Show SQL
to see the SQL statements that EM Express generates and submits.
... zobacz całą notatkę