Recent content by vgg

Hi Just call it by its name,qualifying with the package name(if it belongs to a package) and passing the arguments(if any). Say you have package pkgA and another pkgB. You can call a procedure procB from procA like this procedure procA(v_arg1 [IN|IN OUT|OUT] data_type1,v_arg2 [IN|IN OUT|OUT]...

Hi, Instead of writing everything in main just have a method and test all your conditions and check for the user's input. If the input is not as specified,display the appropriate message and call the same function again,recursively. VGG

Hi , Here's an example: SELECT /*+ PARALLEL(e,10,DEFAULT) */ ename,sal FROM emp e; Note: 1.The first argument to the PARALLEL hint specifies the alias to the table(is a must). 2.The second argument specifies the degree of parallelism. Can also be DEFAULT. 3.The third argument specifies...

Hi mkey, 1.Analyze the execution of the query using EXPLAIN PLAN and determine which access path and indexes are choosen by the oracle optimizer.(If the operation is FULL TABLE scan ,then it means your optimizer is not considering the indexes you created.just because you created indexes doesn't...

Oops!! I left that out.Thanks for the correction justice. VGG

Hi, You can even try this. foreach $file (@files) { if(! -d $file) { open (NEWNAME, &quot;head -1 $file&quot;) || die &quot;Cannot open $file:$!&quot;; @rnm = <NEWNAME>; close(NEWNAME); rename &quot;$dir/$file&quot;,&quot;$dir/$rnm[0]&quot;; } }

Yes thats right. Specify the pattern as />/ and check. I am presently not on a PERL assignment so I am helpless in testing the solution. VGG

hi select to_char(sysdate,'DAY fmDDth MON YYYY HH:MM:SS') as Today from dual; VGG

Please modify the query: select * from search_table where lower(search_column) like lower('search_word%'); VG

Hi, I assume you give the search condition in the &quot;where&quot; clause.Then you can give your query as something like this: select * from search_table where lower(search_column) like 'lower(search_word)%'; You can create a function based index for lower(search_column) to improve...

Hi mkey, try this out.. execute immediate 'insert into my_table values('||X||chr(44)||Y||')'; VGG

Hi mkey, In my example I have stored the result in a variable of type TABLE,the same you can try with VARRAY as well. TYPE empnumtyp is VARRAY(100) OF NUMBER(4); VGG

Hi, Actually I have declared the cursor variable as an IN OUT parameter and I have defined the cursor itself in the stored procedure. I am returning the cursor to a ResultSet object in the host(java) program. You can change the cursor definition inside the stored procedure by using an IF..THEN...

hi, You can use the following perl special variables, $` ->stores whatever precedes the currently matched pattern $& ->The pattern that you gave. $' -> The characters that follow the given pattern. So in your case, $` will have &quot;before&quot; $& will hold &quot;>&quot; and $' will...

hi, Hope this example helps you. /* * This sample shows how to call a PL/SQL procedure that opens * a cursor and get the cursor back as a Java ResultSet. */ import java.sql.*; import java.io.*; import oracle.jdbc.driver.*; class RefCursorExample { public static void main (String args...