Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ronanBas
  • Content: Threads
  • Order by date
  1. ronanBas

    String buffer too small

    The following function returns the delimited string CREATE OR REPLACE FUNCTION GET_DELIMITED_STR ( p_cursor sys_refcursor, p_del varchar2 := ',' ) return varchar2 is l_value varchar2(32767); l_result varchar2(32767); begin loop fetch p_cursor into l_value...
  2. ronanBas

    using dynamic SQL and CURSUR effectively

    Im updating the table GLRS.TBL_GLRS_GT_PRC_FEED with the enriched data based on the OPICS_TYPE value usng two approaches The other mapping tables are GLRS.TBL_GLRS_OPICS_RULES and GLRS.TBL_GLRS_OPICS_TYPE CREATE TABLE GLRS.TBL_GLRS_OPICS_RULES ( TBL_GLRS_OPICS_RULES_ID NUMBER(38,0) not...
  3. ronanBas

    IF ELSIF removal

    In my procedure I have used IF ELSIF often . The part of the procedure is as attached . is there any other way to replace the IF ELSIF in above case and improve performance or may be remove the cursor loop completely ? Thanks create or replace FUNCTION fn_tenor_bucket (...
  4. ronanBas

    Remove if else and use CASE instead

    Friends How can we use CASE statements in the following code 28: IF (V_SOURCE_CODE = 'DEPOSIT') THEN DELETE FROM INTERIM_AUTO_CASHFLOW AC WHERE EXISTS (SELECT * FROM...

Part and Inventory Search

Back
Top