9 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I am trying to create a shell script to insert in to oracle table
so far insert happens with out an issue,
but i cant pass message variable to sqlplus script insert. i have highlighted the variable in red.
thanks in advance.
df -H | grep -vE... (3 Replies)
Discussion started by: LPK
2. Shell Programming and Scripting
hi , i have some procedures that were written in oracle (sql/plsql).
I need to convert them into shell scripts. So is there any procedure to this. or any tools available to do this. I need some guidance on this as i am totally new . I dont know shell scripting at all. My main target get the logic... (5 Replies)
Discussion started by: harishbabuy
3. Shell Programming and Scripting
I am trying to connect to oracle database (220.127.116.11.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
echo... (10 Replies)
Discussion started by: fidelis
4. Shell Programming and Scripting
I am using Sun Solaris and Oracle 10g.
I have a simple shell script returning a value.
dummyvar=`sqlplus -s '/as sysdba' <<END
set feedback off;
set verify off;
set serveroutput on;
select num from scott.num1;
For the above script - i... (5 Replies)
Discussion started by: user7509
5. UNIX for Advanced & Expert Users
Kindly suggest on how should i proceed with the following requirement
I need to develop an interactive shell script menu which would enable the user to inquire the value of a column based on a key value . The output can be more records..
Also is it possible to do the following
1)... (2 Replies)
Discussion started by: ksm
6. Shell Programming and Scripting
I haven't worked on oracle much but I have a situation where I have to do bdf in all the servers and insert that information into oracle table. I have already created table which have 7 columns, I can insert manually but I dont know how to insert that using Korn shell.
SERVER_ID ... (9 Replies)
Discussion started by: pareshan
At work we are using AIX 4.2 for the client. On this system, there is Oracle and kron, Bash and C shell.
Is it possible to access Oracle via the shell to create/update tables ?
There is this hourly data that we accumulate on the AIX and we manually copy the infos to Excel for stats. I thought... (2 Replies)
Discussion started by: Browser_ice
8. Shell Programming and Scripting
I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any?
Thanks for reading and in advance of posts,
B14... (2 Replies)
Discussion started by: B14speedfreak
9. Shell Programming and Scripting
I have Oracle, and I want to execute simple queries in it. Is it possible to do this using a UNIX shell scripts. Are there any commands in Shell scripting where in I can communicate to ORACLE!?
Thanks, (2 Replies)
Discussion started by: mohanprabu
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
Read details in documentation for DBD::Oracle module.
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.
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
BLOBParams FIELD_NAME FIELD_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).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
Return undef, as Oracle doesn't support binary-safe CLOBS
Returns value of ORA_OCI constant, see "Constants" in DBI.
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
Jesse Vincent, email@example.com
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)