CREATE TABLE duptest ( Id varchar(5), nonid varchar(5));
INSERT INTO duptest VALUES('1','a');
INSERT INTO duptest VALUES('2','b');
DELETE FROM duptest WHERE rowid NOT IN (SELECT max(rowid) FROM...

I think below queries may help you.........................

To see the one day before data, use the following Query:
select * from <table_name) as of timestamp (systimestamp - interval '1' day)
...

you need to write exit condition for outloop.and one more thing,you need to Decrement the counter value in inner loop ,otherwise it will run for infinite times........................Fist of all you...

why can't you use 'least' function to get the oldest(Greatest) date.....
your requirement is to get Greatest(Oldest) date right?,So you can use "least" function instead of "greatest"...

you need to handled this in "WHEN-LIST-CHANGED"
EX:
table name A,field name :question
question: what is the result of 10+5?
1)25
2)35
3)15
4)45
you know that which is the answer for that...

If your application is developed in forms means,It is very easy to handle......In forms so many pre-defined functions are avaliable to handle all thease things...................

How can I use Replace function?
I am passing the sting dynamically..............
ex:
SELECT REPLACE('&NAME',''',''''') FROM DUAL;
if you run this statement,it will ask the name
then you just...

hai,

My requirement is given below.
In my application one LOV is there to show Insured names.In that if we query for the name like ahemd's% then it is showing wrong(junk)...

Hai Bondo,
you will never get 3 for the above code..please check it once again...........................