• August 07, 2006 07 Aug'06

    Executing procedures with desktop icon

    I am creating PL/SQL procedures on my local machine and compiling them using Benthic software. Is there a way to invoke/execute these procedures using a desktop icon/link?  Continue Reading

  • August 07, 2006 07 Aug'06

    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.  Continue Reading

  • August 07, 2006 07 Aug'06

    Checking PL/SQL packages

    How to check if the data populated into a table is correct when a PL/SQL package is executed? How to check whether data populated by executing an old package and a modified package is the same?  Continue Reading

  • August 07, 2006 07 Aug'06

    Command to view stored procedure

    Which command is used to view a stored procedure?  Continue Reading

  • August 04, 2006 04 Aug'06

    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.  Continue Reading

  • August 04, 2006 04 Aug'06

    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 ...  Continue Reading

  • August 03, 2006 03 Aug'06

    Stored procedure to auto-transfer data between servers

    I have two servers, one is Oracle 9i and the other is 10g. I plan to put a stored procedure in the 10g server that will auto-transfer data into the 9i server daily. How do I write the procedure to connect to the 9i server? Can the stored procedure ...  Continue Reading