Search results for query: *

Yes u r right, but anyways i got it sorted myself. Thanks alot for ur responses here is the query which i wrote SELECT a.col1 p_id, b.t2col p_dtl_id, b.item_id, SUM(b.t2QTY) p_qty, d.item_id, SUM(d.t4colqty) gr_qty FROM t1 A, t2 B, t3 C, t4 D WHERE B.COL1 = A.COL1...

Hi Mufasa Very true i have not provided sample data... Anyways i am providing it now, coz the query does not serve the purpose i am looking for... Lets say i have four tables namely T1,T2,T3 AND T4 And their structure is T1 === COL1 NUMBER(10), PK COL2 VARCHAR2(500) T2 === T2COL...

Hi Friends I am trying to achieve a very common business rule, i.e.: I have following tables: 1) PO_HDR - PO_ID PK 2) PO_DTL - PO_ID FK 3) GRN_HDR - PO_ID FK FROM PO_HDR 4) GRN_DTL - GRN_ID FK My requirement is to list only those PO's where the po_dtl qty is less than the grn_dtl qty. Means...

Hi hoinz the application is in PowerBuilder 9.0, Powerbuilder provides run time packager of its own, which says that it includes the drivers required to connect to oracle, but when i try with those runtimes i get error as OCI.DLL or Ora0803.dll not found, this problem is resolved after...

Result says OK. dont know how to put the screen shot in the message gazal

Yes hoinz i have checked its running. i have checked it... gazal

Hi Friends This might not be the appropriate forum to post this question but still as its related to oracle 10g database i m posting it here. I have installed Oracle's free 10g Express edition database on a Machine with Windows XP professional loaded. The database and the related application...

Hello friends, I need to write a query to compare the quotations recived from various vendors item wise. Which means that different vendors may give different prices for the same item... i want to find out the least price for each item and assign a rank to it.... I have gone through oracle's...

Thanks Tharg, Thanks buddy that works really great... Thank u... Gazal

Hello Friends, I have a very common requirement but a very difficult problem (at least for me)... In my application i have a form for generating Requests for Quotations (RFQ's). In the detail part the user will select the Items. I want to filter ONLY THOSE VENDORS who are supplying ALL THE...

i am trying to create a report which gives the number of complaints recieved lastmonth, thismonth, thisyear, till today per category. the query is: select distinct category, decode(reg_date,SUBSTR(ADD_MONTHS(sysdate,-1),4,6),cnt,0) LastMonth, decode(reg_date,SUBSTR(sysdate,4,6),cnt,0)...

hi etiennes you can use GET_ITEM_PROPERTY('item_name',LIST) to determine whether an text item has an LOV or not. Arif

hi ricardo thats not possible, only way is to create your custom LOV, or you can set the OS, selected color property from control panel HTH arif

Hi You can download a trial version of Access to Oracle 1.3 from http://www.convert-in.com/acc2ora.htm the demo version transfers only 5 records but if its useful for u, u can buy the license for it, not sure about the cost. HTH ARif

HI FOLLOWING EXAMPLE SHOWS CONNECTING TO ORACLE FROM VB USING ODBC AND OLEDB BOTH Set cn = New ADODB.Connection ========== ODBC ================= ConString = "Driver={Microsoft ODBC for Oracle};Server=HQTEST;Uid=dgpadc;Pwd=dgpa;" cn.open constring ======== OLEDB ======================...

i have found the solution and here it is SELECT record_no, SUM(DECODE(seq,1,ingredient_code,null)) Active1, SUM(DECODE(seq,2,ingredient_code,null)) Active2, SUM(DECODE(seq,3,ingredient_code,null)) ACtive3 FROM (SELECT record_no, ingredient_code, row_number() OVER (PARTITION...

Hi Guys, I am using Oracle 8i on Windows 2000 server, i have a table which contains a column called Ingredient_Code, its a detail table and has multiple rows, and i want to show them as three different columns for example: Ingredient_Code =============== 971 956 900 Should be shown as...

Hi Musafa Thanks for the example and the time devoted for me. Here is the point, my whole idea of using nested tables or varrays was to avoid storing 75 records for 1 Registration, though your Sql Report will be of great use to me. And Dima i know very well about RDBMS and Master Details...

hi musafa the data is to be entered and saved in similar fashion as its shown, coz its just a part of a registration form, its got nothing to do with individual person and all, its the details of employees in each department of a specific company... any more suggestions... gazal

Hi Musafa here is the sample data once more for ur reference. please show me how do i insert, fetch and update the details in nested table from forms. Qualifications Sr.No Department Phd. Msc. Bsc. Tech Tot ===== =========== ====...