AI新手程序员

racle帐号scott被锁定如何解锁 具体操作步骤如下： C:> sqlplus 请输入用户名：sys 输入口令：sys as sysdba //注意：在口令这里输入的密码后面必须要跟上 as sysdba 才可以。 SQL> alter user scott account unlock;      用户已更改. SQL> commit;      提交完成. SQL>...

不带参数的游标 DECLARE cursor my_cursor is select xh from xs; v_xh xs.xh%type; begin open my_cursor; fetch my_cursor into v_xh; dbms_output.put_line(v_xh); dbms_output.put_line(my_cursor%rowc...

利用FOR循环统计并输出各个部门的平均工资 DECLARE CURSOR c_1 IS SELECT deptno,avg(sal) avgsal FROM scott.emp GROUP BY deptno; v_dept c_1%rowtype; begin FOR v_dept IN c_1 loop dbms_output.put_line(v_dept.d...