Warning: mb_convert_encoding(): Unable to detect character encoding in /var/www/u2150601/data/www/ae-books.online/wp-content/themes/twentyfifteen/content.php on line 442
Oracle SQL. 100 . 20
300 . 500 . 1000 . SQL.
Oracle SQL. 100
20
SQL.100
,2019
ISBN978-5-0050-0618-9
Ridero
20 .
300 .
500 .
1000 .
:
,
IT-.
. . 20.
, , ORACLE.
, . ORACLE, , , .
ORACLE, , , .
, , , ORACLE.
, ORACLE , , .
, XX , , , , .
, , .
, ORACLE, - - , , MS SQL PostgreSQL, MySQL; DWH-, .
Ƞ , , , .
, . , , - , .
ORACLE, , Java, SAS, Python, - JavaScript, NodeJS.
, ORACLE , , , ORACLE Siebel CRM, JVA, ORACLE Service Bus, ORACLE.
, SQL , .
www.sqladv.ru (http://www.sqladv.ru/)
, .
1. SQL,
, . .
20 IT-. , , .
Ӡ IT- sqladv.ru, , , SQL.
: , , SQL .
ORACLE SQL . ORACLE .
IT- sqladv.ru, , 堖 , , , , .
, , .
, .
,
, .
, , .
. , , , , , , , .
, ?
, .
-
- , . , , , - 蠖 .
- . , , SQL.
, - -, - - (, ), SQL .
, . SQLite. SQLite , , SQL, .
. , , , , , Ѡ . . Ƞ , .
. , , . , - .
, , , , 蠖SQL.
SQL,
Structured Query Language (SQL) .
SQL . SQL , .
SQL . SQL , .
SQL . . , , .
, Ġ , ORACLE, MS SQL, MYSQL.
SQL , .
, , ꠖ , .
SQL ORACLE.
, , ORACLE SQL , .
PHP, ?
, PHP SQL, , .
?
SQL , .
NoSQL , ?
NoSQL , SQL, .
Ѡ ?
Ѡ . .
2. . .
SQL , , . , , , . , SQL- .
100, : 100, , SQL . . 蠖 : SQL.
, , :
1.堖 , , , .
2. ࠖ , . .
3. , , .
4. ⠖ , .
5. , , .
,
, , SQL sqladv.ru.
, , .
, , , , , , .
, .
, 蠫 . , , .
; .
Ġ , . : ORACLE, MS SQL, mySQL, PostgreeSQL.
Ġ , , .
.
Ƞ .
, .
, -.
ORACLE , , , .
.
https://apex.oracle.com/pls/apex/ (https://apex.oracle.com/pls/apex/)
.
1. APPEX
SQLADV, student1 student1.
: student2/, student2, student3/, student3 student11/, student11).
.
SQL Workshop, SQL ComMANd.
SQL-.
:
SELECT * FROM AUTO;
RUN SQL, .
, .
ORACLE .
- , .
SQL-.
, , , .
http://sqlfIDdle.com/ (http://sqlfiddle.com/).
ORACLE 11gr2.
, . :
http://sqladv.ru/dev/sql.txt (http://sqladv.ru/dev/sql.txt).
BuildSchema.
SQLFIDlle .
SQLFIDdle .
:
SELECT * FROMMAN
RUN SQL, .
2. SQLFIDlle
, .
- ?
, APEX.
APEX, . ?
. SQLADV.
SQLFIDlle .
, , Ġ ORACLE 11g. , .
3. . . ORACLEAPEX
51 -, 51 , .
, SQL , , . 堖 .
, , , .
. .
, , , , .
. :
(AUTO) .
.
, .
, , , , , .
.
SQL.
, 蠖 .
.
.
. , , .
, . , , AUTO, , , MAN, CITY.
, SQL.
, , .
10 .
. Ѡ : SQL- ?
Ѡ : GROUPBY.
Ƞ .
.
, SUM, MAX, MIN, COUNT? .
.
.
, : AUTO BMW .
AUTO BMW .
ORACLEAPEX
- ORACLE APEX , . , APEX, .
ʠ APEX .
APEX SQL Workshop, OBJECT BROWSER.
, , .
4.
. .
TABLEs. , .
.
.
, :
TABLE ;
Data ;
INdexes ;
ConstraINts ;
Grants ;
SQL SQL- . SQL- , .
.
: SEQUENCEs, Function, Procedures, Packages.
5. Fn_CITY_NAME
- .
?
, 20 .
, ?
sqladv.ru (http://sqladv.ru/) ⠫, , .
SQLFIDele , ORACLE APEX?
, SQLFIDele , , .
, ?
, ࠖ . , 80 .
1. ?
2. ?
3. APEX ?
4. APEX ?
4.
, , . WORD EXCEL, , .
, , .
SQL- ORACLE , ORACLE:
;
: 1024;
, ;
, ;
. , ;
, , SQL PL SQL. ;
.
젖 .
, .
, c SQL.
.
, , . , NOT NULL.
, , .
.
MAN , .
MAN:
PHONEnum , MAN, ;
CITYCode , CITY;
FirstName ( );
LAStName ( );
YearOld ( ).
CITY , :
CITYCODE , CITY ( );
CITYNAME ( );
PEOPLES , , ( ).
AUTO .
AUTO:
REGnum ( );
PHONEnum , MAN;
MARK ( );
COLOR ( );
ReleASeDT , / ( ).
AUTO1 AUTO , AUTO, , (, CITY1, MAN1).
:
6.
, . ?
, , .
PHONEnum , ?
. , (VARCHAR2) ; , , .
SQL , , ?
ALTER TABLE, .
1. ?
2. , ( ) ?
3. CITY?
4. MAN ?
5.
SQL : , , ; , ; .
, , . , , 頖 .
SQL ORACLE- , .
, SQL ORACLE. - , . , VARCHAR2 4000.
.
.
( ) , .
, :
VARCHAR2 (n) , . , ;
NUMBER , , ;
DATE 蠖 -, , , .
.
VARCHAR2 , , . , , ?
, , , . , , , .
SQL , ORACLE, ?
, MS SQL VARCHAR, VARCHAR2, CLOB TEXT. , , .
ORACLE SQL VARCHAR2, VARCHAR, MS SQL-?
ORACLE SQL VARCHAR, , ORACLE SQL :
VARCHAR 2000, VARCHAR2 4000;
VARCHAR, NULL VALUES.
ORACLE VARCHAR2.
1. DATE?
2. , ?
3. ?
4. ?
6.
, , , . 4( ) :
;
, ;
( ).
1. , SQL , SQL.
, GROUP, , GROUP BY, FROM, SELECT, INSERT,KEY.
2. ; , , , , ( ), .
3. , , , , : MANS, CARS, STAFF , , , GOODS , ITEMS .
, , .
, , SQL.
SQL CREATE TABLE.
.
CREATE TABLE (
Column_NAME1 column_type (NUMBER, VARCHAR2 (n) DATE) primaryKEY,
Column_NAME 2column_type (NUMBER, VARCHAR2 (n) DATE),
Column_NAMEn column_type (NUMBER VARCHAR2 (n) DATE)
);
.
(NUMBER, VARCHAR2 (n), DATE), , , (/).
VARCHAR2 (n) VARCHAR2 .
, CREATE TABLE, 堖 : MANS, GOODS, ITEMS .
.
, SQL:
1. :
;
;
;
.
CREATE TABLE furnit (artikl VARCHAR2 (50) PRIMARY KEY, NAME VARCHAR2 (50),partCOUNT NUMBER, partnum NUMBER);
2. -:
;
;
;
;
.
CREATE TABLE shopINgcart(
article VARCHAR2 (50) PRIMARYKEY
,itemNAME VARCHAR2(50)
,buyerNAME VARCHAR2(50)
,itemCOUNT NUMBER
,dtbuyDATE
);
:
;
;
;
;
.
CREATE TABLE plant
(
NAMEteam VARCHAR2 (15),
numteam NUMBER PRIMARYKEY,
MANCOUNT NUMBER,
crDATE DATE,
dirToDo VARCHAR2(30)
);
SQL ?
SQL , , .
Create TABLE Tab1 (TABno INteger PRIMARY KEY, NAME VARCHAR2 (10));
Create TABLE Tab1 (TABno INteger PRIMARY KEY, NAME VARCHAR2 (10));
CREATE TABLE Tab1 (TABNo INTEGER PRIMARY KEY, NAME VARCHAR2 (10));
SQL , , - ?
SQL , , , .
:
CREATE TABLE TAB1 (TABno INteger PRIMARY KEY, NAME VARCHAR2 (10));
:
CREATE TABLE
TAB1(
TABno INteger PRIMARYKEY,
NAME VARCHAR2 (10));
:
CREATE TABLE TAB1 (TABno INteger PRIMARY
KEY, NAME VARCHAR2
(10));
:
CREATE TABLE
PRIMARYKEY
TAB1 (TABno INteger,
NAME VARCHAR2 (10));
1. .
CREATE TABLE ORACLE1 (81NAME VARCHAR2 (20), ITEMS NUMBER);
.
.
, (https://www.litres.ru/book/maksim-mihaylovich-c/oracle-sql-100-shagov-ot-novichka-do-professionala-43200700/chitat-onlayn/) .
Visa, MasterCard, Maestro, , , , PayPal, WebMoney, ., QIWI , .