Coba aja script ini
DECLARE
CURSOR REPET IS
SELECT ACCNAME,DEBIT FROM ACCS WHERE ACCNAME='PTA';
X_ACCNAME VARCHAR2(10);
X_DEBIT NUMBER;
X_I NUMBER;
BEGIN
OPEN REPET;
LOOP
FETCH REPET INTO X_aCCNAME,X_DEBIT;
FOR X_I IN 1..X_DEBIT-1
LOOP
DBMS_OUTPUT.PUT_LINE (X_aCCNAME);
END LOOP;
EXIT WHEN REPET%NOTFOUND;
END LOOP;
END;
--- In [email protected], eko suprijantono
<[EMAIL PROTECTED]> wrote:
>
> Saya fikir g bs... paling hrs buat script u/ insert ke table baru
sbanyak n kali sesuai table... baru bs query dr table baru tsb... CMIIW
>
>
>
> ----- Original Message ----
> From: AnRof Rawnan <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Wednesday, October 15, 2008 1:08:28 PM
> Subject: [indo-oracle] Tanya query Oracle
>
>
> Rekans,
>
> seandainya saya punya table seperti ini :
>
> | Nomer | Hit |
> | 628XXX | 3 |
> | 628YYY | 2 |
>
> kira2 bisa tidak saya mendapatkan query seperti di bawah ini :
>
> | Nomer |
> | 628XXX |
> | 628XXX |
> | 628XXX |
> | 628YYY |
> | 628YYY |
>
> Terima kasih sebelumnya.. .
>
> --
> YM_id : muh_ilman_a
> http://misisawa. blogspot. com
> http://anrof. myminicity. com/
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
