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 …

In oracle 9i ........How to delete duplicate entries in a table ? if suppose in a table named office, one or more entry(row) is repeated more then twice or minimum twice. I need a query to delete the multiple entries .... Note: --->No constraints applied on the table. --->No Primary …

hi all, can some one help me how to display the fields which enter in current week,current month like that

Hello guys, Just need to know - wats making oracle to stuck when i run this simple pl-sql module declare counter number; begin <<outer>> for counter in 1..10 loop <<inner>> loop insert into lines values(counter); exit when counter=6 or counter=8; end loop inner; end loop outer; end; /

[B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with …

status teacher build exam (question and answer) and student take the exam form build_pre_exam add data into pre_exam table when form run , user(teacher ) have to insert question and four cooses then choose from list item which one i correct answer (to enable to check exam for student) ,after …

Hi, Can anyone help me how to retrieve data from table in the following manner. In my application I have five button namely First,last,next,previous,and Query. When I will press the query button, it should show me last data that I had feed to the table. When I press first button …

Does anyone know how Oracle's PL/SQL handles subtraction with a negative number? Really what I need to know is, given the following: (NOTE: this is NOT the code I'm working with. It's just an example to give and idea of what I'm trying to do.) [CODE] DECLARE number1 NUMBER; number2 …