set serveroutput on
declare
l_Char_Num varchar2 (40) := '&Enter_Number';
i number;
begin
i := to_number (l_Char_Num);
if ( i = trunc(i) ) then
dbms_output.put_line (i ||' is an Integer');
else
dbms_output.put_line (i ||' is not an Integer');
end if;
exception
when others then
dbms_output.put_line ('Not an Integer');
end proc;
/
Enter value for Enter_Number: 40.6
old 2: p_search varchar2 (40) := '&num';
new 2: p_search varchar2 (40) := '40.6';
40.6 is not an Integer
However, when run with -40, outcome is;
Enter value for Enter_Number: -40
old 2: p_search varchar2 (40) := '&num';
new 2: p_search varchar2 (40) := '-40';
-40 is an Integer
I use this blog as a dumping ground for various scripts as well as solutions to Maths problems.
Labels
- Alter (2)
- Analytic functions (2)
- AQ (2)
- AWR (4)
- Collections (2)
- Connect By (2)
- Constraints (7)
- Date/Time calculations (3)
- Dynamic SQL (4)
- Explain Plan (1)
- Formatting (3)
- Functions (1)
- Generating Functions (1)
- Indexes (7)
- Insert (3)
- JMS (3)
- Joins (4)
- LOB (3)
- locking (5)
- Partitions (3)
- Performance (10)
- Security (1)
- SQL Plus (3)
- Tabibitosan (1)
- Triggers (1)
- Views (1)
- XML (4)
Script categories
- Performance (10)
- Constraints (7)
- Indexes (7)
- locking (5)
- AWR (4)
- Dynamic SQL (4)
- Joins (4)
- XML (4)
- Date/Time calculations (3)
- Formatting (3)
- Insert (3)
- JMS (3)
- LOB (3)
- Partitions (3)
- SQL Plus (3)
- AQ (2)
- Analytic functions (2)
- Collections (2)
- Connect By (2)
- Explain Plan (1)
- Functions (1)
- Security (1)
- Triggers (1)
- Views (1)
Friday, 23 September 2011
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment