Validating null value in pl sql

04-Dec-2016 22:53

The table exists like this because we are still adding in new parameters for the app.

In VB, there is a function "isnumeric()" which will accomplish this but does not seem to be the same in pl/sql? BEGIN l_test_number := l_string_that_might_hold_a_number; .... code that should run when it is in fact a number...... code that should run when it is in fact NOT a number..... end; I seem to remeber some highly regarded Oracle person saying that it is a bug if you use a "when others" that is not followed by a raise...

validating null value in pl sql-29validating null value in pl sql-61

Here is a look back at those years, and here's to the next 40! I asked a question about date validation a few days ago..the response did not work for some reason.

In 40 years, there's been some amazing functionality in the database.

For nearly half of that time, Ask Tom has been there.

- Mark I was refering to a "Shurley Shome Mishtake" from Private Eye a satirical mag that you probably don't see a lot of outside of britain (but should) however I do agree that any of the code included could raise an error and cause the code to switch to thinking it's not a valid number. e.g., take the values 1500, 15e00 and 15.00 we know that they are numbers (not all necessarily look like numbers).

The question is: Does the customer want them ALL treated as numbers?

Here is a look back at those years, and here's to the next 40! I asked a question about date validation a few days ago..the response did not work for some reason.

In 40 years, there's been some amazing functionality in the database.

For nearly half of that time, Ask Tom has been there.

- Mark I was refering to a "Shurley Shome Mishtake" from Private Eye a satirical mag that you probably don't see a lot of outside of britain (but should) however I do agree that any of the code included could raise an error and cause the code to switch to thinking it's not a valid number. e.g., take the values 1500, 15e00 and 15.00 we know that they are numbers (not all necessarily look like numbers).

The question is: Does the customer want them ALL treated as numbers?

Oracle delivers an API in EBS that can validate Email Address Format.