Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / Oracle / How to make an "ISNUMBER" function?

How to make an "ISNUMBER" function?
Print
Email to friend
Add comment
Views: 644
Votes: 0
Comments: 35
Don't you think Oracle would have made ISNUMBER, ISDATE, etc.? Other databases
have these functions.

Anyway, here is a "ISNUMBER" function you can use:

select instr(translate(column_name,
        'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),'X')
FROM table_name;

It returns 0 if it is a number, 1 if it is not.

This works if the field has only characters or digits. For example, having !!!
as a string would not work in this case. If you care about other characters,
change the translate to add those characters.
Showing: 1-20 of 35    »»
Comments

31 Dec, 1969   |   Guest
sql current date
31 Dec, 1969   |   Guest
sql server hosting
31 Dec, 1969   |   Guest
sql server 2008 r2 editions
31 Dec, 1969   |   Guest
dbms tutorial
31 Dec, 1969   |   Guest
sql server update
31 Dec, 1969   |   Guest
databases
31 Dec, 1969   |   Guest
dbms out
31 Dec, 1969   |   Guest
maritime institute
31 Dec, 1969   |   Guest
learn sql
31 Dec, 1969   |   Guest
sql server trim
31 Dec, 1969   |   Guest
sql server dba training
31 Dec, 1969   |   Guest
database server
31 Dec, 1969   |   Guest
dvd database software
31 Dec, 1969   |   Guest
dbms engine
31 Dec, 1969   |   Guest
sql cast function
31 Dec, 1969   |   Guest
website database
31 Dec, 1969   |   Guest
database management systems
31 Dec, 1969   |   Guest
sql online training
31 Dec, 1969   |   Guest
sql report builder
31 Dec, 1969   |   Guest
web based database
Showing: 1-20 of 35    »»


Add comment

Others in this Category
document I have a date field in an Oracle table and I want to insert a new record. I'm trying to insert a date with a time component into this field, but I'm having some problems. How can I insert this value into the table? For example, the value is '3-may-03 21:02:44'.
document In PSQL, I want to declare a cursor within cursor. The second cursor should use a value from the first cursor in the "where clause". How can I do this?
document Explain the difference between a hot backup and a cold backup and the benefits associated with each.
document What is wdbsvr.app file used for? What's full path of this file? What's significance of this file ?
document Interview Questions!
document How would you determine the time zone under which a database was operating?
document Explain the use of setting GLOBAL_NAMES equal to TRUE.
document What command would you use to encrypt a PL/SQL application?
document Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
document Explain the use of table functions.
document Name three advisory statistics you can collect.
document Where in the Oracle directory tree structure are audit traces placed?
document Explain materialized views and how they are used.
document When a user process fails, what background process cleans up after it?
document What background process refreshes materialized views?
document How would you determine what sessions are connected and what resources they are waiting for?
document Describe what redo logs are.
document How would you force a log switch?
document Give two methods you could use to determine what DDL changes have been made.
document What does coalescing a tablespace do?
document What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
document Name a tablespace automatically created when you create a database.
document When creating a user, what permissions must you grant to allow them to connect to the database?
document How do you add a data file to a tablespace?
document How do you resize a data file?
document What view would you use to look at the size of a data file?
document What view would you use to determine free space in a tablespace?
document How would you determine who has added a row to a table?
document How can you rebuild an index?
document Explain what partitioning is and what its benefit is.
document You have just compiled a PL/SQL package but got errors, how would you view the errors?
document How can you gather statistics on a table?
document How can you enable a trace for a session?
document What is the difference between the SQL*Loader and IMPORT utilities?
document Name two files used for network connection to a database.
document What is a deadlock and Explain
document What is a Database instance ? Explain
document What is Parallel Server ?
document What is a Schema ?
document What is an Index ? How it is implemented in Oracle Database ?
document What are the basic element of Base configuration of an oracle Database ?
document What is Data Mapping
document Running Multiple DBs on the Same Server?
document Oracle PL/SQL - Introduction


RSS
Powered by KBPublisher (Knowledge base software)