Author Archives: Deepak Mahto

About Deepak Mahto

Having 10 Years of relevant/exciting/fruitful/challenging/learning in Oracle Technology. Currently working as Oracle Performance Consultant in an MNC. Hold Expertise in Performance Engineering, SQL Tuning, Database Tuning, SQL, PLSQL Development/Design Considerations and Oracle Internals. I enjoy reading on Oracle internals, posting some of my finding or observations and playing football.

Date Generator in SQL Server using Recursive With Clause.

During one of performance analysis, identified lofty insert statements populating static tables with Date information. As part of one of functionality, we were generating dates and applying necessary function on it within date range specified. As part of performance improvement, … Continue reading

Rate this:

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

#SQLSERVERLearning : Order By Learning.

Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading

Rate this:

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

#SQLSERVERLearning : String Padding in Sql Server (LPAD/RPAD)

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 Helper SQL, SQL Server Learning | Tagged , , , , , , | Leave a comment

#SQLSERVERLearning : Export Table data as Insert statement in 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 SQL Server Learning | Tagged , , , | Leave a comment

#SQLSERVERLearning : Column Data Type Conversion 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 , , , | Leave a comment

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