1 / 10

Oracle PL/SQL

Oracle PL/SQL. SQL*Plus. EDIT. Opens notepad with the buffer contents To use type: Edit Ed. Edit commands. List / L1 change/old/new i order by field. SAVE. To save the buffer to file type Save <filename> Save d:a.sql create Save d:a.sql replace Save d:a.sql append

yitro
Download Presentation

Oracle PL/SQL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle PL/SQL SQL*Plus

  2. EDIT • Opens notepad with the buffer contents • To use type: • Edit • Ed

  3. Edit commands • List / L1 • change/old/new • iorder by field

  4. SAVE • To save the buffer to file type • Save <filename> • Save d:\a.sql create • Save d:\a.sql replace • Save d:\a.sql append • Also from the file menu

  5. Get and Start • Get <filename> - to the buffer • Start <filename> - execute script • Spool – from the file menu • Spools the screen to file • End by spool off command

  6. Output format • select * from employee • Column last_name heading lname • Line break: • column last_name heading 'last | name‘ • Width • Column first_name format a8

  7. CLEAR • CLEAR COLUMNS (CL COL) • CLEAR BUFFER (CL BUFF) • CLEAR SCREEN (CL SCR)

  8. SET COMMANDS • SET PAU[SE] {ON | OFF} • SET LIN[ESIZE] NUMBER • SET HEA[DING] {ON | OFF} • SET ECHO {ON | OFF} • SET SERVEROUTPUT {ON | OFF}

  9. Define • Select * from employee where job_id=669 • Define jid=669 • Select * from employee where job_id=‘&jid’ • Undefine jid • Accept jid669

  10. More commands • Prompt text • variable fx number begin :fx :=669; end; • select * from employee where job_id=:fx; • Print fx

More Related