|
|
Sponsored Content
Special Forums
UNIX and Linux Applications
Free UNIX with ksh, perl, Oracle and SQL
Post 302529000 by radoulov on Wednesday 8th of June 2011 10:32:43 AM
06-08-2011
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All! I'm new to Unix\Oracle but have been working with MS SQL Server for 8 years. I'm in the process of migrating data from MS to Oracle and have hit a problem.
Some of the information I'm porting over has the following characters in it: ü and Ö to show a few. I'm able to export them out... (2 Replies)
Discussion started by: PattyHernon
2 Replies
2. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
3. Shell Programming and Scripting
HI,
So far i have been worked on sybase with perl and ksh scripts, i don't know how to connect using oralce, if any body could explain that is great.
Thanks in advance.
chendra (3 Replies)
Discussion started by: chendra.putta
3 Replies
4. Shell Programming and Scripting
HI,
I'm trying to get this right, please can you help. In my unix korn shell script, I call an oracle stored proc within a package and I specify 3 parameters, 2 of which are IN OUT parameters (i.e. I expect the stored proc to change them and return them back to me).
Does the unix code... (7 Replies)
Discussion started by: csong2
7 Replies
5. Shell Programming and Scripting
Hi All,
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
SELECT mail_flag
FROM dailyjobs
WHERE job_name = '$1';
exit 0
EOF
exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies
6. UNIX for Advanced & Expert Users
Hi Friends,
is there any site for download the UNIX operating system with Oracle database.
if yes, Please send me the link for download the free Oracle software in UNIX environment.
Thanks
MPS (1 Reply)
Discussion started by: psiva_arul
1 Replies
7. Shell Programming and Scripting
Hi,
I am new to perl.How to query oracle database with perl???
Thanks (1 Reply)
Discussion started by: tdev457
1 Replies
8. Shell Programming and Scripting
Hello,
Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg :
#!/usr/bin/perl
@v_array = (1,2,4,5,6,8);
$db_userid = 'ni71/ni711';
$bufTPO = qx{ sqlplus -s << EOF
$db_userid
set verify off
set feedback off
set... (1 Reply)
Discussion started by: arunshankar.c
1 Replies
9. UNIX for Advanced & Expert Users
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies
10. Shell Programming and Scripting
Hi,
I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop.
The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm) NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle. METHODS
connect PARAMHASH: Driver, Database, Host, User, Password Takes a paramhash and connects to your DBI datasource. database_version Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle. insert Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. build_dsn PARAMHASH Takes a bunch of parameters: Required: Driver, Database or Host/SID, Optional: Port and RequireSSL Builds a dsn suitable for an Oracle DBI connection blob_params column_NAME column_type Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current Oracle implementation only supports ORA_CLOB types(112). apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW; distinct_query STATEMENTREF takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set. AUTHOR
Jesse Vincent, jesse@fsck.com SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)