oracle10g英文原廠培訓(xùn)preface

1、PrefaceProfileBefore You Begin This CourseBefore you begin this course, you should be able to use a graphical user interface (GUI). The prerequisite is a familiarity with data processing concepts and techniques.How This Course Is OrganizedOracle Database 10g: SQL Fundamentals I is an instructor-led

2、course featuring lectures and hands-on exercises. Online demonstrations and written practice sessions reinforce the concepts and skills that are introduced.Related PublicationsOracle PublicationsTitlePart NumberOracle Database Reference 10g Release 1 (10.1) B10755-01 Oracle Database SQL Reference 10

3、g Release 1 (10.1) B10759-01 Oracle Database Concepts 10g Release 1 (10.1) B10743-01 Oracle Database Application Developers Guide -Fundamentals 10g Release 1 (10.1) B10795-01 SQL*Plus Users Guide and Reference B12170-01 Additional PublicationsSystem release bulletinsInstallation and users guidesread

4、.me filesInternational Oracle Users Group (IOUG) articlesOracle MagazineTypographic ConventionsWhat follows are two lists of typographical conventions that are used specifically within text or within code.Typographic Conventions Within TextConventionObject or TermExampleUppercaseCommands,Use the SEL

5、ECT command to viewfunctions,information stored in the LAST_NAMEcolumn names,column of the EMPLOYEES table.table names,PL/SQL objects,schemasLowercase,Filenames,where:roleis the name of the role italicsyntax variables,to be created.usernames,passwordsInitial capTrigger andAssign a When-Validate-Item

6、 trigger tobutton namesthe ORD block.Choose Cancel.ItalicBooks, names ofFor more information on the subject seecourses andOracle SQL Reference manuals, andManualemphasized words or phrasesDo not save changes to the database.Quotation marksLesson moduleThis subject is covered in Lesson 3,titles refer

7、enced“Working with Objects.”within a courseTypographic Conventions (continued)Typographic Conventions Within CodeConventionObject or TermExampleUppercaseCommands,SELECT employee_idfunctionsFROM employees;Lowercase,Syntax variablesCREATE ROLE role;italicInitial capForms triggers Form module: ORDTrigger level: S_ITEM.QUANTITYitemTrigger name: When-Validate-Item. . .LowercaseColumn names,. . .table names, OG_ACTIVATE_LAYERfilenames, (OG_GET_LAYER (prod_pie_layer)PL/SQL