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 ,       .


