User Profile

Collapse

Profile Sidebar

Collapse
richardson
richardson
Last Activity: May 24 '07, 09:18 AM
Joined: Feb 9 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • richardson
    started a topic calculate the avg time of two time stamps like start_time and end_tiem
    in Oracle

    calculate the avg time of two time stamps like start_time and end_tiem

    Hi all i need ur help on how to calculate the avg time of two time stamps like start_time and end_time .

    The ideal need is to know the average time taken by each job from a table .

    i tried
    SELECT job_name,AVG(en d_time - start_time) FROM rdbdev.loop_thr ough_job_stats WHERE report_id =12059909 GROUP BY job_name

    the avg returned returns in an exponentiation values like

    9.2592592592592 6E-7...
    See more | Go to post
    • richardson
      started a topic DBMS Job
      in Oracle

      DBMS Job

      How to create a job.how could it be efficiently managed without any locks occuring while a job runs.The scope and how to construct an effecient job.
      See more | Go to post
      • richardson
        replied to alter table
        in Oracle
        ALTER table tablename add SIMPLE_INTREST number set (principal*rate *time)


        I'm not completly sure of this corection r welcome...
        See more | Go to post

          Leave a comment:

        • richardson
          replied to Basic Tips Needed
          in Oracle
          To display all tables we can use

          SELECT * from tab;
          0r
          SELECT * from user_tables;

          To get the output of select statements in a ordered mannaer u can use the set command and its various options like linesize , pagesize...etc...
          See more | Go to post

            Leave a comment:

          • richardson
            replied to Opening a file in Append mode
            in Oracle
            I did look into the directory and file permissions but they have write permission.
            how to go about this.
            See more | Go to post

              Leave a comment:

            • richardson
              started a topic Opening a file in Append mode
              in Oracle

              Opening a file in Append mode

              I tried to open an existing file in Append mode.

              The file exists and also has data.

              file_handle := UTL_FILE.FOPEN( '/usr/oracle/rdb_logs',
              'pacs_report.tx t', 'A');

              It gives an exception utl_file.invali d_operation -"invalid operation had happened"

              How could this be rectified.
              See more | Go to post
              • richardson
                replied to what is schema
                in Oracle
                IT is the definition of an entire database.
                It defines the structure and the type of contents that each data element within the structure can contain.
                Within each schema is database objects like tables, views and previledges.
                See more | Go to post

                  Leave a comment:

                • richardson
                  replied to query to get list of tables
                  in Oracle
                  Thanks for ur reply yadav....

                  wat is the difference from using
                  Code:
                  select * from tab (select tname from tab)

--and

select * from user_tables
                  wen would their usage is appropriate...
                  wat is the previledges offered by a dba in such scenarios to a normal user....
                  See more | Go to post
                  Last edited by amitpatel66; Jan 4 '08, 06:26 AM. Reason: code tags

                    Leave a comment:

                  • richardson
                    started a topic wat is a cursor
                    in Oracle

                    wat is a cursor

                    how can a cursor be written and wat for it is written....its scope and clnstraints...
                    See more | Go to post
                    • richardson
                      started a topic query to get list of tables
                      in Oracle

                      query to get list of tables

                      How to list all the tables created in oracle.
                      how to create views on tables and wat r they for...im very new to oracle...pls help me..
                      See more | Go to post
                      No activity results to display
                      Show More
                      Working...