000			01970nam a22001577a 4500
008			120711t xxu||||| |||| 00| 0 eng d
020			_a0072255404
050			_aQA76.73.P258 A451
100			_aAllen, Christopher.
245			_aOracle database 10g PL /SQL 101. / _cChristopher Allen.
260			_aNew York : _bMcGraw Hill, _c2004.
300			_axv, 395 p. : _bill. ; _c24 cm.
500			_aIncludes index.
505			_aContents: 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.
942			_2lcc _cBK
999			_c1677 _d9177