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 TouchToneTommy 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: *

  • Users: PaullyB
  • Content: Threads
  • Order by date
  1. 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 '...
  2. 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...
  3. 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