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

  • Logs to view transactions entered in application

    How can I view all the transactions that entered my application if I want to trace some of the transactions for a specific time or all the time? Are there any logs that I can retrieve?  Ask the Expert

  • Exact contents of redo logs

    I want to know the contents of the redo logs. Do redo logs contain exact data inserted by users or instructions to redo transactions in case of failure?  Ask the Expert

  • What is an outer join?

    What is an outer join? How is it advantageous over an inner join?  Ask the Expert

  • Declaring same variable twice in a package

    Recently, I tried declaring and initializing the same variable twice with different values each time in a PL/SQL package. To my surprise, it got compiled without any errors. I tried the same in a procedure and got a complier error.  Ask the Expert

  • Counting rows in a UNION query

    How can I get the total count of the number of records returned, not duplicate, from the union of two queries which return the same set of data but using different where clause?  Ask the Expert

  • Foreign keys in a composite primary key

    Is it possible to use one of the attributes of a composite primary key as a foreign key?  Ask the Expert

  • Joining tables without common columns

    How do I join two tables without common columns and display any two columns, all records in a corresponding table?  Ask the Expert

  • Combine multiple lines of text into one

    I have a table that I created from a flat file. I have thousands of records. What is my best approach to normalize this? I would like to keep the multiple lines of text, but put them into one field.  Ask the Expert

  • What is normalization?

    What is normalization?  Ask the Expert

  • Steps to use SQL Developer

    Please let me know how I can get my hostname, service name and the port number to be able to run SQL statements and do other things on Oracle SQL Developer.  Ask the Expert

Back to top