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

• Compare Two Strings by Ignoring Case Sensitivity (Added: 10-Dec-2001 Hits: 5856 Rating: 5.60 Votes: 5) Rate It

• Conver Number to Word Up to Billions - You can easly convert Numbers to Words from this function:
  Input: SELECT NUMTOCHAR(4567281.47) FROM DUAL;
  Output: FOUR MILLION FIVE HUNDRED SIXTY-SEVEN THOUSAND TWO HUNDRED EIGHTY-ONE AND PAISA FORTY-SEVEN ONLY. (Added: 30-Oct-2002 Hits: 4609 Rating: 3.00 Votes: 1) Rate It

• Convert Numbers to Word (up to 5 million) - Input: 100,000 or 1,0000.
  Output: one hundred thousand or ten thousand (Added: 19-Aug-2002 Hits: 3841 Rating: 9.33 Votes: 3) Rate It

• counting the number of records FAST - This sql will return the rowcount faster than count(*) method. (Added: 3-Oct-2003 Hits: 5801 Rating: 1.78 Votes: 9) Rate It

• Debugging Column Length - This script debugs column length mismatch in Oracle tables and joins the matching rows through an equi join. (Added: 3-Feb-2009 Hits: 1169 Rating: 0 Votes: 0) Rate It

• Delete all duplicate records in a table - This script will delete all duplicate records in a table. (Added: 23-Mar-2006 Hits: 2264 Rating: 0 Votes: 0) Rate It

• Find 2 Maximum Salaries in Emp Table - Finds the two highest salaries from table "emp". (Added: 19-Aug-2002 Hits: 4857 Rating: 5.67 Votes: 3) Rate It

• Find 2 Minimum Salaries in Emp Table - Finds the two lowest salaries from table "emp". (Added: 19-Aug-2002 Hits: 3369 Rating: 8.00 Votes: 1) Rate It

• Find a given number - even or odd - Find a number that is even or odd. (Added: 7-Jul-2004 Hits: 2779 Rating: 3.33 Votes: 3) Rate It

• Find the nth Minimum value from table emp - This script finds the nth minimum value from table emp. (Added: 15-Sep-2005 Hits: 2405 Rating: 0 Votes: 0) Rate It

Prev 10 Next 10