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
Awaluddin Hamid <[EMAIL PROTECTED]> wrote:
Senang bisa membantu.
Untuk blog sendiri, sampe saat ini belum sempat buat mas, masih sebuk
sama internal proyek.
Di internet sih, sebenarnya sangat banyak bertebaran contoh2 SQL,
tinggal kita aja yg memodifikasinya sesuai kebutuhan.
Acuan utama tetap ke situsnya oracle, oracle.com, download.oracle,
forum.oracle, asktom.oracle, dsb.
Sebagai pelengkap, untuk standar SQL syntax, saya biasanya ke
http://www.psoug.org.
Sedang untuk tipsnya ke http://www.fast-track.cc/.
rgds,
AH
aly rmb wrote:
>
>
> btw, mungkin bung AH punya Blog mengenahi SQL, yg bisa di share ke
> kita ? :)
> slm/Al
>
> Recent Activity
>
> *
> 11
> New Members
> <http://groups.yahoo.com/group/indo-oracle/members;_ylc=X3oDMTJmdDE1djg4BF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyMTAyMTE0NTk->
>
> Visit Your Group
> <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJlZ2lrY2VnBF9TAzk3MzU5NzE0BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTIxMDIxMTQ1OQ-->
>
>
> Yahoo! Finance
>
> It's Now Personal
> <http://us.ard.yahoo.com/SIG=13oomqqas/M=493064.12016257.12445664.8674578/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1210218659/L=/B=iENyCNFJq2s-/J=1210211459396334/A=4507179/R=0/SIG=12de4rskk/*http://us.rd.yahoo.com/evt=50284/*http://finance.yahoo.com/personal-finance>
>
> Guides, news,
>
> advice & more.
>
> Y! Groups blog
>
> the best source
> <http://us.ard.yahoo.com/SIG=13on50nae/M=493064.12016258.12582637.8674578/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1210218659/L=/B=iUNyCNFJq2s-/J=1210211459396334/A=5191955/R=0/SIG=112mhte3e/*http://www.ygroupsblog.com/blog/>
>
> for the latest
>
> scoop on Groups.
>
> Special K Group
>
> on Yahoo! Groups
> <http://us.ard.yahoo.com/SIG=13p6vhcq2/M=493064.12016300.12445692.11323196/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1210218659/L=/B=ikNyCNFJq2s-/J=1210211459396334/A=5170420/R=0/SIG=11b5gu1oe/*http://new.groups.yahoo.com/specialKgroup>
>
> Join the challenge
>
> and lose weight.
>
> .
>
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
