SEARCH


 


Oracle SQL Code

"
Remove Leading Zero's from a String

How to return errors when converting floating numbers

Find

Find exact years and days between 2 dates

Find

Find years of service of an employee

Rename

Rename a column in a Table

Drop

Drop a column from a Table

Pick

Select the last Saturday in every month

Case Performing Case Insensitive Searching
Limit

Limit number of objects created by a user

Bullet

Select 6 random numbers between 1 and 49

Bullet

Centralising Data in a Column

Bullet

Compare 2 Strings

Bullet

Creating VARRAYS

Bullet

Drop a column clause

Bullet

Drop all empty tables

Bullet

Find out who is using the TEMP tablespace

Bullet

Find data entered yesterday from a date column

Bullet

Find LAST_ANALYZED date in Oracle7

Bullet

Find spaces in Oracle Scripts

Bullet

Display multi line errors in Forms

Bullet

How to recreate indexes

Bullet

Ordering numerically in a VARCHAR2 column

Bullet

Populating VARRAYS

Bullet

Running totals with SQL

Bullet

Selecting only the group with MAX sum in the query

Bullet

Selecting VARRAYS

Bullet

Setting SQL prompt to the current directory

Bullet

Get tablespace information

Bullet

Using BTITLE and TTITLE

Bullet

Find out which Oracle Version is installed on Unix

Find the number in error when you get an ORA-01722 invalid number error.

select <field>
from <table>
where trim(translate(<field>, '0123456789', ' ')) IS NOT NULL

This should return the fields that cannot be converted using TO_NUMBER or where text type data won't insert into a NUMBER column.