Search results for query: *

Hi dagon, if i dont ad the group by in the second query, the query doesnt work ( and if i dont list all the headers from the select list, it doesnt work either)

Hey there, all of you with precious infos and help . Here i come again with a new problem for you to help me with ;) I do have a monthly script, wich runs nicely. i was asked to change it, to have a second one that does increment each month my test is here = but it doesnt work...

i wonder too ;) but I did find a solution (partial one) If i dont call upon Act and Fon tables, the query is working even though they define the fon_refn and act_code lines.... strange behavior in this DBA .. the working query : SELECT aff_type, fon_refn, act_code, sum( AFF_MNT_FF)...

that was the first thing we tried..doesnt solve the problem ;) But , having discussed the issue with the previous IT manager of the entreprise it would seem that the problem is either with Aide_fon or Aide_act tables, wich were wrongly built (The DBA was managed for years by someone with no IT...

already tested that ( first things i did test .... ) when i had a 4th table i do get many error stops in toad. (random ones...) as if toad cant manage 4th tables at a time. or maybe my server cant ? (memory or cache or such thing ?? )

Hi there, Got a problem that returns an ora-00900 error code.and i dont see the problem the query is : SELECT aff_type, aide_aff.fon_refn, fon_iden, aide_regl.act_code, sum( AFF_MNT_FF) FROM AIDE_AFF, AIDE_REGL, aide_fon WHERE AIDE_AFF.REGL_NUM =...

Oracle is filled using a 3rd party app (quest v2) When i request the datas using TOAD, i do have all the rows, the users using Quest only have the first 1000 rows . all the following rows are blank

Hey guys, i need your experience here;) We use oracle 8, and today some customers reported that regarding a table (financial one... ouch) all the entries they did since the 23rd october dont appear, the lines are blank , but incremented is there a limit to the number of datas ? entries...

Hey there, We do use an old version of SQLBase (Gupta/Quest v2.1) And today we did find something "funny" or irritating, depending on who you ask . requesting between two tables ('aide_dos' and 'aide_exe') both have "dos_refn" in comon If you request one or another for a value, stat or...