天籁

ORACLE：prompt、set feedback、set defineprompt PL/SQL Developer import fileprompt Created on 2017年7月7日 by adminset feedback offset define offprompt Deleting BLSC.CONFIG_SMS...delete from BLSC.CONFIG_

ORACLE：复制表表：T_POINT_GRADE_KG_TESTSQL> SELECT * FROM T_POINT_GRADE_KG_TEST;GRADE IS_SEND SMS_CONTENT---------- ---------- -----------------------------------------------------------------------

ORACLE：加字段、加字段说明、验证字段JSON格式SQL> SELECT * FROM T_POINT_GRADE_KG_TEST;GRADE IS_SEND SMS_CONTENT---------- ---------- -----------------------------------------------------------------------------

Oracle：触发器说明：oracle触发器，对指定表进行增删改操作，触发逻辑操作。SQL> create or replace trigger agreement_trigger 2 after update or insert or delete on base_agreement_template_test 3 for each row 4 begin 5

ORACLE-over()函数用法 select annual_rate, invest_amount, self_amt from busi_order_bak;SQL> select annual_rate, invest_amount, self_amt from busi_order_bak;ANNUAL_RATE INVEST_AMOUNT SELF_AMT