Please see input in attached file
Now what I need in output is
Code:
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
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;
Leave a comment: