like_to_learn

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) data..................So,my question is how to add single quote to already existing single quote.........................I tried in many ways but I …

[code=sql]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 duptest GROUP BY id);[/code] Then you can get the unique records.........................

I think below queries may help you......................... To see the one day before data, use the following Query: [icode]select * from <table_name) as of timestamp (systimestamp - interval '1' day)[/icode] To see the one Hour before data, use the following Query: [icode]select * from <table_name) as of timestamp (systimestamp - …

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 just avoid lables,it will degrade the performance............................. you can run below code to run this for one time likewise 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" function.......... I think it will help you ..........................

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 question,right? here answer is 3 So, you need to write code like declare var1 number;--(to store ques …

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...................

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