 |  |  |  |  |  |  |  |
Books
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Hello,
plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.
plz tell me a perfect book which includes all SQL Queries with solved examples. So i will do well practie with it.
Thanks & Regards
Ms. Dipti
Ms. Dipti
Try the following link and select SQL Reference
Last edited by debasisdas; Jul 16th, 2009 at 2:54 pm.
Share your Knowledge.
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!!!
|
Similar Threads
- Good books on Shell Programming/Perl (Perl)
- What are some good programming books? (Computer Science)
- Any recommendations on good Flash books? (Graphics and Multimedia)
- books cheap on LI (IT Professionals' Lounge)
- Learning Marketing from books - The risks and their solutions. (IT Professionals' Lounge)
- the books you use (Computer Science)
Other Threads in the Oracle Forum
- Previous Thread: Why Oracle or other Databases?
- Next Thread: how to display only the first 3 rows
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
