Monthly Archives: December 2016

Interesting New WITH Clause Feature in Oracle 12c.

#TGIF In Oracle 12c, WITH clause is capable to have PL-SQL type Function or procedure inline with underlying SQL. Function or Procedural within WITH clause is scope till SQL Execution lifetime and cease to exist after execution completion. Having Function … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , , , , , | Leave a comment

MIN , MAX and INDEX Access in Oracle.

All Entries in Index are stored as sorted either in ascending or descending order. If we need MIN or MAX for any column being indexed, its should be easier for oracle to fetch same as both would be at index … Continue reading

Rate this:

Posted in Oracle Internal, Oracle Performance | Tagged , , , , | Leave a comment

#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

Rate this:

Posted in Oracle Internal, SQL Server Learning | Tagged , , , , , , | 2 Comments

#SQLSERVERLearning : CASE Statement Insight

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

Rate this:

Posted in SQL Server Learning | Tagged , , , , | Leave a comment

Change Date in Oracle using FIXED_DATE

In our previous project for testing purpose, we required to change Sysdate in database. Changing date is useful for many functional testing to go back date and perform functional compliance operations. Oracle provide FIXED_DATE, system level parameter for changing date. … Continue reading

Rate this:

Posted in Helper SQL | Tagged , , , | Leave a comment

Interesting Database SQL Concept Question, Give it a try??

#TGIF Today’s will try to walk you through a Database concept questions and hopefully you will learn something new. (Obviously if you are not aware of it.!) Suppose we have below scenarios, In Database Session 1 : –> we are … Continue reading

Rate this:

Posted in Helper SQL, Oracle Internal | Tagged , , , , , | 2 Comments

Multiplication across rows and Analytical Functions.

Oracle or SQL Server provide Aggregation functions for MIN/MAX/COUNT/SUM, but suppose a scenario when we want multiplication of rows across a partition or complete table. Database does not provide any buildin function to achieve same. Suppose we have below expectations, … Continue reading

Rate this:

Posted in Helper SQL, Oracle Internal, SQL Server Learning | Tagged , , , , , | 1 Comment

#SQLSERVERLearning : Identity Column Insight.

All my blogs with #SQLSERVERLearning are intended to cover all stuff identified as the 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 … Continue reading

Rate this:

Posted in SQL Server Learning | Tagged , , , , | 1 Comment

Oracle 12c : Default values on NULL.

In Oracle, DEFAULT provide an option to have any default expression when column data is not specified during data manipulations. During Table creation or using Alter we can provide DEFAULT value for column. While data manipulation we can use “default” … Continue reading

Rate this:

Posted in Oracle 12c New Features | Tagged , , | Leave a comment

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

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment