#DateForumTypeThreadPost
1011 May 2015 @ 09:56 PDTDatabaseReplyNeed help!! Extracting year from table Name sel regexp_replace ('tablename_1203','([a-z]+[_])','');  
916 Dec 2014 @ 11:16 PSTDatabaseReplyExecute immediate - exception handlingIt is resoved...
816 Dec 2014 @ 04:19 PSTDatabaseReplyExecute immediate - exception handlingHello did anyone face the same problem with dynamic sql/dml. If so pls let me know how did you fix it.  
716 Dec 2014 @ 01:18 PSTDatabaseTopicExecute immediate - exception handlingHi All,   I am preparing  a dynamic insert statement in stored procedure, i am excuting it by using execute immeidate. execute immediate (dynamic Insert statement) is failing with sqlc...
627 Nov 2014 @ 11:34 PSTDatabaseTopicFast Load - doesn't load duplicate records in multi set tableHi All, Want to know why fast load do not load duplicate records in multiset table. Please give me the reason behind such behaviour    Thanks, DS  
525 Nov 2012 @ 06:36 PSTDatabaseReplyFind the two pre/post/both the DatesMay be in this way   select case when timeperiod < maturity then timeperiod else timeperiod qualify rank() over (order by maturity, timeperiod de...
426 Oct 2012 @ 10:10 PDTDatabaseReplyto_char function in stored procedureVandeBergB,   I tried by qualifing with TD_SYSFNLIB. Doesn't worked.
325 Oct 2012 @ 09:19 PDTDatabaseReplyto_char function in stored procedure Can any one tell me what should be done to make to_char function work in stored procedure  
224 Oct 2012 @ 03:17 PDTDatabaseReplyto_char function in stored procedureI managed using trunc as below sel (.....,trunc(<table.date_column>,'RM'), ........ )   Anyways thanks a lot!
119 Oct 2012 @ 09:22 PDTDatabaseTopicto_char function in stored procedureHi All,   The below query works fine when i ran it in sql assistant.   sel cast(to_char(trim(extract( month from <table.date_column>)),'09')||'01'||to_char(trim(...