Database

Le@rner wrote:

get all column name list of current database.

Did you mean get all column name list of current table.

Blue_Boy wrote:

Did you mean get all column name list of current table.

ERROR at line 7:
ORA-06550: line 7, column 7:
PLS-00103: Encountered the symbol "S" when expecting one of the following:
. ( * @ % & - + / at loop mod remainder rem ..
<an exponent (**)> || multiset
The symbol "loop" was substituted for "S" to continue.
ORA-06550: line 8, column 27:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max min pr
ORA-06550: line 9, column 24:
PLS-00103: Encountered the symbol "`" when expecting one of the following:
( ) - + case mod new not null select <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
table continue avg count current exists max

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