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

  • Highest revision within highest version

    I would like to extract for a particular part number what is the highest version and revision and corresponding serial number.  Ask the Expert

  • Execute SQL statement from table in other schema

    I want to execute SQL statements that use other schema tables from my stored procedure. The stored procedure is in one schema and the table is in the other schema. I am getting the "ORA-01031: insufficient privileges" error.  Ask the Expert

  • Counting rows in runs

    I have a table with fields MarketId and XY, where MarketID is a unique character field and for this example XY can only contain "X" or "Y." I need to count the occurrences of field XY and end up with a result like this.  Ask the Expert

  • Inserting multiple rows in SQL

    How to insert multiple rows of data using insert into command?  Ask the Expert

  • Oracle updates free Web development tool

    Oracle Application Express now offers Microsoft Access migration and .pdf printing support.  Article

  • Composite keys and normalization

    What is composite key and why do we use it? Why go for normalization?  Ask the Expert

  • Add a column in a specific position in a table

    I have created one table with three columns. I want to drop one column and add the column back to the same table in the same location.  Ask the Expert

  • SQL analytics: A self-service model

    SQL analytics is one of the best-kept secrets of the Oracle database. It represents the latest advancement in the evolution of delivering powerful analytic capabilities to end users. This article reviews a brief history at attempts to deliver analyt...  Tip

  • More about ORDER BY for a specified sequence

    How could I sort a query result according to a specific order (not ascending or descending) that I will be supplying from the values of the column to be sorted?  Ask the Expert

  • Useful SQL commands for new Oracle DBA

    I am a new Oracle DBA and I am very poor in Oracle SQL commands. Can you provide me with a list of useful SQL commands?  Ask the Expert

Back to top