Search results for query: *

Hello, What is the proper way to check for the number of command line parameters in Windows? In Unix there is something like: # If the number of command-line parameters # is not 10, then do something. if [[ $# -ne 10 ]] then ... fi How do we "translate" that into a Windows batch file code...

Hi sem, Unfortunately, I'm under the gun to finish this task and don't have time to publish what you've asked me. The key here is - how we update the records in tab_A - one at a time or many at a time. Your idea is great, no doubt about that! Throughout the course of this discussion, both...

Hi sem, Thank you for your idea. I tried it. The elapsed time does not look very promising - close to 10 minutes compared to my best of 224 seconds. I need to take another avenue. Thanks. Regards, <ruse7013>

Hi sem, Yes, that's what my challenge is. If you take a look at my original message, it's all said there. Thanks, <ruse7013>

Hi sem, In your suggestion above: UPDATE tab_A SET c1 = f1(c1,c2,c3), c2 = f2(c1,c2,c3), c3 = f3(c1,c2,c3) where is the "WHERE" clause? I guess, there should be one. Otherwise, how do we know that the update is done for a specific group of c1,c2,c3? In other words: UPDATE tab_A SET...

Hi sem, The value conversion doesn't take too much time. So, I'll test your idea and see what happens. BTW, what's RBS? Thanks, <ruse7013>

Hi sem, Please take a look at: ... processing of c1,c2,c3 ... getting new values of c1,c2,c3 c1,c2, and c3 are interdependent. A function is called w/ the old values as IN params. For every cursor iteration, ALL three old values are taken into account in order to determine what the...

Hi Himanshu, I've done it. It didn't improve the elapsed time too much. However, I had a challenge of declaring the type of the bulk collection that would keep the ROWID values. Is this correct: TYPE typ_Rowid IS VARRAY(1000) OF VARCHAR2(50); I tried: TYPE typ_Rowid IS VARRAY(1000) OF...

Environment: Oracle 8i (8.1.7) Scenario: Three columns are retrieved - CURSOR cur_name IS SELECT c1, c2, c3 FROM tab_A; Let's say the original retrieved values are equal to: c1=old_value1, c2=old_value2, c3=old_value3 Some processing take place and we find new values of c1, c2, and c3...

Hello Himanshu, Actually, I found the init.ora as initSID.ora. However, I wouldn't be able to open it due to unsufficient access permissions. Also, I found this: "Consider increasing the value of the DISTRIBUTED_TRANSACTIONS when an instance regularly participates in numerous distributed...

Hello Himanshu, I found file init.ora in $ORACLE_HOME/dbs However, there is not a parameter called distributed_transactions in file init.ora What can I advice my DBA as fas as setting that parameter? What's the best (or safe) value? Thank you. <ruse7013>

Hello, Environment: Oracle8i Scenario: A package/procedure is executed under object owner "A" in db_schema "A". A cursor is retrieving records from a table "B1" from db_schema "B" (via a db_link!) using BULK COLLECT. Ultimately, all the records are INSERTed (via a db_link!) with FORALL INTO...

Sposibo, Dima! Regards, <ruse7013>

Hi Himanshu, You are right. I found the problem in the foo() function. It's related to: SELECT SYSDATE FROM DUAL; TWO records are returned instead of ONE: 5/5/2004 12:45:36 PM 5/5/2004 12:45:36 PM How can you explain that? I added: SELECT SYSDATE FROM DUAL WHERE ROWNUM = 1; ... but I...

Env: Oracle 8.1.7 The following procedure is executed: -------------------------------------- PROCEDURE proc_name AS CURSOR cur_name IS SELECT col1, col2, rowid FROM table_name; BEGIN FOR rec_name IN cur_name LOOP BEGIN v_var3 := foo(rec_name.col1, rec_name.col2)...

Oracle DB version: 8.1.7 Scenario: --------- There are three tables A, B, and C. All of them have columns - c1, c2, and c3. Table A has about 30 million recods, table B - about 60 million records, and table C - about 1.5 million records. Question: --------- With one query, how can we...

OS: AIX 4.3 Scenario: FTP from UNIX-AIX 4.3 to MVS I tried this: ftp> quote site lrecl=60 unit=DISK ucnt=5 blksize=27960 pri=1000 sec=500 cy ... but didn't work. Any idea? Thanks. <ruse7013>

OS: AIX 4.3 Scenario: FTP a File to Mainframe. I want to allocate enough file space on the mainframe side with the UNIT parameter in the FTP command: ftp> quote site lrecl=$LRECL unit=$UNIT blksize=$BLKSIZE pri=$PRI sec=$SEC cy What are the options for $UNIT parameter? I need to specify...

The end of a sequence occurs when a SRC value (child) is equal to a DEST value (parent/ancestor), a.k.a. self-referencing. For instance, please take a look at my original example: Record #1 – For a specific ITEM (1111), DEST of “A” is a parent of a SRC of “B”. Therefore, SRC of “B” is a...

Hi lewisp, Thank you for your idea. The challenge has been resolved. It's a very short and "cute" solution. Regards, <ruse7013>