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!

  • Congratulations strongm 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. albitzt

    Recursive Folder Loop and Date Constraint

    Finally got this working...Posting in case this can save someone else some time.... Set FSO = CreateObject("Scripting.FileSystemObject") Set objFile = FSO.CreateTextFile("C:\vb_output.log", True) ShowSubfolders FSO.GetFolder("D:\backups") Sub ShowSubFolders(Folder) For Each Subfolder in...
  2. albitzt

    Recursive Folder Loop and Date Constraint

    Hi All, First off let me say thanks in advance for taking a look. I have been messing around with the code below that I put together for a few different sources. I'm a Newbie, so knowledge is limited. The end goal is I need a script that sets a root folder and looks through *only folders) under...
  3. albitzt

    PLSQL| Goto Label Hangs Script

    stefanhei -- Dead on!!! This is perfect. It is exactly what I was trying to accomplish. using the CASE and loop makes a lot of sense now that I'm looking at the way you constructed this. Thanks so much for the help :-) .
  4. albitzt

    PLSQL| Goto Label Hangs Script

    An update...So I am partially just impatient. The script does come back with: Declare * Error at line 1: ORA-06500: PL/SQL: storage error ORA-04030: out of process memory when trying to allocate 16356 bytes ORA-06512: at sys.dbms_output", line 127" ORA-06512: at sys.dbms_output", line 113"...
  5. albitzt

    PLSQL| Goto Label Hangs Script

    Hello, I am in the process of writing a script and I'm having some difficulty with using 'GOTO' label. Once I hit return it just sits there. Here is the generic code: set serveroutput on DECLARE var_num1 number(25) NOT NULL := 0; sql_stmt varchar2(30); BEGIN <<BLOCK_CHECK>> IF var_num1 >...
  6. albitzt

    Using Max function to select from a variable

    Makes sesnse..Thanks for the response.
  7. albitzt

    Using Max function to select from a variable

    The code is already written and at this point I'm not reflecting on it and I was wondering what I was missing, or if you simply cannot do this. In the below example, what I was looking to do is this: SELECT @PKVAL=max(@PK_COL_NAME) from pcattype Thanks in advance...
  8. albitzt

    Selecting distinct on two columns and grouping by row count

    Thanks jbenson001 for the attempt. And thank you gmmastros for the solution. Worked like a charm.
  9. albitzt

    Selecting distinct on two columns and grouping by row count

    Seeking assistance on this one... Sample Data Set: rsrc_hr_id rsrc_id ts_id ----------- ----------- ----------- 100 200 300 101 200 301 102 201 302 103 201 302 Looking for help with a query to query the data set where it...
  10. albitzt

    Script creating tablespaces and users using variables

    I looked at this for a good ten minutes and overlooked that every time. -Thanks karluk.
  11. albitzt

    Script creating tablespaces and users using variables

    I created the following script which works almost perfectly. I wanted a section at the top to modify the physical and logical tablesapce names and teh usernames. It works fine, with the exception of when you run it, it prompts me to enter the 'DATFILE_PHYSICAL' value. Once that is done, the...
  12. albitzt

    Having trouble creating a trigger

    Thanks RiverGuy. Did the trick.
  13. albitzt

    Having trouble creating a trigger

    I have been working at this for an hour now and with no success. --Table 1 tblSessions session_id login_time user_name --Table 2 tblLastLogin user_name last_login_date Currently tblSessions gets cleared by a stored procedure. I don't want to modify any existing objects. I am looking to have a...

Part and Inventory Search

Back
Top