Oracle and SQL

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Time taken to execute query

    Suppose I execute a query like "select * from tab." This statement will give some names of tables. I want to know the time taken for the execution of this statement.  Ask the Expert

  • Problem loading comma-separated values

    I have a problem using comma-separated values to load into an Oracle table using SQL Loader. Due to the presence of a comma in the address provided in the datafile, I am unable to load it successfully.  Ask the Expert

  • Running connect command

    What happens when we run a connect command to the database internally?  Ask the Expert

  • Error at recursive SQL level

    I am getting these errors: "ERROR: ORA-00604: error occurred at recursive SQL level 1"; "ORA-04092: cannot COMMIT in a trigger"; "ORA-06512: at line 3."  Ask the Expert

  • Perl script calling SQL scripts with SQL*Plus

    I have a Perl script that calls several SQL scripts by using SQL*Plus. Whenever there is an error in the SQL script, it returns a value to the Perl that stops the job from running. When the database is down, SQL*Plus does not return any execution err...  Ask the Expert

  • Invalid identifier error

    Can anybody help me with this?: ERROR at line 5: ORA-00904: "MAXAWARDS"."ROLE": invalid identifier  Ask the Expert

  • Counting separate PO numbers for a part

    For the PO table layout below, I need to return that M1 is on two seperate PoNums and M2 is on two PoNums.  Ask the Expert

  • Monday to Sunday weeks in Oracle

    I am trying to retrieve data for the previous week. Using the code below, I get the previous week starting on Sunday and ending on Saturday. How can I retrieve the data from Monday to Sunday?  Ask the Expert

  • Where can I learn to tune SQL queries?

    Where can I get the materials to learn how to tune SQL queries? Any Web sites?  Ask the Expert

  • Delete all but two rows in each group

    I have a table with several columns in the primary key, one of which is timestamp. For each Col4 value, I want to prune the table to make sure that only the two most recent times are in the table for each unique Col2, Col3. I am getting wrapped arou...  Ask the Expert

Back to top