Member Avatar for cutedipti

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
  • 157 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by anubina
Member Avatar for debasisdas

you want an e-book ?

Member Avatar for cutedipti

Both will be ok, if it's e-book or not.

Member Avatar for debasisdas

Try the following link and select SQL Reference

commented: Thank you for sharing useful resource +22
Member Avatar for anubina

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!!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.