An Exercise of SQL Using SQL* Plus - презентация, доклад, проект скачать

Нажмите для полного просмотра!

An Exercise of SQL Using SQL* Plus, слайд №1

An Exercise of SQL Using SQL* Plus, слайд №2

An Exercise of SQL Using SQL* Plus, слайд №3

An Exercise of SQL Using SQL* Plus, слайд №4

An Exercise of SQL Using SQL* Plus, слайд №5

An Exercise of SQL Using SQL* Plus, слайд №6

An Exercise of SQL Using SQL* Plus, слайд №7

An Exercise of SQL Using SQL* Plus, слайд №8

An Exercise of SQL Using SQL* Plus, слайд №9

An Exercise of SQL Using SQL* Plus, слайд №10

An Exercise of SQL Using SQL* Plus, слайд №11

An Exercise of SQL Using SQL* Plus, слайд №12

An Exercise of SQL Using SQL* Plus, слайд №13

An Exercise of SQL Using SQL* Plus, слайд №14

An Exercise of SQL Using SQL* Plus, слайд №15

An Exercise of SQL Using SQL* Plus, слайд №16

An Exercise of SQL Using SQL* Plus, слайд №17

An Exercise of SQL Using SQL* Plus, слайд №18

An Exercise of SQL Using SQL* Plus, слайд №19

An Exercise of SQL Using SQL* Plus, слайд №20

An Exercise of SQL Using SQL* Plus, слайд №21

An Exercise of SQL Using SQL* Plus, слайд №22

An Exercise of SQL Using SQL* Plus, слайд №23

An Exercise of SQL Using SQL* Plus, слайд №24

An Exercise of SQL Using SQL* Plus, слайд №25

An Exercise of SQL Using SQL* Plus, слайд №26

Содержание ▲

Вы можете ознакомиться и скачать презентацию на тему An Exercise of SQL Using SQL* Plus. Доклад-сообщение содержит 26 слайдов. Презентации для любого класса можно скачать бесплатно. Если материал и наш сайт презентаций Mypresentation Вам понравились – поделитесь им с друзьями с помощью социальных кнопок и добавьте в закладки в своем браузере.

Слайды и текст этой презентации

Слайд 1

Описание слайда:

Assignment #2 An Exercise of SQL Using SQL*Plus KAIST Myoung Ho Kim

Слайд 2

Описание слайда:

Table of Contents SQL*Plus Oracle SQL*Plus Access to database SQL*Plus Commands Assignment #2 SQL Queries

Слайд 3

Описание слайда:

SQL*Plus

Слайд 4

Описание слайда:

Oracle SQL*Plus An Oracle command-line utility program that can run SQL commands interactively or from a script.

Слайд 5

Описание слайда:

Access to DB using SQL*Plus Install Oracle Client Scroll down to Oracle Database 11g Release 2 Click See All

Слайд 6

Описание слайда:

Access to DB using SQL*Plus (Cont’d) Install Oracle Client Download Oracle Database 11g Release 2 Client Run setup.exe Install ‘Manager’ type

Слайд 7

Описание слайда:

Access to DB using SQL*Plus (cont’d) Run SQL Plus Download tnsnames.ora from course homepage and copy it to (directory that Oracle Client is installed: ex. C:\app\MyDirect\product\11.2.0\client_2)\network\admin Run SQL Plus

Слайд 8

Описание слайда:

Access to DB using SQL*Plus (cont’d) Access to database User-name: s[studentID]@cs360 ex) If your studentID is 20151234, then your user-name is s20151234@cs360 Password: s[studentID] ex) If your studentID is 20151234, then your password is s20151234 It is recommended to change your password for security

Слайд 9

Описание слайда:

SQL*Plus Commands

Слайд 10

Описание слайда:

SQL*Plus Commands SQL*Plus buffer commands LIST List one or more lines of the SQL buffer CHANGE Change text on the current line in the buffer DEL Delete one or more lines of the buffer APPEND Add specified text to the end of the current line in the buffer RUN Execute the SQL command currently stored in the SQL buffer CLEAN BUFFER Erase the SQL command currently stored in the SQL buffer SQL*Plus file commands SAVE Save the contents of the SQL buffer in a host operating system file GET Load a host operating system file into the SQL buffer START Execute the contents of the specified script SPOOL Store query results in an operating system file (.sql) HOST Execute a host operating system command without leaving SQL*Plus EDIT Open a text editor like the notepad to edit an text file (.sql, .lst, etc)

Слайд 11

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands Besides sending SQL statements to the server, SQL*Plus also saves them into a local buffer and allow users to view and change the statements LIST Display one or more lines of the SQL buffer CHANGE Change text on the current line in the buffer RUN(or /) Execute the SQL command currently stored in the SQL buffer

Слайд 12

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands DEL Delete one or more lines of the buffer APPEND/ INPUT Add specified text / line(s) to the end of the current line in the buffer CLEAR BUFFER Erase the SQL command currently stored in the SQL buffer

Слайд 13

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands LIST, CHANGE

Слайд 14

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands RUN(or /), DEL

Слайд 15

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands APPEND

Слайд 16

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus buffer commands INPUT, CLEAR BUFFER

Слайд 17

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus file commands SAVE, GET, START(or @) Save the contents of the SQL buffer into a script file Load a contents of script file into the SQL buffer Execute the contents of the specified script SPOOL Store query results in an operating system file SPOOL result.lst : start to write in result.lst SPOOL OFF : stop to write HOST Execute a host operating system command without leaving SQL*Plus ex) HOST dir : execute a MS-DOS command dir

Слайд 18

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus file commands SAVE, GET, START(or @)

Слайд 19

Описание слайда:

SQL*Plus Commands (cont’d) SQL*Plus file commands SPOOL, HOST

Слайд 20

Описание слайда:

Assignment #2

Слайд 21

Описание слайда:

Submission Due Sep. 23, 2:00 a.m. Delay is not accepted Submission standard [student ID].lst contains the executions of SQL commands and their results. You may use SPOOL command. Upload the .lst file to course homepage Evaluation You will get points if your SQL queries find the right answers. Do not cheat others. Both of them will get no point.

Слайд 22

Описание слайда:

Example Database Create tables for homework. Download HW2db.sql from the course homepage and Copy it to (directory that Oracle Client is installed)\BIN @HW2db.sql or start HW2db.sql

Слайд 23

Описание слайда:

Example Database (cont’d) Database Design You can see all the tables stored in your database using a command ‘select * from tab’

Слайд 24

Описание слайда:

Queries Q1. Find all the tuples in the Printer relation for color printers. Remember that color is a boolean-valued attribute. If a value of color attribute is 1 then the printer is a color printer. If a value of color attribute is 0 then the printer is not a color printer Q2. Find the model number, speed, and hard-disk size for all PC’s whose price is under $800. Q3. Find the manufacturers of laptops

Слайд 25

Описание слайда:

Queries Q4. Find those manufactures that sell PC’s but not Laptops In oracle, the operator for difference of sets is ‘MINUS’ (instead of ‘EXCEPT’) Q5. Find the model number and price of all products (of any type) made by manufacturer C Q6. Find those processor speeds that occur in two or more PC’s