User Profile

Collapse

Profile Sidebar

Collapse
dilippanda
dilippanda
Last Activity: Sep 11 '07, 11:49 AM
Joined: Jun 13 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • dilippanda
    replied to Improve Insertion rate in oracle
    in Oracle
    Number of records are around 80000.
    Both the table has around 13 columns and 3 indexes.

    What should be done in such cases?

    Please guide me.

    Thanks,
    Dilip...
    See more | Go to post

      Leave a comment:

    • dilippanda
      started a topic Improve Insertion rate in oracle
      in Oracle

      Improve Insertion rate in oracle

      Hi All,

      I am experiencing performance issue while merging records from a select query.
      Also it is getting difficult to insert 100000 selected records into table which is taking around 30 mins.

      I have tested the select query which is taking around 40 sec to fetch 1Lakh records.

      Is there anyway to improve the insertion rate?

      Thanks,
      Dilip
      See more | Go to post
      • dilippanda
        started a topic Global temporary table
        in Oracle

        Global temporary table

        Hi,

        How to use global temporary table.

        I want to create a temporary table in my package and insert/update the records in that temporary table for some manipulations.

        How can i achieve that?

        Thanks,
        Dilip
        See more | Go to post
        • dilippanda
          started a topic Help in Query
          in Oracle

          Help in Query

          Hi,

          I have the following query.

          select distinct a.*,b.launch_dt
          from
          (
          select
          list_id,
          run_seq,
          resp_dt,
          sum(udl_count),
          sum(ecu_count),
          sum(clk_count),
          sum(coa_count),
          grp_cd,
          sum(taf_count),
          sum(opn_count),
          sum(usb_count),
          site_cd

          from
          (SELECT
          list_id,
          run_seq,
          ...
          See more | Go to post
          • dilippanda
            replied to Insert data from pl/sql table in Oracle
            in Oracle
            Hi,

            Actually i have to select data into a pl/sql table using bulk collect and then i want to insert all the records of the pl/sql table into my destination table with out using any loop.

            Please guide me with a sample code.

            Thanks,
            Dilip...
            See more | Go to post

              Leave a comment:

            • dilippanda
              started a topic Insert data from pl/sql table in Oracle
              in Oracle

              Insert data from pl/sql table in Oracle

              Hi All,

              I want to select data from emp table and store them in a pl/sql table.

              After storing them in the pl/sql table i want to insert the records into emp1 from pl/sql table .

              Note:While inserting records into emp1 i don't want any loops.

              Please help me in this.

              Thanks,
              Dilip
              See more | Go to post
              • dilippanda
                started a topic Help in group by query
                in Oracle

                Help in group by query

                Hi,

                Please help me in the following query.

                SELECT
                a.bcast_id ,
                a.bcast_file_nm ,
                a.clickthru_url _cd ,
                a.list_id ,
                a.prs_id ...
                See more | Go to post
                • dilippanda
                  replied to External tables in Oracle
                  in Oracle
                  Hi,

                  The link you have provided tells
                  2.EXTERNAL TABLES CAN BE QUERIED IN THE SAME WAY AS STANDARD TABLES IN JOINS,VIEWS.... .AND CAN USE ALL TYPES OF FUNCTION ON THE EXTERNAL TABLE.

                  But i am not able to select data from my external table.

                  I also don't have grant privileges grant priveleges on the directory.

                  Please suggest me.

                  Thanks,
                  Dilip...
                  See more | Go to post

                    Leave a comment:

                  • dilippanda
                    replied to External tables in Oracle
                    in Oracle
                    Hi,

                    wrk_cbx_respons e_ext is the external table in my scenario.

                    Whenever i am trying to select data from this table it is throwing me the following error.

                    ERROR at line 1:
                    ORA-29913: error in executing ODCIEXTTABLEOPE N callout
                    ORA-29400: data cartridge error
                    KUP-04040: file CBX_Response_Fe edback^20070405 _1.dat in GCA_CBXRF not found
                    ORA-06512: at "SYS.ORACLE_LOA DER",...
                    See more | Go to post

                      Leave a comment:

                    • dilippanda
                      started a topic External tables in Oracle
                      in Oracle

                      External tables in Oracle

                      Hi,

                      Please let me know about the concept behind External tables.
                      How to select data from External Tables.

                      It's urgent for me.
                      Please help me.

                      Thanks,
                      Dilip
                      See more | Go to post
                      • dilippanda
                        replied to Error in PL/SQL block
                        in Oracle
                        Hi,

                        EMP table has been created in SCOTT user.
                        I am able to create and select tables in that user.So that user has create table privileges and select privileges.

                        Is there any other problem?

                        Thanks,
                        Dilip...
                        See more | Go to post

                          Leave a comment:

                        • dilippanda
                          started a topic Error in PL/SQL block
                          in Oracle

                          Error in PL/SQL block

                          Hi,

                          While executing the following block i am getting error as Insuffiecient privilege.

                          CREATE OR REPLACE PROCEDURE ddl_create_proc (p_table_name IN VARCHAR2)
                          AS
                          l_stmt VARCHAR2(200);
                          BEGIN
                          DBMS_OUTPUT.put _line('STARTING ');
                          l_stmt := 'create table '|| p_table_name || ' as (select * from emp )';
                          EXECUTE IMMEDIATE l_stmt;
                          DBMS_OUTPUT.PUT _LINE('end ');
                          EXCEPTION ...
                          See more | Go to post
                          • dilippanda
                            replied to database design.(rehan)
                            in Oracle
                            Please Refer to Oracle Articles in this Article section of this forum.

                            Thanks,
                            Dilip...
                            See more | Go to post

                              Leave a comment:

                            • dilippanda
                              started a topic JOINS In Oracle
                              in Oracle

                              JOINS In Oracle

                              Hi,

                              I want to know in which case should we use Hash Join and Merge Join?

                              Please give me an example.

                              Thanks,
                              Dilip
                              See more | Go to post
                              • dilippanda
                                replied to How Indexes improve performance?
                                in Oracle
                                Thank you very much....
                                See more | Go to post

                                  Leave a comment:

                                • dilippanda
                                  started a topic How Indexes improve performance?
                                  in Oracle

                                  How Indexes improve performance?

                                  Hi,

                                  Can you please explain me how indexes improve performance?
                                  And where to use which index?

                                  A link will also be useful for me.

                                  Thanks,
                                  Dilip
                                  See more | Go to post
                                  • dilippanda
                                    started a topic Connect by In Oracle
                                    in Oracle

                                    Connect by In Oracle

                                    Hi,

                                    Can anyone please guide me the use of connect by clause with one example?

                                    Awaiting for your reply.

                                    Thanks,
                                    Dilip
                                    See more | Go to post
                                    • dilippanda
                                      started a topic Advantages and Disadvantages of a Stored Procedure
                                      in Oracle

                                      Advantages and Disadvantages of a Stored Procedure

                                      Hi,

                                      What are the advantage and disadvantages of a stored procedure in PL/SQL?

                                      Please guide me.

                                      Thanks,
                                      Dilip
                                      See more | Go to post
                                      • dilippanda
                                        replied to IN OUT parameters in Procedures
                                        in Oracle
                                        Hi Debashish,

                                        Thanks for the link.
                                        But can you please make me understand what is the difference between OUT and INOUT parameter.I could not make out the difference between OUT and IN OUT Parameter from the link provided by you.

                                        Please help me.

                                        Thanks,
                                        Dilip...
                                        See more | Go to post

                                          Leave a comment:

                                        • dilippanda
                                          started a topic IN OUT parameters in Procedures
                                          in Oracle

                                          IN OUT parameters in Procedures

                                          Hi,

                                          Please give me an example of a procedure having IN OUT parameters.

                                          Also please let me know the difference between OUT and IN OUT parameters in PL/SQL procedures.

                                          Thanks,
                                          Dilip
                                          See more | Go to post
                                          No activity results to display
                                          Show More
                                          Working...