文章分类 -  Oracle

摘要：In oracle/PLSQL, the substr functions allows you to extract a substring from a string. The syntax for the substr function is: substr( string, start_position, [ length ] ) 说明： string is the source s... 阅读全文

摘要：record示例： create or replace procedure pro_test_record(vid in varchar2) is type userRow is record( id t_user.id%type, name t_user.name%type ); realRow userRow; begin select id,name into realRow from t_... 阅读全文

摘要：语法：TRUNC（date[,fmt]） D,WQ @1j!ES1} M| j0 TRUNC（number[,decimals]） Select trunc(TO_DATE('24-11-1999 08:00 pm','dd-mm-yyyy hh:mi am')) RESULT From dual ＝　11/24/1999 ,jw2@#tX8~,b0select trunc(sys... 阅读全文