Re: how to select numbers (integers) only?
Looks to me like a case of having two data items in the same field. Bad Idea.
But anyway ...
Why do you need the largest value?
Are you using it to allocate
new Employee Numbers? If so, create another table that holds the last number allocated and use that instead.
(Warning: Air-code)
select *
from last_employee_number ;
+-----------------+
| employee_number |
+-----------------+
| 77 |
+-----------------+
begin transaction ;
update last_employee_number
set employee_number = employee_number + 1 ;
select employee_number
into :eNumber
from last_employee_number ;
insert
into employee( employee_number, . . .
values ( :eNumber, . . . )
commit ;
Regards, Phill W.
Subject
Written By
Posted
Re: how to select numbers (integers) only?
July 17, 2014 06:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.