Search results for query: *

...for CHANNEL 'DBname-01'; 5) login mysql replication slave server, then i run Start Slave for channel 'DBname-01'; * But is very time consuming and somemore only can do non-operation hours especially do backup and restore part due to file size. Is it possible any "shortcut way" can skip the...

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

...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 regards Peggy Leong

...Fee 5 -------- 14-03-2013 John ---- Course Fee 6 -------- 14-09-2013 I can write like this but this is "hardcode" .... [cry] SELECT *FROM STATEMENT WHERE TRUNC(PAYMENT_DUE_DATE,'YYYY') NOT in ('2014,2015') I looking another solution but using function SYSDATE minus year but i hv...

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

Hi, im newbie of SQL user Note: I use in MySQL I attach sql script called testdb.sql http://www.filefactory.com/file/cbe7a69/n/testdb.sql I have 2 table which is product1,product2 Product1 PID ProductName ProductCode 1 Nike N1 2 Adidas A2 3 NewBalance NB1 4 Puma...

Hi,LB As i know can use Cross-Tab to display compare the year, other than that, can write some formula , then display like a cross-tab format. i try this formula before but i don't think is best way create formula @Year2010 -> if {Year}="2010" then {Revenue} create formula @Year2009 -> if...

Hi, LB Year & month just a String value. thanks regards s1

hi, Im a newbie of crystal report user i hv a data like this, need to display Actual year (base on revenue 2010), then Last year (base on revenue 2009) Year Month Product Revenue 2010 Jan_____ A_____ 2230 2010 Feb_____ A_____ 2000 2010 Mar_____ A_____ 4100 2010 Apr_____ A_____ 3000 2010...

thanks Hilfy for the solution its works :D