SQL
SQL SELECT. , , , .
1. SQL*PLUS ( sqlplus). scott scott2 ( ) ( /. 166, 165-6?/, scott@xe), tiger
2. EMP, DT DESC (DESCRIBE) (, DESC emp). , . 1.1 1.2.
, 5- ! .
, SQL . . .
, . . , . / .
( ) * , .
.
1. DT ().
2. (). , . Options\Envirement Linesize (80) 200 SET LINESIZE 200. , , ..
1.1 DEPT
1.2 EMP
3. , .
4. , .
5. , , , 1500 1000.
6. : DNAME DEPTNO LOC.
|
|
7. ( ( )), .
8. .
9. , .
10. , . .
11. , .
12. , , 1800.
13. , , 4.
14. , , . : , , 1, 1, 2, 2.
15. , .
16. , .
17. , . .
18. , : , .
19. :
Type | Place | Count_emp |
- | ||
. | ||
- | ||
. , . .
1. .
2. .
3. ( ).
4. .
5. ( ) 2-3 .