Connecting to Oracle DB in Linux Shell Script
Atul Singh
February 25, 2023
In this post, we will see how to connect to Oracle DB in Linux Shell Script. There are some prerequisite for a Linux server to connect to O...
Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts
Saturday, February 25, 2023
Friday, December 4, 2020
5 Tips For Better DataStage Design #18
Atul Singh
December 04, 2020
1. Use Database Connector Stages wherever possible - Older “Enterprise” stages must not be used - ODBC stages must not be used whe...
Sunday, August 14, 2016
NULL behaviour in Oracle
Atul Singh
August 14, 2016
NULL, as known in SQL, a special marker and keyword indicating that something has no value. A value of NULL is different from an empty or z...
Tuesday, June 7, 2016
Tuning SQL Statement #4
Atul Singh
June 07, 2016
Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...
Sunday, May 22, 2016
Tuning SQL Statement #3
Atul Singh
May 22, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Tuesday, April 26, 2016
Tuning SQL Statement #2
Atul Singh
April 26, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...
Monday, April 25, 2016
Tuning SQL Statement #1
Atul Singh
April 25, 2016
• Try to use explicit columns and try to read columns in index orders if possible, even to the point of reading indexes and not tables....
Monday, September 21, 2015
DataStage Scenario #5 - Oracle Rank & Rownum
Atul Singh
September 21, 2015
Scenario: a. Design a job where we read the data from squential file. b. Analyze the data into job and generate these 3 columns E...
