SQL and PL/SQL for Oracle 10g Black Book (Record no. 49062)

MARC details
000 -LEADER
fixed length control field 02191nam a2200169Ia 4500
005 - DATE & TIME
control field 20250130104724.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 240411s9999||||xx |||||||||||||| ||und||
020 ## - ISBN
Price 529.00
International Standard Book Number 978-8177227109
040 ## - CATALOGING SOURCE
Original cataloging agency School of Computer Application Library
082 ## - DDC NUMBER
Classification number 005.74
Book Number DES
100 ## - MAIN ENTRY--PERSONAL NAME
Personal name Deshpande,P.S
245 #0 - TITLE STATEMENT
Title SQL and PL/SQL for Oracle 10g Black Book
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Name of publisher, distributor, etc Dreamtech Press
Date of publication, distribution, etc 2009
Place of publication, distribution, etc New Delhi
300 ## - PHYSICAL DESCRIPTION
Pages 980p.
500 ## - GENERAL NOTE
General note he book brings to you the complete, latest account of SQL and PL/SQL for Oracle. It gifts you two things - 1st, it upgrades your knowledge on the subject and 2nd, the innumerable, exciting examples help you build a better skill in SQL and PL/SQL. This comprehensive reference will help you learn the entire spectrum of SQL - from Views to Cube and Roll Up; from Case Expressions to Variances and Corelation - and PL/SQL - from Collections to ObjectTypes; from error handling to Triggers; from Object views to Rollback segments; from UNDO tablespace to Expression filter and many more. · Introduction to SQL · Set Operations · SQL Operators · Aggregate Functions and Group by Clause · Updating and Deleting Data in Existing Table (DML) · Views · Assignment - I · Assignment - II · Advanced Queries · Integrity Constraints · Analytical Queries · Understanding ROLLUP and CUBE · Understanding Joins · Scalar Subqueries · Case Expressions · Multitable Insert and Merge · Regular Expression · Statistical Functions · Model Queries · SQL Quiz · PL/SQL Program Features · PL/SQL Datatypes · Understanding Control Structure · Interaction with Oracle · Collections and Records · LOB, BFILE and DBMS_LOB · Objects and Objects Types · Sample Programs - I · Sample Programs - II · Error Handling · Subprograms in PL/SQL · Package · Trigger (Database) · Autonomous Transaction · Important PL/SQL Packages · Object Views · Transaction Processing in Oracle · Locking in Oracle · Rollback Segments · UNDO Tablespace · Invoker Rights and NOCOPY Clause · Dependency Tracking in Oracle · FalshBack Queries · Sequence · PL/SQL Wrapper · Oracle Expression Filter · Server Model for Billing Entry System · Security and Auditing · PL/SQL Questions
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Koha item type Books
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Location (home branch) Sublocation or collection (holding branch) Date acquired Koha issues (times borrowed) Koha full call number Accession No. Koha date last seen Koha item type Cost, normal purchase price
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12919 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12920 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12921 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12922 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12923 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12924 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010 4 005.74 DES SCA12925 25.05.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12926 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12927 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12928 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12929 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12930 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12931 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12932 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12933 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12934 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12935 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12936 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12937 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12938 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12939 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12971 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12972 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12973 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12974 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12975 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA12976 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010   005.74 DES SCA13571 11.04.2024 Books 529.00
    Dewey Decimal Classification     School of Computer Application Library School of Computer Application Library 09.01.2010 4 005.74 DES SCA13645 25.05.2024 Books 529.00
Copyright © 2024 Kalinga Institute of Industrial Technology (KIIT), Bhubaneswar. All Rights Reserved.   
Powered by Koha. Supported by Avior Technologies Pvt. Ltd.

Powered by Koha