MTU Cork Library Catalogue

Understanding the new SQL : (Record no. 23329)

MARC details
000 -LEADER
fixed length control field 01860 am a2200349 a 4500
001 - CONTROL NUMBER
control field on1558602453
003 - CONTROL NUMBER IDENTIFIER
control field IE-CoIT
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20210910062545.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 921006s1993 xxua r 001 eng
010 ## - LIBRARY OF CONGRESS CONTROL NUMBER
LC control number 92038385
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 1558602453
029 ## - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier T14414
029 ## - OTHER SYSTEM CONTROL NUMBER (OCLC)
OCLC library identifier T14413
040 ## - CATALOGING SOURCE
Modifying agency OCoLC
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.756
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Melton, Jim,
Dates associated with a name 1946-
9 (RLIN) 105593
245 10 - TITLE STATEMENT
Title Understanding the new SQL :
Remainder of title a complete guide /
Statement of responsibility, etc. Jim Melton and Alan R. Simon.
260 ## - PUBLICATION, DISTRIBUTION, ETC.
Place of publication, distribution, etc. San Mateo, Calif. :
Name of publisher, distributor, etc. Morgan Kaufmann Publishers,
Date of publication, distribution, etc. 1993.
300 ## - PHYSICAL DESCRIPTION
Extent xxiv, 536 p. :
Other physical details ill. ;
Dimensions 24 cm.
490 #1 - SERIES STATEMENT
Series statement Morgan Kaufmann series in data management systems.
500 ## - GENERAL NOTE
General note Includes index.
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note Part I: SQL-92 Basics -- Introduction to SQL-92 -- Getting started with SQL-92 -- Basic table creation and data manipulation -- Basic Data Definition Language (DDL) -- Values, Basic Functions and Expressions -- Part II: Advanced Features of SQL-92 -- Advanced Value Expressions: CASE, CAST and Row Value Expressions -- Predicates -- Working with Multiple Tables: The Relational Operators -- Advanced SQL Query Expressions -- Constraints, Assertions and Referential Integrity -- Part III: SQL and Applications -- Accessing SQL from the Real World -- Cursors -- Privileges, Users and Security -- Transaction Management -- Connections and Remote Database Access -- Dynamic SQL -- Part IV: The Finishing Touches -- Diagnostics and Error Management -- Internationalization Aspects of SQL-92 -- Information Schema -- A look to the future.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element Database management
9 (RLIN) 36067
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name entry element SQL (Computer program language)
9 (RLIN) 44317
700 1# - ADDED ENTRY--PERSONAL NAME
Personal name Simon, Alan R.
9 (RLIN) 13674
907 ## - LOCAL DATA ELEMENT G, LDG (RLIN)
a .b10304423
b 120820
c 011116
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Suppress in OPAC 0
Source of classification or shelving scheme Dewey Decimal Classification
969 00 - LOCAL CODES
a 20251
979 00 - LOCAL CODES
a OB2
b 01 NOV 2001
989 00 - LOCAL CODES
a OB2
998 ## - LOCAL CONTROL INFORMATION (RLIN)
a c
Operator's initials, OID (RLIN) 011115
Cataloger's initials, CIN (RLIN) m
First Date, FD (RLIN) a
Local -
-- eng
-- cau
h 0
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Shelving location Date acquired Cost, normal purchase price Total Checkouts Total Renewals Full call number Barcode Date last seen Copy number Cost, replacement price Price effective from Koha item type
    Dewey Decimal Classification   Available for Loan MTU Bishopstown Library MTU Bishopstown Library Store Item 16/11/2001 39.36 25 5 005.756 00013874 20/11/2017 1 39.36 20/11/2017 General Lending
    Dewey Decimal Classification   Available for Loan MTU Bishopstown Library MTU Bishopstown Library Lending 16/11/2001 39.36 20 7 005.756 00018514 20/11/2017 1 39.36 20/11/2017 General Lending

Powered by Koha