Shulou(Shulou.com)06/01 Report--

Insert the date of one year into the data table:

Insert into T_HOLIDAYselect SEQ_T_HOLIDAY.NEXTVAL xh,to_date (20160101 recording YYYYMMDD') + level-1 date_time,0 date_type from dual connect by level 1) and rowid not in (select min (rowid) from table group by gh,cdate having count (*) > 1)-- string capture SUBSTR (string,start_position, [length]) substr ("ABCDEFG", 0);-- return: ABCDEFG, intercept all characters substr ("ABCDEFG", 2) -- return: CDEFG, intercept all characters substr ("ABCDEFG", 0,3) after starting from C;-- return: ABC, intercept 3 characters from A-return ABCDEFG,100 exceeds the string length without affecting the result. The system returns substr ("ABCDEFG", 0100) according to the maximum number of preprocessed strings. -- returns EFG. A negative value means that the string arrangement position remains unchanged from the tail ("ABCDEFG",-3).

Concatenate a column in the table into a string:

Select WMSYS.WM_CONCAT (t.representid) from DEPT_INFO_EXTEND t-specify; separate select replace (WMSYS.WM_CONCAT (t.representid),':') from DEPT_INFO_EXTEND t

Change the validity period of user password from 180 to indefinite by default

-- enter sqlplus mode sqlplus / as sysdba;-- to check the validity period settings of the user's password (generally default configuration file is DEFAULT, note case) SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';-- changes the password validity to indefinite, and automatically takes effect ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED after modification;-- the account changes the password again, alter user user name, identified by original password Log in with the modified user, and unlock the alter user db_user account unlock;commit if you report "ORA-28000: user is locked".

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.