For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
SELECT ename, e.deptno, dname, loc FROM emp e, dept d WHERE e.deptno > d.deptno;
DECLARE LEN1 NUMBER; STR VARCHAR2(32767); BEGIN STR := RPAD('*', 4000, '*'); SELECT LENGTH(STR) INTO LEN1 FROM DUAL; DBMS_OUTPUT.PUT_LINE('LEN1: '||LEN1); END;