Category
- Annual Report – Wordpress (1)
- Helper SQL (12)
- Oracle 12c New Features (9)
- Oracle Internal (36)
- Oracle Performance (2)
- SQL Server Learning (20)
Top Posts & Pages
Archives
- April 2018 (1)
- June 2017 (1)
- May 2017 (3)
- April 2017 (4)
- March 2017 (1)
- January 2017 (3)
- December 2016 (10)
- November 2016 (6)
- October 2016 (1)
- August 2016 (1)
- June 2016 (2)
- May 2016 (1)
- February 2016 (1)
- January 2016 (1)
- November 2015 (3)
- September 2015 (1)
- April 2015 (1)
- January 2015 (2)
- December 2014 (6)
- November 2014 (11)
- April 2014 (2)
- March 2014 (1)
-
Recent Posts
- CHAR Datatype and ConCat in Oracle and SQL Server. April 3, 2018
- SQL SERVER# : Get last possible time for a DAY. June 2, 2017
- FIXED length character storage and NULL in SQL Server. May 31, 2017
- APPROX_COUNT_DISTINCT in Oracle 12c. May 24, 2017
- Lateral Views in Oracle 12c. May 12, 2017
- SQL Server : Value Constructor Insight. April 13, 2017
- SQL Server : ExecuteNonQuery shows incorrect rows affected. April 6, 2017
- SQL Server : Get Numeric part from a varchar/string. April 6, 2017
- Date Generator in SQL Server using Recursive With Clause. April 5, 2017
- #SQLSERVERLearning : Order By Learning. March 3, 2017
- #SQLSERVERLearning : String Padding in Sql Server (LPAD/RPAD) January 6, 2017
- #SQLSERVERLearning : Export Table data as Insert statement in SQL Server. January 5, 2017
Blogs I Follow
- Improving my SQL BI Skills
- SQLXpertise
- MirrorSpeaks
- Crafty Arty Namy
- Java, SQL and jOOQ.
- DBA-010
- SQL Jana
- amitzil - Oracle DBA blog
- The Oracle Sponge
- Talip Hakan Ozturk's ORACLE BLOG
- Learning is not a spectator sport
- Neeraj Bhatia's Blog
- ng-coder-$scope
- Adityanath's Oracle Blog
- Ahmed Abdel Fattah Blog !
- Database Store
- tier1app
- sqlpatterns
- Charles Hooper's Oracle Notes
- Steve Harville's Blog
Monthly Archives: May 2016
Incorrect Refer to a column alias causing performance degradation
For easy of referencing and better code readability we add aliases to table reference in most of queries. For correlated queries we add conditions based on correlation columns between any two tables or entities. Below is one of query shared … Continue reading