Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PaullyB

    I am trying to write a pl/sql proc. that will compile invalid objs?

    How do I deal with invalid views? The DBMS_UTILITY package does not seem to do this.
  2. PaullyB

    I am trying to write a pl/sql proc. that will compile invalid objs?

    Please disregard the "to_char"'s in my example. The actual procedure I am trying to compile does not have them. My fault there. I am new with system packages, so I do not know everything that is available. I tried the dbms_utility.compile_schema procedure. Everything worked okay...
  3. PaullyB

    I am trying to write a pl/sql proc. that will compile invalid objs?

    I am trying to write a procedure that will compile all invalid objects under a particular schema in the database using dynamic sql. Here is an example of the procedure I have come up with that does not compile: CREATE OR REPLACE PROCEDURE TWPEDB.TEST AS CURSOR COMPILE_CURS IS select 'alter '...
  4. PaullyB

    Renaming Files in a Directory

    I need to rename all files in a directory on an NT Server. The current filenames are *_*.wmf I need to strip out the _* from the name. For example, a file named AOL_1.wmf should be renamed to AOL.wmf Does anybody know an easy way to do this for all files in a directory via a VB executable or...
  5. PaullyB

    What is the SQL Server's equivalent to the DUAL table in Oracle?

    I am new to SQL Server. I am curious if there is a SQL Server equivalent to the DUAL table in Oracle? Thanks, PB

Part and Inventory Search

Back
Top