About SQL

Nasza ocena:

5
Wyświetleń: 553
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
About SQL - strona 1

Fragment notatki:

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ę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz