0

Hello,
plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.

3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by anubina
0

Try the following link and select SQL Reference

100%

The official documentation is excellent and the technically correct one.

In the "SQL Reference" look for (Better 11g):

· 2 Basics (formats models)
· 3 Pseudocolumns
· 4 Operators
· 5 Functions (regular)
· 6 Expressions
· 7 Conditions
**** 9 SQL Queries and Subqueries ****
· 19 SQL Statements (SELECT)

Diferents types of Querys:

· Scalar & Multiples values
· Cartesian projection
· Subquerys
· View inl¡ne & TopN-Query
· Factoring querys
· Model !!! (for reduce the PL/SQL code)
· Hierarchical (very good for CMDB - ITIL)
· Distributed (dblinks)
· Crosstab !!! (only 11g)

The new RDBMS is orientated for ITIL (management of changes and configuration).
The orientation of a SQL programmer is reducing and flat the PL/SQL code and overload the querys with the new enhacements!!!

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.