Mastering Oracle SQL: [putting Oracle SQL to work ; covers Oracle9i]
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Beijing [u.a.]
O'Reilly
2002
|
| Edition: | 1. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XIV, 321 S. 24 cm |
| ISBN: | 0596001290 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV014490886 | ||
| 003 | DE-604 | ||
| 005 | 20020708 | ||
| 007 | t | ||
| 008 | 020701s2002 gw |||| |||| 00||| eng d | ||
| 016 | 7 | |a 964566818 |2 DE-101 | |
| 020 | |a 0596001290 |9 0-596-00129-0 | ||
| 035 | |a (OCoLC)248085453 | ||
| 035 | |a (DE-599)BVBBV014490886 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-29T | ||
| 082 | 0 | |a 005.7565 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Mishra, Sanjay |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Mastering Oracle SQL |b [putting Oracle SQL to work ; covers Oracle9i] |c Sanjay Mishra and Alan Beaulieu. [Ed.: Jonathan Gennick] |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2002 | |
| 300 | |a XIV, 321 S. |b 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a ORACLE 8i - SQL | |
| 650 | 4 | |a ORACLE 9i - SQL | |
| 650 | 4 | |a ORACLE <Datenbanksystem> - SQL | |
| 650 | 7 | |a Oracle |2 sbt | |
| 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 |
| 650 | 0 | 7 | |a ORACLE 10g |0 (DE-588)4771297-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a ORACLE 9i |0 (DE-588)4646123-1 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a ORACLE 9i |0 (DE-588)4646123-1 |D s |
| 689 | 0 | 1 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a ORACLE |g Datenbanksystem |0 (DE-588)4206222-6 |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 | |
| 689 | 3 | 0 | |a ORACLE 10g |0 (DE-588)4771297-1 |D s |
| 689 | 3 | 1 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 3 | |8 1\p |5 DE-604 | |
| 700 | 1 | |a Beaulieu, Alan |e Verfasser |0 (DE-588)131913336 |4 aut | |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882471&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-009882471 | |
Record in the Search Index
| _version_ | 1808226761969762304 |
|---|---|
| adam_text |
TABLE
OF
CONTENTS
PREFACE
.
VIII
1.
INTRODUCTION
TO
SQL
.
1
WHAT
IS
SQL?
1
A
BRIEF
HISTORY
OF
SQL
2
A
SIMPLE
DATABASE
4
DML
STATEMENTS
4
2.
THE
WHERE
CLAUSE
.
14
LIFE
WITHOUT
WHERE
14
WHERE
TO
THE
RESCUE
15
WHERE
CLAUSE
EVALUATION
16
CONDITIONS
AND
EXPRESSIONS
18
WHERE
TO
GO
FROM
HERE
24
3.
JOINS
.
26
INNER
JOINS
26
OUTER
JOINS
30
SELF
JOINS
37
JOINS
AND
SUBQUERIES
42
DML
STATEMENTS
ON
A
JOIN
VIEW
43
ANSI-STANDARD
JOIN
SYNTAX
IN
ORACLE9I
49
4.
GROUP
OPERATIONS
.
55
AGGREGATE
FUNCTIONS
55
THE
GROUP
BY
CLAUSE
59
THE
HAVING
CLAUSE
65
5.
SUBQUERIES
.
68
WHAT
IS
A
SUBQUERY?
68
NONCORRELATED
SUBQUERIES
69
CORRELATED
SUBQUERIES
75
INLINE
VIEWS
77
SUBQUERY
CASE
STUDY:
THE
TOP
N
PERFORMERS
89
6.
HANDLING
TEMPORAL
DATA
.
95
INTERNAL
DATE
STORAGE
FORMAT
95
GETTING
DATES
IN
AND
OUT
OF
A
DATABASE
96
DATE
MANIPULATION
111
ORACLE9I
NEW
DATETIME
FEATURES
124
INTERVAL
LITERALS
132
7.
SET
OPERATIONS
.
144
SET
OPERATORS
145
USING
SET
OPERATIONS
TO
COMPARE
TWO
TABLES
149
USING
NULLS
IN
COMPOUND
QUERIES
151
RULES
AND
RESTRICTIONS
ON
SET
OPERATIONS
153
8.
HIERARCHICAL
QUERIES
.
157
REPRESENTING
HIERARCHICAL
INFORMATION
157
SIMPLE
HIERARCHY
OPERATIONS
160
ORACLE
SQL
EXTENSIONS
163
COMPLEX
HIERARCHY
OPERATIONS
167
RESTRICTIONS
ON
HIERARCHICAL
QUERIES
174
9.
DECODE
AND
CASE
.
175
DECODE,
NVL,
AND
NVL2
175
THE
CASE
FOR
CASE
179
DECODE
AND
CASE
EXAMPLES
181
10.
PARTITIONS,
OBJECTS,
AND
COLLECTIONS
.
192
TABLE
PARTITIONING
192
OBJECTS
AND
COLLECTIONS
202
11.
PL/SQL
.
213
WHAT
IS
PL/SQL?
213
PROCEDURES,
FUNCTIONS,
AND
PACKAGES
214
CALLING
STORED
FUNCTIONS
FROM
QUERIES
216
VI
|
TABLE
OF
CONTENTS
RESTRICTIONS
ON
CALLING
PL/SQL
FROM
SQL
STORED
FUNCTIONS
IN
DML
STATEMENTS
THE
SQL
INSIDE
YOUR
PL/SQL
220
224
226
*
12.
ADVANCED GROUP
OPERATIONS
.
228
ROLLUP
228
CUBE
238
THE
GROUPING
FUNCTION
244
GROUPING
SETS
249
ORACLE9I
GROUPING
FEATURES
250
THE
GROUPINGJD
AND
GROUP_ID
FUNCTIONS
260
13.
ADVANCED
ANALYTIC
SQL
.
267
ANALYTIC
SQL
OVERVIEW
267
RANKING
FUNCTIONS
272
WINDOWING
FUNCTIONS
286
REPORTING
FUNCTIONS
291
SUMMARY
296
14.
SQL
BEST
PRACTICES
.
297
KNOW
WHEN
TO
USE
SPECIFIC
CONSTRUCTS
297
AVOID
UNNECESSARY
PARSING
302
CONSIDER
LITERAL
SQL
FOR
DECISION
SUPPORT
SYSTEMS
307
INDEX
.
308
TABLE
OF
CONTENTS
|
VII |
| any_adam_object | 1 |
| author | Mishra, Sanjay Beaulieu, Alan |
| author_GND | (DE-588)131913336 |
| author_facet | Mishra, Sanjay Beaulieu, Alan |
| author_role | aut aut |
| author_sort | Mishra, Sanjay |
| author_variant | s m sm a b ab |
| building | Verbundindex |
| bvnumber | BV014490886 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)248085453 (DE-599)BVBBV014490886 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| 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>00000nam a2200000 c 4500</leader><controlfield tag="001">BV014490886</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20020708</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">020701s2002 gw |||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">964566818</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596001290</subfield><subfield code="9">0-596-00129-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)248085453</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014490886</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-29T</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</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="100" ind1="1" ind2=" "><subfield code="a">Mishra, Sanjay</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Mastering Oracle SQL</subfield><subfield code="b">[putting Oracle SQL to work ; covers Oracle9i]</subfield><subfield code="c">Sanjay Mishra and Alan Beaulieu. [Ed.: 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">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIV, 321 S.</subfield><subfield code="b">24 cm</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=" " ind2="4"><subfield code="a">ORACLE 8i - SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">ORACLE 9i - SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">ORACLE <Datenbanksystem> - SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Oracle</subfield><subfield code="2">sbt</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="650" ind1="0" ind2="7"><subfield code="a">ORACLE 10g</subfield><subfield code="0">(DE-588)4771297-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">ORACLE 9i</subfield><subfield code="0">(DE-588)4646123-1</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</subfield><subfield code="g">Datenbanksystem</subfield><subfield code="0">(DE-588)4206222-6</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="689" ind1="3" ind2="0"><subfield code="a">ORACLE 10g</subfield><subfield code="0">(DE-588)4771297-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" 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="3" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Beaulieu, Alan</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)131913336</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB 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=009882471&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009882471</subfield></datafield></record></collection> |
| id | DE-604.BV014490886 |
| illustrated | Not Illustrated |
| indexdate | 2024-08-24T00:30:18Z |
| institution | BVB |
| isbn | 0596001290 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009882471 |
| oclc_num | 248085453 |
| open_access_boolean | |
| owner | DE-29T |
| owner_facet | DE-29T |
| physical | XIV, 321 S. 24 cm |
| publishDate | 2002 |
| publishDateSearch | 2002 |
| publishDateSort | 2002 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Mishra, Sanjay Verfasser aut Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] Sanjay Mishra and Alan Beaulieu. [Ed.: Jonathan Gennick] 1. ed. Beijing [u.a.] O'Reilly 2002 XIV, 321 S. 24 cm txt rdacontent n rdamedia nc rdacarrier ORACLE 8i - SQL ORACLE 9i - SQL ORACLE <Datenbanksystem> - SQL Oracle sbt 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 10g (DE-588)4771297-1 gnd rswk-swf ORACLE 9i (DE-588)4646123-1 gnd rswk-swf ORACLE 9i (DE-588)4646123-1 s SQL (DE-588)4134010-3 s DE-604 ORACLE Datenbanksystem (DE-588)4206222-6 s ORACLE 8i (DE-588)4542766-5 s ORACLE 10g (DE-588)4771297-1 s 1\p DE-604 Beaulieu, Alan Verfasser (DE-588)131913336 aut DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882471&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Mishra, Sanjay Beaulieu, Alan Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] ORACLE 8i - SQL ORACLE 9i - SQL ORACLE <Datenbanksystem> - SQL Oracle sbt ORACLE 8i (DE-588)4542766-5 gnd SQL (DE-588)4134010-3 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE 10g (DE-588)4771297-1 gnd ORACLE 9i (DE-588)4646123-1 gnd |
| subject_GND | (DE-588)4542766-5 (DE-588)4134010-3 (DE-588)4206222-6 (DE-588)4771297-1 (DE-588)4646123-1 |
| title | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] |
| title_auth | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] |
| title_exact_search | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] |
| title_full | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] Sanjay Mishra and Alan Beaulieu. [Ed.: Jonathan Gennick] |
| title_fullStr | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] Sanjay Mishra and Alan Beaulieu. [Ed.: Jonathan Gennick] |
| title_full_unstemmed | Mastering Oracle SQL [putting Oracle SQL to work ; covers Oracle9i] Sanjay Mishra and Alan Beaulieu. [Ed.: Jonathan Gennick] |
| title_short | Mastering Oracle SQL |
| title_sort | mastering oracle sql putting oracle sql to work covers oracle9i |
| title_sub | [putting Oracle SQL to work ; covers Oracle9i] |
| topic | ORACLE 8i - SQL ORACLE 9i - SQL ORACLE <Datenbanksystem> - SQL Oracle sbt ORACLE 8i (DE-588)4542766-5 gnd SQL (DE-588)4134010-3 gnd ORACLE Datenbanksystem (DE-588)4206222-6 gnd ORACLE 10g (DE-588)4771297-1 gnd ORACLE 9i (DE-588)4646123-1 gnd |
| topic_facet | ORACLE 8i - SQL ORACLE 9i - SQL ORACLE <Datenbanksystem> - SQL Oracle ORACLE 8i SQL ORACLE Datenbanksystem ORACLE 10g ORACLE 9i |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882471&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT mishrasanjay masteringoraclesqlputtingoraclesqltoworkcoversoracle9i AT beaulieualan masteringoraclesqlputtingoraclesqltoworkcoversoracle9i |