terimakasih banyak atas pencerahannya ...
Awaluddin Hamid <[EMAIL PROTECTED]> wrote: Bukan karena kurungnya
tidak berpasangan mas, tp database yg digunakan
belum support analytic function di dalam blok PL/SQL.
Jika dipakek di blok PL/SQL, querynya harus dimodifikasi menjadi:
INSERT INTO table_3 (data_uid, amount)
SELECT DISTINCT a.data_uid, ABS(a.amount- b.amount) amount
FROM
(SELECT data_uid,
SUM(amount) amount
FROM table_1
GROUP BY data_uid)a,
(SELECT data_uid,
SUM(amount) amount
FROM table_2
GROUP BY data_uid)b
WHERE a.data_uid = b.data_uid
AND a.amount != b.amount;
hth,
AH
aly rmb wrote:
>
> Sorry, tanya lagi,
> klo kita tambahin insert, sbb :
>
> INSERT INTO table_3 (data_uid, amount)
> SELECT DISTINCT a.data_uid, ABS(a.amount- b.amount) amount
> FROM
> (SELECT data_uid,
> SUM(amount) OVER (PARTITION BY data_uid ORDER BY 1) amount
> FROM table_1)a,
> (SELECT data_uid,
> SUM(amount) OVER (PARTITION BY data_uid ORDER BY 1) amount
> FROM table_2)b
> WHERE a.data_uid = b.data_uid
> AND a.amount != b.amount;
>
> klo ini di jalanin di SQL, ini success,
> tp klo di compale di PL/SQL, muncul error : "Encountered the symbol
> "(" when expecting one of the following : , from"
> cursornya tunjuk ke "(" yg saya bold
>
> setahuku klo error ini, biasanya kurungnya ngga' berpasangan.
>
> slm/Al
>
>
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
