Jiltin’s Blog Oracle, Linux, C++, C#, Linux, 11i Apps, DBA scripts, Equity Edge, MySQL, PHP,Bash scripts, Wordpress

AWK syntax: awk [-Fs] “program” [file1 file2...] # commands come from DOS cmdline awk ‘program{print “foo”}’ file1 # single quotes around double quotes # NB: Don’t use single quotes alone if the embedded info will contain the # vertical bar or redirection arrows! Either use double quotes, or (if # using 4DOS) use backticks around the Read More

Posted under Unix Scripts

This is just a preliminary step to increase your site ranking, a starting guide. To know more, read about Search Engine optimization techniques. Once you have created your web site you need to get Ranked by Google, Alexa and the other search engines, and more importantly, ranked highly in Google, Alexa and the Search Engine Result Positions SERPs.  Search engine optimization (SEO) has been Read More

Posted under Internet

The Luhn algorithm or Luhn formula, also known as the “modulus 10″ or “mod 10″ algorithm, is a simple checksum formula used to validate a variety of identification numbers, such as credit card numbers and Canadian Social Insurance Numbers. The formula verifies a number against its included check digit, which is usually appended to a partial account number to generate the Read More

Posted under Web & Scripts

Lockbox is a service provided by banks by which your company gets the customers payments directly to a lockbox interface tables and creates receipt for the payments deposited into your account. If you have an Auto Lockbox, the bank records the information that you request such as check number, check amount, numbers and amount for the invoices to be paid. Oracle provides you with the tools to: * Read More

Posted under Receivables

You can easily install NTP (Network Time Protocol, a means of transmitting time signals over a computer network) using yum command under Redhat or CentOS/Fedora core Linux. Login as the root user Type the following command to install ntp # yum install ntp Turn on service # chkconfig ntpd on Synchronize the system clock with 0.pool.ntp.org server: # ntpdate pool.ntp.org Start the NTP: # Read More

Posted under Unix Scripts

One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: * The speed of computing might be wasting valuable human time (users waiting for response); * Enable your system to Read More

Posted under 11i DBA Scripts, 11i Scripts, Oracle Scripts

#include <iostream> #include <string> using namespace std; void main() {         int max;         cin> > max;         if(max <= 0)         {                 cout<<"Please enter a digit>  0\n";   Read More

Posted under Unix Scripts, Web & Scripts

This is best Mortgage comparison Calculator I have seen! I was actually planning to write a simple program for this and found one. Banks/Mortgage companies provide more options, such as points, loan fee, processing fees, which is not easy to comprehend unless you are a mortgage expert. Even though they provide APR for comparison, it is very difficult for the individual to decide which is one Read More

Posted under Finance

Long back, around 2001, I download the script from http://www.gt.ed.net/keith/plsql/. This link is dead as of date. They are working plsql scripts that I have tested long back. Introduction MD4 and MD5 are one-way hashing algorithms designed to create compact, fixed-length (256 bit) digital signatures (checksums/fingerprints) by generating hashes that are unique and not reversible. They are Read More

Posted under Oracle Scripts

I have been trying to learn SEO to improve the site and ranking. I tried many books, internet sites, finally got a good site for SEO Fast Start. Dan Thies, SEO expert, has been writing about, teaching, and practicing search engine optimization for over 10 years now. He provides a 100 page SEO book is free to download. Now in its 8th edition since 2001, my SEO book is free - just fill out the Read More

Posted under Internet

/* Description: This script current period status of application (oracle 11i) Author: Jay Gopalakrishnan / Jiltin Input: &&Chart_of_accounts_id,&&application_id */ Download the code SELECT gls.name, gps.closing_status FROM apps.GL_PERIOD_STATUSES gps, gl_sets_of_books gls WHERE 1=1 AND gps.start_date <= SYSDATE AND gps.end_date >= SYSDATE AND Read More

Posted under 11i Scripts

/* Description: This script will all the pending normal jobs running (oracle 11i) in oracle applications Backend query is always faster than front end query Author:      Jay Gopalakrishnan / Jiltin Input:       none */ Download the Code SELECT fcr.REQUEST_ID, fu.user_name, fcr.PHASE_CODE, fcr.STATUS_CODE, (fcr.ACTUAL_COMPLETION_DATE -   fcr.ACTUAL_START_DATE) * 24 * 60 Read More

Posted under 11i Scripts

– – Description: For any customer number, this gives credit card or bank account number (oracle 11i) – Author:      Jay Gopal / Jiltin – Input:       &&Cust_number – Download the code SELECT RC.CUSTOMER_NAME, RC.CUSTOMER_NUMBER, BACCT.BANK_ACCOUNT_NAME BANK_NAME, BACCT.BANK_ACCOUNT_NUM Read More

Posted under 11i Scripts

/* Description: This script will find the credit card number for an invoice number (oracle 11i) Author:      Jay Gopa l/ Jiltin Input:       &&inv_no */ select rc.customer_name customer, rct.trx_number invoice_number, apa.bank_account_id, apa.bank_account_name bank_name, apa.bank_account_num credit_card_number, to_char(apa.inactive_date,’dd-mon-yyyy’) Read More

Posted under 11i Scripts

Q. How can I set the system date and time from the command prompt (bash shell)? I don’t have GUI installed and I am login over ssh session. A. Use date command to display the current date and time or set the system date and time over ssh session. This is useful if the Linux server time and/or date is wrong, and you need to set it to new values from the shell prompt. Task: Set new date / Read More

Posted under Unix Scripts

Checks whether a string of digits is a valid credit card number according to the Luhn algorithm. Starting with the second to last digit and moving left, double the value of all the alternating digits. For any digits that thus become 10 or more, add their digits together. For example, 1111 becomes 2121, while 8763 becomes 7733 (from (1+6)7(1+2)3). Add all these digits together. For example, 1111 Read More

Posted under Web & Scripts

The best way is to use bash functions like this: I have made a function called fsc in  .bashrc meaning find scripts. I have developed many scripts in /root/work/scripts/dev directory. If wanted to find the script name providing a short name, here is the way. Usage: fsc deny #it will find all the file name *deny* Bash Function fsc () { ls /root/work/scripts/dev | egrep -i Read More

Posted under Unix Scripts

In this day and age, with the credit card market growing as large as it now has, it is no wonder that credit card companies have started trying to entice buyers by offering incentive programs on their cards. These programs come in many different forms and offer a variety of different products and services One of the most common incentive programs offered by many credit card companies is the Read More

Posted under Finance

AdSense for content is the bread and butter of many of our publishers, and we often receive requests to recommend strategies to improve AdSense performance on publisher sites. While we refer to this as ‘optimisation’, we understand that this term can make the process sound more difficult than it really is. In response, we’re releasing a three-part video series that Read More

Posted under Internet

The Luhn algorithm or Luhn formula, also known as the “modulus 10″ or “mod 10″ algorithm, is a simple checksum formula used to validate a variety of identification numbers, such as credit card numbers and Canadian Social Insurance Numbers. The formula verifies a number against its included check digit, which is usually appended to a partial account number to generate the Read More

Posted under Web & Scripts