79684

About SQL

To perform many of its opcrations, EM Exprcss submits structurcd query languagc (SQL) statcments to thc databasc. SQL (pronounced like seąuel) is an industry-standard

English-like Computer programming languagc 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 languagc that can also be used to perform a variety of databasc administration tasks. The following SQL statement creates thc database user nick and

assigns him a password of your choosing. rcprcscntcd by password:

CREATE USER nick IDENTIFIED BY password;

Whcn performing some administrative tasks in EM Exprcss. you can click Show SQL to sce thc SQL statcments that EM Exprcss generates and submits.