book

Oracle Web Applications: PL/SQL Developer's Intro

by Andrew Odewahn

September 1999

Intermediate to advanced

256 pages

7h 5m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Goal of This Book
The Internet Grows Up
Content ManagementFinding what you needKeeping sites up to dateTracking changesApplication DevelopmentNo single platform is scalable enoughDevelopers must know too many platformsApplication Integration and Electronic Data Interchange (EDI)
The Internet File SystemHTMLXMLPL/SQLWebDBOracle Application ServerJavaInternetLiteOracle LiteEnterpriseSync LiteAQ LiteInternetLite server and APIOracle interMediaText dataMultimedia dataSpatial dataAdvanced QueuingDefine the message payloadCreate and start the queue tablesEnqueue and dequeue messages to/from a queueFunctional Summary of Oracle8i Web Products
Connect the Database to the Web Using OAS or WebDBDevelop Web Applications with HTML and PL/SQLWhy HTML?Why PL/SQL?So why not Java?Start Learning XML

Resources
The TCP/IP NetworkThe Communication PortThe HyperText Transfer Protocol (HTTP)The Web BrowserThe Uniform Resource LocatorThe Resource MIME TypeA Helpful Analogy
The HTTP ListenerThe PL/SQL Gateway
The PL/SQL ToolkitA PL/SQL ExampleCalling the ExampleUsing a query stringUsing an HTML formParameter arraysParameter gotchas
Database UsersDatabase ObjectsPrivilegesSystem privilegesObject privilegesRolesAdditional Security Precautions
Overview of WebDBDatabase AdministrationBrowse database objectsAdminister WebDB and database securityMonitor database and application performanceApplication DevelopmentBuilding database objectsBuilding user interface componentsBuilding shared componentsBuilding custom componentsContent-Driven Web Site ManagementUser-uploaded contentManaging contentControlling access to content
The PL/SQL GatewayConfiguring a Database Access Descriptor (DAD)DAD parametersConfiguration fileThe HTTP ListenerServer settingsVirtual directory mappingsMIME type mappingsConfiguration file
How OAS Returns Web ResourcesStatic Resources Mapped to a Virtual DirectoryDynamic Resources Mapped to the CGI GatewayDynamic Resources Mapped to the Web Request BrokerCartridgesWRB Executable EnginesWRB dispatcher
Connection ManagementDatabase Access DescriptorPL/SQL agentParameter PassingSecurity Issues with the PL/SQL Cartridge
Programming in HTMLLearning the LanguageSyntaxTagsAttributesA sample document
Structural TagsText Formatting TagsContent Flow TagsAnchor TagsList TagsTable TagsForm TagsThe < form> tagThe <input> tagThe <select> tagThe <textarea> tagCleaning up the formBeware Browser-Specific Extensions
Structured Programming in PL/SQLProceduresFunctionsParametersCalling Procedures and FunctionsPositional notationNamed notationOverloadingPermissions
CommentsVariablesDeclaring a variableNameDatatypeDefault valueAssigning valuesConstantsConditionalsLoopsCursorsDeclaring a cursorProcessing a cursorImplicit cursorsIndex-by Tables (Arrays)Creating an index-by tableAdding elements to an index-by tableRetrieving elements from an index-by table
The Package SpecificationThe Package BodyExampleUsing a PackageInformation HidingVariable Persistence Throughout a Session
TOADPL/Formatter
Communicating with the Outside WorldHTP: Generating HTMLWebAlchemyHTF: Parsing HTML
OWA_TEXT: Representing TextData structuresProceduresExampleDesign noteOWA_PATTERN: Searching and Replacing TextRegular expressionsData structuresProcedures and functionsThe MATCH function.The AMATCH function.CHANGE.Example
OWA_COOKIE: Storing CookiesData structuresProcedures and functionsThe SEND procedure.The REMOVE procedure.The GET function.The GET_ALL procedure.OWA_OPT_LOCK: Record LockingData structuresProcedures and functionsThe STORE_VALUES procedure.The VERIFY_VALUES function.The GET_ROWID function.The CHECKSUM function.
OWA_UTIL: Creating Complex HTML StructuresDebuggingThe SHOWPAGE procedure.The SHOWSOURCE procedure.The GET_PROCEDURE function.The WHO_CALLED_ME procedure.Querying the environmentThe PRINT_CGI_ENV procedure.The GET_CGI_ENV function.The IP_ADDRESS datatype.The GET_OWA_SERVICE_PATH function.Representing datesThe CHOOSE_DATE procedure.The DATETYPE datatype.The TODATE function.HTML and HTTP utilitiesThe SIGNATURE procedure.The MIME_HEADER procedure.The STATUS_LINE procedure.The REDIRECT_URL procedure.The HTTP_HEADER_CLOSE procedure.Creating complex HTML structuresThe TABLEPRINT function.The BIND_VARIABLES procedure.The CELLSPRINT procedure.The LISTPRINT procedure.The CALENDARPRINT procedure.OWA_SEC: Managing Security
Designing a Web ApplicationEvaluate Development OptionsCreate a StoryboardCreate a Data ModelUse PL/SQL Packages
StoryboardData ModelImplementation NotesThe EMP_SURVEY PackageSpecificationBodyThe display_survey_list procedureThe answer_survey procedureThe process_survey procedureThe view_results procedureSecurity PrivilegesSummary
StoryboardData ModelImplementation NotesThe GENERAL_FORM PackageSpecificationBodyThe FORUM_USERS PackageSpecificationBodyThe login_form procedure.The login procedure.The get_current_user function.The create_user_form procedureThe save_user_info procedure.The FORUM PackageSpecificationBodyThe print_thread_links procedure.The current_ forum_list procedure.The view_message procedure.The create_msg_form procedure.The save_message procedure.Security PrivilegesWhat Next?
Motivations for XML
SpecificationBody
Books