Chuck Oracle Engineer

看了幾篇關於效能調整及Index的文章
分享一下

看了幾篇關於效能調整及Index的文章
分享一下

參考文章
高級訂價概述

參考文章
高級訂價概述

   PROCEDURE get_parameter_create_sql
   (
      p_program_name VARCHAR2,
      p_seq_num_b    NUMBER DEFAULT 1,
      p_seq_num_e    NUMBER DEFAULT 999
   )IS
   
      CURSOR c1 IS
         SELECT REPLACE(descriptive_flexfield_name, '$SRS$.', '') descriptive_flexfield_name,
                application_id,
                column_seq_num,
                end_user_column_name,
                description,
                enabled_flag,
                flex_value_set_id,
                default_type,
                default_value,
                required_flag,
                security_enabled_flag,
                decode(range_code, 'H', 'High',
                                   'L', 'Low',
                                   'P', 'Pair') range_code,
                display_flag,
                display_size,
                maximum_description_len,
                concatenation_description_len,
                form_left_prompt,
                srw_param
           FROM fnd_descr_flex_col_usage_vl
          WHERE REPLACE(descriptive_flexfield_name, '$SRS$.', '') = p_program_name
            AND column_seq_num BETWEEN nvl(p_seq_num_b, 1)
                                   AND nvl(p_seq_num_e, 999)
         ORDER BY column_seq_num;
      
      v_application_name    VARCHAR2(240);
      v_flex_value_set_name VARCHAR2(60);
      v_default_type        VARCHAR2(80);
      v_err_flag            VARCHAR2(1) := 'N';
      
      v_resp_id      NUMBER;
      v_resp_appl_id NUMBER;
   BEGIN

   PROCEDURE get_parameter_create_sql
   (
      p_program_name VARCHAR2,
      p_seq_num_b    NUMBER DEFAULT 1,
      p_seq_num_e    NUMBER DEFAULT 999
   )IS
   
      CURSOR c1 IS
         SELECT REPLACE(descriptive_flexfield_name, '$SRS$.', '') descriptive_flexfield_name,
                application_id,
                column_seq_num,
                end_user_column_name,
                description,
                enabled_flag,
                flex_value_set_id,
                default_type,
                default_value,
                required_flag,
                security_enabled_flag,
                decode(range_code, 'H', 'High',
                                   'L', 'Low',
                                   'P', 'Pair') range_code,
                display_flag,
                display_size,
                maximum_description_len,
                concatenation_description_len,
                form_left_prompt,
                srw_param
           FROM fnd_descr_flex_col_usage_vl
          WHERE REPLACE(descriptive_flexfield_name, '$SRS$.', '') = p_program_name
            AND column_seq_num BETWEEN nvl(p_seq_num_b, 1)
                                   AND nvl(p_seq_num_e, 999)
         ORDER BY column_seq_num;
      
      v_application_name    VARCHAR2(240);
      v_flex_value_set_name VARCHAR2(60);
      v_default_type        VARCHAR2(80);
      v_err_flag            VARCHAR2(1) := 'N';
      
      v_resp_id      NUMBER;
      v_resp_appl_id NUMBER;
   BEGIN

   PROCEDURE get_program_create_sql
   (
      p_program_name VARCHAR2
   )IS

   PROCEDURE get_program_create_sql
   (
      p_program_name VARCHAR2
   )IS

   PROCEDURE get_executables_create_sql
   (
      p_executable_name VARCHAR2
   )IS

   PROCEDURE get_executables_create_sql
   (
      p_executable_name VARCHAR2
   )IS