01970nam a22001577a 4500 120711t xxu||||| |||| 00| 0 eng d 0072255404 QA76.73.P258 A451 Allen, Christopher. Oracle database 10g PL /SQL 101. / Christopher Allen. New York : McGraw Hill, 2004. xv, 395 p. : ill. ; 24 cm. Includes index. Contents: Database basics: Introduction to databases: What exactly is a database? -- How is a database different from a spreadsheet? -- How will knowing this will help you? -- History of SQL -- SQL command categories -- Storing and retrieving data: The basics: Putting your toe in the water -- Creating tables -- Inserting data - additional techniques -- Viewing data - additional techniques -- Advanced data manipulation: Limit which records you select -- Change the order of records -- Show only unique values -- Select from DUAL -- Modify data in a table -- Remove records from a table -- Transaction control -- Controlling SQL *plus: Edit commands -- Copy and paste -- Clear the SQL *plus environment -- Produce more readable output -- Spool output to disk -- SQL script file -- Advanced SQL: SQL functions: Commonly used single - row functions -- Commonly used group functions -- Using indexes and constraints: Indexes -- Ensure data integrity: Constraints -- Relationships between tables -- Write subqueries -- Other useful oracle techniques: Transfer data between tables --Rename a table -- Alter a table's structure -- Other database objects -- Create programs using PL / SQL: Introduction to PL / SQL: What is PL/SQL -- Structure of PL /SQL block -- Create a simple PL / SQL procedure -- PL / SQL variables and consonants -- Control structures in PL / SQL -- Error handling -- More PL / SQL tools: Coding conventions -- More on PL / SQL and oracle server interaction -- Timing operations -- PL /SQL packages -- Triggers. lcc BK 1677 9177 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4510 4719/12 2012-07-11 00:00:00 1 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4511 4720/12 2012-07-11 00:00:00 2 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4512 4721/12 2012-07-11 00:00:00 3 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4513 4722/12 2012-07-11 00:00:00 4 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4514 4723/12 2012-07-11 00:00:00 5 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4515 4724/12 2012-07-11 00:00:00 6 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4516 4725/12 2012-07-11 00:00:00 7 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4517 4726/12 2012-07-11 00:00:00 8 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4518 4727/12 2012-07-11 00:00:00 9 2012-07-11 BK 0 0 lcc 0 0 WIUC-1 WIUC-1 GEN 2012-07-11 0 QA76.73.P258 A4519 4728/12 2012-07-11 00:00:00 10 2012-07-11 BK