Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Hi, We are having multiple .sql files generated programatically which is not containing..
create or replace -- at the start
and
/ -- at the end
We need to append those .sql files with the above 2 statements at their respective positions.
We will be really thankful to get responses... (6 Replies)
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LEARN ABOUT DEBIAN
dbix::class::manual
DBIx::Class::Manual(3pm) User Contributed Perl Documentation DBIx::Class::Manual(3pm)NAME
DBIx::Class::Manual - Index of the Manual
DESCRIPTION
This is the DBIx::Class users manual. DBIx::Class is a SQL->OOP mapper. This means that it can represent your SQL tables as perl classes,
and give you convenient accessors and methods for retrieving and updating information from your SQL database.
SECTIONS
DBIx::Class::Manual::FAQ
Short answers and doc pointers to questions.
DBIx::Class::Manual::Glossary
Explanations of terms used in this documentation.
DBIx::Class::Manual::Intro
Beginner guide to using DBIx::Class.
DBIx::Class::Manual::Example
An example of slightly more complex usage.
DBIx::Class::Manual::Joining
How to translate known SQL JOINs into DBIx-Class-ish.
DBIx::Class::Manual::Cookbook
Convenient recipes for DBIC usage.
DBIx::Class::Manual::Reading
How to read (and write) the reference documentation.
DBIx::Class::Manual::DocMap
Lists of modules by task to help you find the correct document.
DBIx::Class::Manual::Troubleshooting
Got trouble? Let us shoot it for you.
If you're using the CDBI Compat layer, we suggest reading the Class::DBI documentation. It should behave the same way.
DBIx::Class::Manual::Component
Existing components, and documentation and example on how to develop new ones.
perl v5.14.2 2010-09-13 DBIx::Class::Manual(3pm)