Recent content by soushi01

Hi Im Newbie of MySQL user, Currently im encounter MySQL replication slave server fail sync very frequently like almost happen every month due to slave server power shutdown unexpectedly , then as i know if want re-sync replication slave , need stop slave then backup & restore to slave and...

Hi, PHV tq very much your solution [bigsmile]

Hi, I need display something like this Here is table User_test USER_ID ---- NAME 1 ------------- ADAM 2 ------------- BABY 3 ------------- CATTY 4 ------------- DOGGY 5 ------------- ELLE 6 ------------- FLURRY i want the record display like this...

Hi, PHV Thanks u so much for ur solution. It works [bigsmile]

Hi, Need advise that I need to update number / adding number for one of column by using Nested for loop statement but i have no idea how to write it something like this SQL> BEGIN 2 FOR i IN 1..2 LOOP 3 FOR j IN 1..4 LOOP 4 DBMS_OUTPUT.PUT_LINE('Outer...

Hi I currently do transaction report by cash , criteria is any "transaction by 'cash' " must display in report. other transaction like Cheque no need display [hammer] [hairpull] table_collection IC-------- Item------------ Receipt--- Mode_Of_Payment----- Transaction_STATUS...

Hi, oradba101 Oh i see, tq so much for ur reply. [shadeshappy]

Hi, oradba101 im using oracle 9i as database, for report developing tools im using oracle developer 2000 's report builder and oracle 6i 's report builder thanks

Hi, all Just want to ask that is it oracle report cannot using "CASE WHEN " statement in SQL query statement . Because when i put it , it pop up error message "Unable parse to Query" Please correct me if wrong * Note: im using Oracel reports Developer 200 and oracle reports 6i thanks...

Hi I need to create new statement report , which report criteria is this report don't want show Fees for 2014 [cry] Here is the table called STATEMENT NAME ---- ITEM_FEES -------- PAYMENT_DUE_DATE John ---- E-Learning Fees ----- 14-02-2011 John ---- Course Fee 1 --------...

Hi, PHV and JarlH thanks u so mush both of you for solution. [bigsmile] thanks

Hi I need to create crash time table report, but have no idea how to retrieve the duplicate record... [hammer] Here is CLASS_TIME_TABLE table --------------------------------------------------------------------------------------------------------------------...

hi,PHV its not only use 1 table to update.... it may join more than 4 table... but my problem is solved ..... any thanks for ur solution regards, s1

Hi, im newbie of sql user Im try to write a script to update description base on condition that u insert , the purpose of write this query is for "Remove Title" by using substring , Eg: "TT MOVIE dynasty package" , change description to display "dynasty package" but its pop--up common...

Hi, PH Thanks you so much for the help. Its works :D thanks regards s1