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

  • Generating numbers with MAX(id)+1

    In a Ticket table I have a field TicketID. Each time when a user wants to enter a new record, a new ID is generated. The new id becomes result+1. I want to know that the above field is a string.  Ask the Expert

  • COUNT(*) or COUNT(1)

    How do you specify difference between count(*) and count(1) in a select statement? Which is best to use and when?  Ask the Expert

  • One column LIKE another column

    Can one ask for the content of a field in a like condition?  Ask the Expert

  • Expression is of wrong type

    This is a function to check whether the given date is a holiday or not. When I execute this, I am getting an error: "ORA-06552: Statement ignored ORA-06553:PLS-382: Expression is of Wrong Type." What is the problem?  Ask the Expert

  • Oracle SQL Developer gets an update

    Oracle says its newly updated SQL Developer tool includes enhancements that make it easier to create and debug SQL and PL/SQL code.  Article

  • Normalizing a comma-delimited list

    I have a table with data as below. How to write an SQL statement to get this result?  Ask the Expert

  • Search for a value in 12 columns

    I am currently building an Access database. One of the tables contains an employee name and then 12 columns, which each hold a date value. I would like to query all 12 fields at once to look for one date and then pull that record if the date is con...  Ask the Expert

  • Fiscal year in Oracle SQL

    I am trying to do counts for multiple fiscal years. I can do this for calendar years, but have been unable to figure it out for fiscal years.  Ask the Expert

  • GROUP BY multiple columns

    My table structure is empid, category, col1, col2, amount. I would like to get the results as total of amounts for the col1 and col2 combinations, with a particular category.  Ask the Expert

  • What are DDL and DML?

    What are DDL and DML and their commands?  Ask the Expert

Back to top