Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Find out what database you are connected to - This Script will help you to find out which Database you are presently
  Connected to? If You are working on multiple Databases on different Servers using SQL*Net or Net8 pop (Added: 9-Apr-2000 Hits: 13035 Rating: 4.92 Votes: 12) Rate It

• Removing duplicate rows - Removes duplicate data from a table. pop (Added: 11-May-2000 Hits: 15577 Rating: 7.95 Votes: 20) Rate It

• Addition, Subtraction, Multiplication and Division operations of two numbe - The following script performs the Addition, Subtraction, Multiplication and Division operations of two numbers as entered by the user.
  The choice of the transactions is also entered by the user.
  
  The performing of the above four transactions can be written using the 'if..elsif condition' but the following code
  is short and simple. (Added: 6-Jan-2003 Hits: 3874 Rating: 6.08 Votes: 12) Rate It

• Alternative for Count(*) - The script below depicts the use of Rownum (Added: 26-Jul-2003 Hits: 7032 Rating: 2.00 Votes: 5) Rate It

• BETWEEN VALUES - While using between operator, only values in ascending order are accepted. If values
  in descending order are given, you get no rows. However, if you use >= and <= operators, you have the privilege to use the range of values either in ascending order or descending order. (Added: 3-Nov-2008 Hits: 1579 Rating: 0 Votes: 0) Rate It

• BIND VARIABLES - Use of bind variables in sql*plus and pl/sql improve application performance.
  Handling nulls through the use of bind variables in pl/sql scripts is a tricky task. Here are some exmples to handle nulls. (Added: 11-Dec-2008 Hits: 1607 Rating: 0 Votes: 0) Rate It

• Bitwise functions - I got sick and tired of not having bitwise functions for numbers in Oracle so I went ahead and wrote my own. (Added: 14-Feb-2001 Hits: 6189 Rating: 7.00 Votes: 1) Rate It

• Bitwise Math and Masking Functions - This script performs bitwise math and masking operations on numbers. Performs the bitwise operations "AND", "OR", "XOR" and "NOT"; Turns a mask of bits ON or OFF in a larger array of bits; Tests whether a number is a "single bit" number; Tests whether a mask of bits is ON in a larger array of bits. (Added: 31-May-2006 Hits: 2867 Rating: 1.00 Votes: 1) Rate It

• comma delimiter strings - Splitting a Comma separated line (Added: 17-Dec-2007 Hits: 2564 Rating: 0 Votes: 0) Rate It

• Comma seperated values - tokenizer - Procedure for string tokenizer
  To delimit the string of comma separated values from a
  string while is comma delimited. (Added: 20-Jan-2003 Hits: 4802 Rating: 10.00 Votes: 1) Rate It

Next 10