Search results for query: *

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

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

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

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

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

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