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

  • Mike Ault's Oracle "good practices"

    In this six-part tip, Mike Ault offers Oracle "good practices" in categories including the Oracle environment; backup, failover and disaster recovery; system security; design; coding; and performance management and tuning.  Tip

  • ORA-01702: a view is not appropriate here

    I'm creating an index on a view using Oracle 9.2.0. I get the error ORA-01702 (a view is not appropriate here).  Ask the Expert

  • Sorting data in varchar2 field

    I have a database field defined as varchar2. Some of the records are numeric and some are alphanumeric. How do I sort out the data?  Ask the Expert

  • Number of columns in primary and foreign keys

    Why must the number of columns in primary keys match the number in foreign keys?  Ask the Expert

  • How tkprof works for tuning

    How does the tkprof utility work for SQL tuning?  Ask the Expert

  • Eliminating partition tables during export

    We are upgrading our database from Oracle 8i to 10g. While taking the export, how can we eliminate the partition tables?  Ask the Expert

  • When "grouped by" means ORDER BY

    I have a table with the following fields and I want to retrieve the results in the following form. TName and TicketNo must be grouped by DateIssue. Since the "Group By" clause uses aggregate functions only, the following type of query will not run.  Ask the Expert

  • First or third Monday of the month?

    Given a date that falls on Monday, how can I know if it is the first or third Monday of the month?  Ask the Expert

  • Why isn't Oracle user-friendly?

    Working with SQL Server is simple. Oracle is an enterprise database and powerful but why has it never been user-friendly?  Ask the Expert

  • Query to delete duplicate records in column

    We have a table with duplicate records for columnA, and we want to make columnA the primary key. For this we need a query to delete the duplicate records so that columnA will have only unique values.  Ask the Expert

Back to top