Oracle SQL: the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i]
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Beijing [u.a.]
O'Reilly
2000
|
| Edition: | 1. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XXXIII, 382 S. |
| ISBN: | 1565926978 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV013487061 | ||
| 003 | DE-604 | ||
| 005 | 20060424 | ||
| 007 | t | ||
| 008 | 001205s2000 gw |||| 00||| eng d | ||
| 016 | 7 | |a 96020217X |2 DE-101 | |
| 020 | |a 1565926978 |9 1-56592-697-8 | ||
| 035 | |a (OCoLC)634931623 | ||
| 035 | |a (DE-599)BVBBV013487061 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-91G |a DE-634 | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a DAT 652f |2 stub | ||
| 100 | 1 | |a Kreines, David C. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Oracle SQL |b the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] |c David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick] |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2000 | |
| 300 | |a XXXIII, 382 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a ORACLE 8.0 |0 (DE-588)4476381-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE 8i |0 (DE-588)4542766-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |D s |
| 689 | 0 | 1 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a ORACLE 8.0 |0 (DE-588)4476381-5 |D s |
| 689 | 1 | 1 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a ORACLE 8i |0 (DE-588)4542766-5 |D s |
| 689 | 2 | 1 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 2 | |5 DE-604 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009205348&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-009205348 | ||
Record in the Search Index
| _version_ | 1804128278354591744 |
|---|---|
| adam_text | Oracle SQL
The Essential Reference
David C Kreines
Foreword by Ken Jacobs
£S: , :n OREim
Beijing • Cambridge • Farnham—K6ln--Parisr Sebastopol • Taipei • Tokyo
Table of Contents
Foreword ix
Preface xxvii
1 Elements of SQL 1
Lexical Conventions 2
Naming in SQL 3
Schema Objects 4
Datatypes 6
Data Conversion 13
Relational Operators 14
Structure of a SQL Statement 20
SQL Statements 24
2 Data Definition Statements 32
SQL DDL Statements by Task 32
SQL Statement Syntax 38
3- Data Manipulation and Control Statements 106
SQL DML and Control Statements by Task 106
SQL Statement Syntax 107
4 Common SQL Elements 133
5 SQL Functions 145
Aggregate Functions 146
Numeric Functions 153
vii
viii Table of Contents
Character Functions 162
Date Functions 174
Conversion Functions 182
Other Functions 190
6 SQL*Plus 204
Command-Line Syntax 204
SQL*Plus Editing Commands 208
Formatting SQL Plus Output 211
Miscellaneous SQL Plus Commands 221
SQL*Plus Variables and Related Commands 238
SQL Plus System Variables 241
7 PL/SQL : 262
The Structure of PL/SQL 263
Block Header 265
Declaration Section 265
Execution Section 280
Exception Section 298
Procedures and Packages 304
Triggers 318
8 SQL Statement Tuning 324
Using EXPLAIN PLAN 325
Using Oracle s SQL Trace Facility 334
SQL Plus Tuning Aids 345
Improving Query Performance 351
A SQL Resources 361
Index 365
|
| any_adam_object | 1 |
| author | Kreines, David C. |
| author_facet | Kreines, David C. |
| author_role | aut |
| author_sort | Kreines, David C. |
| author_variant | d c k dc dck |
| building | Verbundindex |
| bvnumber | BV013487061 |
| classification_rvk | ST 271 |
| classification_tum | DAT 652f |
| ctrlnum | (OCoLC)634931623 (DE-599)BVBBV013487061 |
| discipline | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01870nam a2200481 c 4500</leader><controlfield tag="001">BV013487061</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20060424 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">001205s2000 gw |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">96020217X</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1565926978</subfield><subfield code="9">1-56592-697-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)634931623</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV013487061</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91G</subfield><subfield code="a">DE-634</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 652f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kreines, David C.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Oracle SQL</subfield><subfield code="b">the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i]</subfield><subfield code="c">David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick]</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2000</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXIII, 382 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 8.0</subfield><subfield code="0">(DE-588)4476381-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 8i</subfield><subfield code="0">(DE-588)4542766-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">ORACLE 8.0</subfield><subfield code="0">(DE-588)4476381-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">ORACLE 8i</subfield><subfield code="0">(DE-588)4542766-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009205348&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009205348</subfield></datafield></record></collection> |
| id | DE-604.BV013487061 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T18:46:42Z |
| institution | BVB |
| isbn | 1565926978 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009205348 |
| oclc_num | 634931623 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM DE-634 |
| owner_facet | DE-91G DE-BY-TUM DE-634 |
| physical | XXXIII, 382 S. |
| publishDate | 2000 |
| publishDateSearch | 2000 |
| publishDateSort | 2000 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Kreines, David C. Verfasser aut Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick] 1. ed. Beijing [u.a.] O'Reilly 2000 XXXIII, 382 S. txt rdacontent n rdamedia nc rdacarrier ORACLE 8.0 (DE-588)4476381-5 gnd rswk-swf ORACLE 8i (DE-588)4542766-5 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 gnd rswk-swf ORACLE Datenbanksystem (DE-588)4206222-6 s SQL (DE-588)4134010-3 s DE-604 ORACLE 8.0 (DE-588)4476381-5 s ORACLE 8i (DE-588)4542766-5 s HEBIS Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009205348&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Kreines, David C. Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] ORACLE 8.0 (DE-588)4476381-5 gnd ORACLE 8i (DE-588)4542766-5 gnd SQL (DE-588)4134010-3 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| subject_GND | (DE-588)4476381-5 (DE-588)4542766-5 (DE-588)4134010-3 (DE-588)4206222-6 |
| title | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] |
| title_auth | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] |
| title_exact_search | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] |
| title_full | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick] |
| title_fullStr | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick] |
| title_full_unstemmed | Oracle SQL the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] David C. Kreines. Foreword by Ken Jacobs. [Ed.: Deborah Russell and Jonathan Gennick] |
| title_short | Oracle SQL |
| title_sort | oracle sql the essential reference a quick reference for the oracle dbas and developers covers oracle8 and oracle8i |
| title_sub | the essential reference ; [a quick reference for the Oracle DBAs and developers ; covers Oracle8 and Oracle8i] |
| topic | ORACLE 8.0 (DE-588)4476381-5 gnd ORACLE 8i (DE-588)4542766-5 gnd SQL (DE-588)4134010-3 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd |
| topic_facet | ORACLE 8.0 ORACLE 8i SQL ORACLE Datenbanksystem |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009205348&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT kreinesdavidc oraclesqltheessentialreferenceaquickreferencefortheoracledbasanddeveloperscoversoracle8andoracle8i |