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

  • Sending spool file as mail attachment

    I need to run a select statement every monday evening at 6, and I need a generated spool file to be sent as a mail attachment to multiple users using PL/SQL, not using a cron tab or shell script.  Ask the Expert

  • Instant grouping!

    I have a table with two columns, C1 and C2. I want to create a report so that on grouping C1 it should retrieve as follows. Please help me with the query.  Ask the Expert

  • Pattern matching

    I need to query a database for entries that match a pattern of any four characters followed by SDS followed by three numeric characters, but %SDS% gets me too many things. Is there a character that represents only one position instead of any number o...  Ask the Expert

  • Who made changes and with what executable?

    We are running Oracle 8i. Management would like a report of who is making what changes to the database. Here's the kicker -- they want to know what executable that person used to execute the SQL. For instance, did they use SQL*Plus or some other ....  Ask the Expert

  • Finding tables with BLOB field

    How to find the tables from a schema which have at least one BLOB field?  Ask the Expert

  • Moving column values from one table to another

    I have two tables wherein I have to get a string of values from one column of one table and pump the retrieved information into a new column in the other table. How do I do this?  Ask the Expert

  • Oracle unveils new tools for .NET developers

    Oracle has unveiled two new free downloads for developers of Microsoft .NET applications who want to get more out of Database 10g.  Article

  • Spooling true error messages only

    Can I spool only errors in SQL*Plus when creating procedures and functions and not spool successful messages such as "Procedure created. No errors"?  Ask the Expert

  • Learning more about data warehousing and Teradata

    I'm working on Oracle (SQL and PL/SQL) right now. I want to know how this will help me to learn about data warehousing. Also, what is Teradata?  Ask the Expert

  • Inserting a BLOB in an Oracle table

    I am using a French front end to connect to an Oracle database back end. Everything is working well except for BLOBs (I have images in one of the tables). I can insert, update and delete all other items. Can you give me the SQL routine to insert a BL...  Ask the Expert

Back to top