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

Engineer Telling His Mobile Number

February 6th, 2013, posted in COMiCS
Share

Engineer Telling His Mobile Number

Share

Nobody Cared Who I was Until I Put On The Mask

February 5th, 2013, posted in COMiCS
Share

 Nobody Cared Who I was Until I Put On The Mask,mask,batman,bane,vendetta,spiderman,the mask,zorro,the phatnam of opera

Share

Another Stanza By Bulleh Shah

February 4th, 2013, posted in Bulleh Shah, Sufism
Share

poetry of bullah-e-shah

Stanza by Bullah-e-Shah

Share

A Artistic View Of Sufism

February 3rd, 2013, posted in Art, Sufism
Share

sufi art

This is a breathtaking water color painting made by S. a. Noori. An article about a recent exhibition in Islamabad covers the spirituality that lives in them:

From Tribune.com./pk :

” Noory’s work is nuanced with Sufism- white bearded men in trance, holding the Quran. Perhaps the most intriguing piece is a painting of a tall, bearded man with his hand outstretched upwards holding onto a rope as he looks serenely towards the sand. The rope goes straight into the sky and out of the painting where the viewer is left wondering where the other end of the rope must be. “

You can read the complete article here.

Share