id   a            b           c         d           e           f
-------------------------------------------------------------------------
1    de,en,fi,sv  de,en,fi,sv en,fi     de,fi       de,en,fi    de,sv
2    de,en,fi,sv  en,fi       sv        en,sv

create table langdtl(id int,speak_flag int,read_flag int,ia_flag int,lit1_flag int,lit2_flag int,lit3_flag int,lang nvarchar(2))

insert into langdtl values(1,1,1,1,1,1,0,'fi')
insert into langdtl values(1,1,1,0,0,0,1,'sv')
insert into langdtl values(1,1,1,1,0,1,0,'en')
insert into langdtl values(1,1,1,0,1,1,1,'de')

SELECT TO_CHAR
          (NEXT_DAY (LAST_DAY (TO_DATE ('SEP', 'MM')) - 7,
                     TO_CHAR (TO_DATE ('29-01-1927', 'DD-MM-YYYY'), 'DAY')
                    ),
           'DD.MM.YYYY'
          ) "Last Saturday of SEP-2010"
  FROM DUAL;

declare
  v_count number(10);
begin
  for rec in (select 'select count(*) from ' || table_name stmt, table_name
                from user_tables) loop
    execute immediate rec.stmt
      into v_count;
    dbms_output.put_line('Total Number of Records in ' || rec.table_name

DECLARE
newname VARCHAR2(20); 
BEGIN
SELECT surname
  INTO newname
  FROM tableb
 WHERE NAME = 'PHATZ';
LOOP
INSERT INTO tablek
            (NAME)
   SELECT z.NAME
     FROM tablez z
    WHERE z.NAME = newname
      AND ROWNUM <= 50000
      AND NOT EXISTS (SELECT k.NAME
                        FROM tablek

select row_number() over(order by invdtl.sl_no) srno,invdtl.fyear_code,invdtl.inv_no,invdtl.inv_date,invdtl.ature,
invdtl.inv_total,invdtl.bal_amount,invdtl.client_code,invdtl.amt_received
from (select row_number() over(order by b.inv_no) as sl_no,b.fyear_code,b.inv_no,b.inv_date,b.service_n ature,
b.inv_total,c.bal_amount,b.client_code,b.amt _received 
from fn_receipt a, 
trn_invoice_history

SELECT username FROM user_users;