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

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

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

To: All Who Love Oracle Challenges Environment: Oracle8i (8.1.7) Scenario: The following records exist in a table: ITEM DEST SRC ---- ---- ---- 1111 101 201 1111 201 202 1111 202 101 or in a generic example, we have: ITEM DEST SRC ---- ---- ---- 1111 A B 1111 B C 1111 C A Question: What...

To: All Who Love Oracle Challenges Environment: Oracle8i (8.1.7) Scenario: The following records exist in a table: ITEM DEST SRC ---- ---- ---- 1111 101 201 1111 201 202 1111 202 101 or in a generic example, we have: ITEM DEST SRC ---- ---- ---- 1111 A B 1111 B C 1111 C A Question: What...

How can I connect to a remote machine using rlogin (or other command) from within a korn shell script? Also, if possible - how can I provide the userid and password automatically, so the script does not stop waiting for the password? Thank you.