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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rozecm
-
Perl in Oracle, how to get output from v$ tables
Hi Travis, you are right!!! Big thanks for help. I am not going to use DBI module because I am developing tool which must use only standard perl installation. I am on multi vendor environment and it is not easy to get permission to install anything on the system. Best Regards, Martin. -
Perl in Oracle, how to get output from v$ tables
#!/usr/bin/perl $s = qx{sqlplus -s "/ as sysdba" <<EOF set head off select * from dba_tables where rownum<5; exit EOF }; @lines = split /\n/, $s; for ($i = 0; $i < scalar @lines; $i++) { print "This is line $i: $lines[$i].\n"; } this script is working right, but if I will change the table... -
Perl in Oracle, how to get output from v$ tables
Hi All, I have created a script which connects to the oracle database and to do select from any table, but if I want to get info from v$ tables, I have an issue. Any help is appreciated. -
RE does not work with variables
Thank you guys, the issue is solved. Best Regards, Martin Rozec. -
RE does not work with variables
Sorry, the output is same like in my first update execution: $ ./test.pl your id output: uid=100(oracle) owner of the directory: oracle Test 3.1.1.1 failed Details: ############################################## ### $user contains value "uid=100(oracle)" ### print "your id output... -
RE does not work with variables
This does not work as well, there is probably issue with converting to the string, I don't really know.: #!/usr/bin/perl $awkcmd = "/usr/bin/awk"; $user = `id | $awkcmd '{ print \$1}'`; $info = `ls -l $ENV{'ORACLE_HOME'} | grep bin | $awkcmd '{ print \$3}'`; if ($user =~ /${info}/g) { print... -
RE does not work with variables
Hello, can someone help, RE does not work if I take string from shell command, last version is storing to the arrays, but still does not work. If you will put directly $userid="uid=100(oracle)" and $homeowner="oracle" it works !!! Where is the error, please. execution: $ ./test.pl your id...
