Short Cut Description Ctrl+Space Invokes code insight on demand Ctrl+Up Replaces worksheet with Previous SQL from SQL History Ctrl+Down Replaces worksheet with Next SQL from… Read More »Frequently used Oracle SQL Developer Short Cut Keys
/*********************************************************************** *PURPOSE: SQL Query to Convert Comma separated String values to Rows * *AUTHOR: Shailender Thallam * ***********************************************************************/ WITH DATA AS ( SELECT ‘word1, word2,… Read More »SQL Query to Convert Comma separated String values to Rows
We can use oracle standard REGEXP_LIKE command to apply a regular expression on value. Below is sample query to find if a value is String… Read More »Oracle SQL Regular Expression to find if a Value is String or Number
Click on the question to see the answer Basic SQL Interview Questions Can we use a WHERE clause in TRUNCATE statement? What is the difference… Read More »Top SQL Interview Questions with Answers
Like any other data type in oracle, even DATE data type has a length restriction. A Date data type can hold a maximum data of… Read More »Date Range in Oracle – Minimum Possible Date and Maximum Possible Date
Click on the question to see the answer How to display 9th record from EMP table? HOW TO DISPLAY 5 TO 7 ROWS FROM A… Read More »Frequently asked SQL Interview Questions on EMP, DEPT table
A database link is a path through which a remote user in another database can connect to any other database. Once created the database link… Read More »DB Link in Oracle SQL
I had a requirement to validate date entered in a free text field (standard field on a standard form). I have solved it by writing… Read More »Date Format validation on Standard Free Text Fields
It’s one of the very common requirement to remove non-numeric values from a text field and we can achieve this in several ways using some… Read More »SQL Query to remove Non-Numeric characters from a String
Sql Statements are used to retrieve data from the database. We can get same results by writing different sql queries. But use of the best… Read More »SQL Tuning or SQL Optimization