Posts Tagged ‘Item’

ORACLE : How to Check Only One Item In a Check Box ?

February 7th, 2013, posted in Oracle Queries
Share

Here i will share a tricky PL/SQL code with you.
If you want to use Check Box in oracle forms and want to restrict end user to select only one check box, how will you handle this ?

Just customize the following code and you will get the result :

declare
l_current_record number;
l_last_record    number;
begin
l_current_record := :system.trigger_record;

last_record;
l_last_record := :system.cursor_record;

first_record;

for i in 1 .. l_last_record loop
if :system.cursor_record <> l_current_record then
:SM_ACT_FLAG := 0;
end if;
next_record;
end loop;

go_record(l_current_record);
end;

*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
 well.
********************************************************************************************************************
Share