- This release of the course notes guarantees compatibility with Oracle7 Server, Release PL/SQL Release SQL*Plus Release and Oracle Procedure Builder, Release 1.5.5.7.0. - Instructions for using the PowerPoint Slide Show are provided.. - Oracle Procedure Builder is the interface for creating, editing, debugging, and executing the PL/SQL code. - PL/SQL. - Lesson 17: Summary of SQL and SQL*Plus (optional). - Lesson 18: Overview of PL/SQL 20 0 20. - Lesson 21: Developing a Simple PL/SQL Block. - Lesson 23: Controlling Flow in PL/SQL Blocks. - Lesson 26: Summary of PL/SQL (optional). - Description of Demonstration Files. - Lesson 1: Selecting Rows l1prec1.sql Viewing a query containing no parentheses. - l1prec2.sql Executing a query with parentheses to override rules of precedence l1alias.sql Using aliases in expressions l1null1.sql Calculating with nulls l1col.sql Simple SELECT statement Lesson 2: Limiting l2betw.sql Using the BETWEEN operator Selected Rows. - l2in.sql Using the IN operator l2and.sql Using the AND operator. - l2or.sql Comparing results from OR and AND operators. - l2sal1.sql Rules of precedence l2sal2.sql Rules of precedence Lesson 3: Single Row. - l3hire.sql Time portion of the stored date, case sensitivity, fill mode, embedding text (“of”). - Description of Demonstration Files continued. - Lesson 4: Display Data l4cart.sql Executing a Cartesian Product from Multiple Tables. - l4region.sql Displaying aSELECT clause with no aliases. - l4ejoin.sql Displaying a equijoin leading to outer join example. - l4ojoin.sql Displaying an outer join Lesson 5: Group l5count1.sql Using the COUNT. - l5count2.sql Using the COUNT(expr) function l5error.sql Executing a SELECT command. - l5order1.sql Ordering columns that are grouped by DEPT_ID first. - l5order2.sql Ordering columns that are grouped by TITLE first. - l5title1.sql Using a WHERE clause to restrict rows by TITLE. - l5title2.sql Using a HAVING clause to restrict groups by SUM(salary). - Lesson 6: Subqueries No demonstration files.. - Lesson 7: Specifying l7varno.sql Returning all rows Variables at Runtime. - l7varyes.sql Using a case-insensitive query with substitution variables. - l7expr.sql Changing the column names and conditions by using substitution variables.. - l7dbl.sql Using a double ampersand substitution variable l7dlb2.sql Using a double ampersand. - l7prompt.sql Using the ACCEPT and PROMPT commands. - l7param.sql Using the parameter in the command line. - No demonstration files.. - l10obj2.sql Displaying all objects owned by the user based on a supplied value l10cons.sql Viewing constraints on the S_EMP. - Lesson 11: Manipulating l11sel.sql Displaying initial state of the data. - Data l11upd.sql Performing the updates and viewing. - l13dd.sql Displaying USER_SEQUENCES data dictionary structure and contents. - Lesson 14: Creating Views l14emp.sql Creating a view by using aliases l14vu1.sql Creating a view with CHECK. - l14vu2.sql Creating a view without CHECK OPTION. - Lesson 17: Summary of SQL and SQL*Plus. - l19loop.pls Setting a breakpoint.. - l20proc.pls Loading and compiling code from a text file.. - l20func.pls Importing text from a text file.. - l22cust.pls Embedding INSERT commands in a procedure.. - l22newsd.pls Using parameters in a procedure to update a value in the table.. - l22delr.pls Indicating the number of rows affected by using the SQL cursor attributes.. - l23calc.pls Returning a calculated value based on an input value in a function.. - l23iter.pls Executing a loop. - l24up.pls Defining a cursor containing a FOR UPDATE clause, declaring a record based on a cursor, implementing an explicit cursor attribute.. - Lesson 25: Error Handling No demonstration files.. - Appendix C: Using lcplus.sql Various SQL*Plus SET commands SQL*Plus to create. - Reports and Manage lcrpt0.sql SELECT statement used in the report. - PL/SQL code. - lcrpt1.sql SELECT statement and some SQL*Plus commands used in the report. - lcsal.sql Storing code in a text file, creating the file, executing the file, and interpreting the compilation errors.. - Lesson 19: Basics of p19q1.pls COUNT_LOOPS procedure syntax Procedure Builder. - p19q2.pls MY_MESSAGE procedure syntax Lesson 20: Modularizing. - p20q6.pls MY_PROCEDURE procedure syntax. - Lesson 21: Developing a p21q3.pls MULTIPLIER procedure syntax Simple PL/SQL Block. - p21q4.pls ANN_COMP function syntax p21q5.pls MULTI function syntax. - Lesson 22: Interacting p22q1.pls NEW_DEPT procedure syntax with Oracle. - p22q2.pls UPDATE_DEPT procedure syntax p22q3.pls DELETE_DEPT procedure syntax p22q4.pls NEW_EMP procedure syntax Lesson 23: Controlling p23q1.pls SET_COMM procedure syntax Flow in PL/SQL Blocks. - p23q2.pls CUST_UPDATE procedure syntax p23q3.pls EMP_MESSAGE procedure syntax Lesson 24: Processing p24q1.pls TOP_DOGS1 procedure syntax Queries by Using Explicit. - p24q2.pls ADD_STARS procedure syntax Cursors. - p24q3.pls TOP_DOGS2 procedure syntax Lesson 25: Error Handling p25q1.pls UPDATE_DEPT2 procedure syntax. - p25q2.pls SALARY_RANGE procedure syntax. - Lesson 26: Course p26q1a.pls NEW_MEMBER function syntax Summary. - p26q1b.pls NEW_RENTAL function syntax p26q1c.pls MEM_TITLES procedure syntax p26q1d.pls RESERVE_MOVIE procedure. - p26q1e.pls RETURN_RENTAL procedure syntax. - p26q1f.pls DAMAGED_COPY procedure syntax. - p26q1g.pls TOP_RENTAL procedure syntax Appendix C: Using. - SQL*Plus to create. - pcloop.sql COUNT_LOOPS procedure syntax Reports and Manage. - PL/SQL code pcmsg.sql MY_MESSAGE procedure syntax
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt