Database

DECLARE
        cursor  c1 is select * from dept;
        cursor  c2 is select * from emp;
        s emp.sal % type;
BEGIN
    for i in c1
    loop
        s:=0;
        dbms_output.put_line(‘-----------------------------------------------------’);
        dbms_output.put_line(‘Department is:’║ i.deptno║’Department name is:’║i.dname);
        dbms_output.put_line(‘---------------------------------------------------------’);
        for j in c2
        loop
            if(i.deptno=j.deptno)then
                s:=s+j.sal;
                dbms_output.put_line(j.empno║ ‘ ‘║j.ename ║’ ‘║j.sal);
            end if;
        end loop;
        dbms_output.put_line(‘--------------------------------------------------------’);
        dbms_output.put_line (‘Total salary is:’║s);
        dbms_output.put_line(‘--------------------------------------------------------’);
    end loop;
END;
/

SELECT a.a1, sum(a.aa2), sum(b.aa2)
FROM (SELECT a1, sum(a2) as aa2 FROM Table1 GROUP BY a1) as a,
(SELECT a1, sum(a2) as aa2 FROM Table2 GROUP BY a1) as b
WHERE (a.a1=b.a1)
GROUP BY a.a1;

UNION

SELECT a1, sum(a2), 0
FROM Table1
WHERE a1 not in (SELECT a1 FROM Table2)
GROUP BY a1

UNION

SELECT a1, 0, sum(a2)
FROM Table2
WHERE a1 not in (SELECT a1 FROM Table1)
GROUP BY a1

vanikanc wrote:

How can I check if the main part of the file exists, just xxx part so I can rename it? When I use the fileexist, it looks for the entire filename and hence not finding the file.

Bastard Programmer from Hell

AbrahamMOKDAD wrote:

each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data;

AbrahamMOKDAD wrote:

How would you go on about it?

Bastard Programmer from Hell