Skip to content
djangoSpin
  • Home
  • About Us
    • Nalini & Lakshay
  • Python Center
    • Python 101
    • OO Python
    • Design Patterns
    • 50+ Standard Library Modules
    • 60+ Third-Party Modules
    • 50+ Tips & Tricks for Python Developers
    • 50+ Know-How(s) Every Pythonista Must Know
    • All Python Articles
    • Python Programs
  • Handy-How-To(s)
    • C#
    • English
    • Google Chrome
    • Microsoft Excel
    • Oracle
    • Python
    • SQL
    • WordPress
    • Unix

Oracle

SQL @ DjangoSpin

SQL Optimizer Hints

Reading Time: 1 minutesSQL Optimizer Hints - Quick tips and description on frequently used SQL Hints: SQL Optimizer Hints /*+ ALL_ROWS */: The ALL_ROWS hint explicitly chooses the cost-based approach to optimize a […]

Posted on January 11, 2017April 9, 2017 by lakshayarora7 Continue reading
SQL @ DjangoSpin

SQL Tuning Tips

Reading Time: 2 minutesSQL Tuning Tips SQL Tuning Tips Quick tips for SQL tuning tips: Do not modify indexed columns with functions such as RTRIM, TO_CHAR, UPPER, TRUNC as this will prevent the […]

Posted on January 11, 2017April 9, 2017 by lakshayarora7 Continue reading
SQL @ DjangoSpin

SQL Tips & Tricks

Reading Time: 1 minutesSQL Tips & Tricks SQL Tips & Tricks Below are few details which will add value to your SQL knowledge. Count(*) vs Count(1) COUNT(SomeColumn) will only return the count of […]

Posted on January 11, 2017March 29, 2017 by lakshayarora7 Continue reading
SQL @ DjangoSpin

Oracle/SQL: Slicing a string till nth instance of a particular substring

Reading Time: 2 minutesSlicing a string till nth instance of a particular substring in Oracle Slicing a string till nth instance of a particular substring in Oracle How to slice a string up […]

Posted on February 2, 2016April 5, 2017 by lakshayarora7 Continue reading
Excel @ DjangoSpin

Microsoft Excel: Using the CONCATENATE function in Microsoft Excel

Reading Time: 1 minutesUsing the CONCATENATE function in Microsoft Excel Using the CONCATENATE function in Microsoft Excel Today, I had a task of building SQL insert queries from an Excel sheet. The Excel […]

Posted on January 14, 2016April 11, 2017 by lakshayarora7 Continue reading
SQL @ DjangoSpin

Oracle/SQL: Calculating sizes of different tablespaces in an Oracle database

Reading Time: 1 minutesCalculating sizes of different tablespaces in Oracle Calculating sizes of different tablespaces in Oracle:

Posted on January 14, 2016April 11, 2017 by lakshayarora7 Continue reading
♫  On a fishing boat of the New Jersey Shore... ♫
Passenger

Categories

  • English (1)
  • Google Chrome (2)
  • Mac (1)
  • Microsoft Excel (2)
  • Microsoft Outlook (2)
  • Oracle (6)
  • Project Euler Problems (1)
  • Python (112)
  • Python Programs (102)
  • SQL (3)
  • Uncategorized (3)
  • Unix (2)
  • Wordpress (1)

Recent Posts

  • Test
  • Project Euler Problem #1: Multiples of 3 and 5 | Difficulty 5%
  • Python: Lexicon
  • Windows: Scheduling a task
  • PyPro #101 Chain of Responsibility Design Pattern

Archives

  • April 2023
  • April 2018
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • October 2016
  • September 2016
  • July 2016
  • May 2016
  • February 2016
  • January 2016
  • December 2015

Feeds

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Proudly powered by WordPress | Theme: West by aThemes.