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
Tag Archives: NULL
FIXED length character storage and NULL in SQL Server.
Most of us must be aware of CHAR datatype and its fixed length storage pattern. If we declare CHAR(32) and store only 4 bytes character ‘ABCD’, It will pads up remaining bytes (28 bytes). Ultimately, whole bytes is consume for … Continue reading
#SQLSERVERLearning : String Concatenation for NULL and Empty String in Oracle and SQL Server
All my blogs with #SQLSERVERLearning is intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for Oracle guy also working in SQL Server world. All finding or Observations with SQL Server … Continue reading
Posted in Oracle Internal, SQL Server Learning
Tagged +, Concat, Empty String, NULL, Oracle, sql server, ||
2 Comments
Aggregate Function , Distinct and NULL Values in Oracle.
While working on SQL Server with queries having aggregation got a warning message. “Warning: Null value is eliminated by an aggregate or other SET operation.” So thought let write up something on Aggregation and NULL Values for Tradition RDBMS for … Continue reading
#SQLSERVERLearning : Does Unique Index Stored NULL Values in Index?
All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as difference between Oracle and SQL Server. Hopefully it might be helpful for any Oracle guy also working with SQL Server. All finding or Observations with SQL Server … Continue reading
Posted in Oracle Internal, SQL Server Learning
Tagged Filter index, Index, NULL, Oracle, sql server, unique
Leave a comment
NOT IN Condition and NULL Data
Before getting into discussions, lets start with a SQL example. Trying to fetch all employees who are not manager! Employee table Structure Name Null Type ——– ——– ———— EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE … Continue reading