Category
- Annual Report – Wordpress (1)
- Helper SQL (12)
- Oracle 12c New Features (9)
- Oracle Internal (38)
- Oracle Performance (2)
- SQL Server Learning (20)
Top Posts & Pages
- How to replace multiple replace functions?
- On Rac dbms_xplan.display_cursor will give plan if cursor is present on node connected.
- #SQLSERVERLearning : String Padding in Sql Server (LPAD/RPAD)
- Aggregate Function Nesting in Oracle.
- Should we gather stats on Global Temporary Table within any Stats Job?
Archives
- September 2018 (2)
- 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
- Adding Default Column to a table in Oracle and SQL Server. September 21, 2018
- Table Alias in Oracle and SQL Server. September 18, 2018
- 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
Blogs I Follow
- SQL Authority with Pinal Dave
- SQL Undercover
- Smart way of Technology
- Raw Grit
- Hypnagogic Halucinations
- SQL with Manoj
- Shane Borden's Technology Blog
- seanstuber
- 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
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
