78-100 日新行 第一次使用PL SQL 写一些SQL语句

 

     环境不一样，影响还是蛮大，very 不熟悉 的地方。 

 

Connected to Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 
Connected as lc0019999@10.110.86.25/orcl
--设置服务的输出开启 
SQL> set serveroutput  on;  
SQL> declare               
       current_date date ;=to_date('2020-10-1','yyyy-mm-dd');                                                                                                                                                                                          
      begin          
  2  dbms_output.put_line('当前系统时间：');
  3   dbms_output.put_line(current_date);--put_line 换行
  4  end;
  5  
  6  /
当前系统时间：
30-12月-21
PL/SQL procedure successfully completed

SQL> begin 
  2  dbms_output.put(1+1); --put不换行
  3  end;
  4  
  5  
  6  /
PL/SQL procedure successfully completed

SQL> begin
  2  dbms_output.put(1+1);
  3  dbms_output.put_line('x');
  4  end;
  5  /
2x
PL/SQL procedure successfully completed

SQL> begin
  2  dbms_output.put(1+1);
  3  dbms_output.put_line('');
  4  end;
  5  /
2
PL/SQL procedure successfully completed

SQL>