Oracle Magazine Archive
On joins and sub queries
Why my plans keep changing ?
On Deduping and Ordering
How to update the multiple columns of a table from multiple columns of another table
Diagnosing Performance Problems
On Format, Negation, and Sliding
Compressing Data for Space and Speed
On Sorts, Selecting, and Selectivity
Relational VS Object Oriented Database Design
On Numbers and Analytics
Relational vs Object relational database
Execute Immedaite - PL/SQL
Analytic Function on scott/tiger schema
On Top-n and Pagination Queries (using Analytics)
If one column is not null then another column should be not null, both can be nulls:
Update statement and Null-values -- update a table from another table
How CBO Works by Jonathan Lewis
Analytic functions threads :
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:3170642805938
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:12864646978683
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:68125959498859
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6601312252730
http://www.oracle.com/technology/oramag/oracle/04-mar/o24asktom.html
Designing Tables
keep equal the cumulative values of two columns
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment