Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
I want to execute a shell script from sqlplus prompt and get its output back to sqlplus. Is this possible?
if yes just give me an example for doing that. (2 Replies)
I tried this:
for region in 'raj' 'kt' 'kol' 'krl' 'chn' 'dl' 'hr' 'bih' 'ap'
do
sqlplus -s huw$region/`echo $region`huw#321@huw$region<<!
set serveroutput on
begin
select count(*) from tcd_preferred_cust_201109
end;
/
exit;
done
but the error shows like:
Syntax error at line 4 :... (1 Reply)
Hi all,
I have a file which I want to split into several files based on a condition. This files has several records. I want one record per file. Each record ends with a //. So, I want to separate files based on this condition. I want split files to be named with the name across the field ID (for... (2 Replies)
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
count=0
while ; do
sqlplus -s $usrname/$password@dbSID <<-EOF | tee $logfile
WHENEVER OSERROR EXIT 9;
WHENEVER SQLERROR... (4 Replies)
Hi ,
Please excuse me for opening a new thread i am unable to find out the syntax error
in my if else condition inside for loop in awk command ,
my actual aim is to print formatted html td tag when if condition (True) having string as "failed",
could anyone please advise what is the right... (2 Replies)
Hi,
facing an issue while calling sqlplus inside shell script. It for some reason goes to tmp file to write something and i get error as permission denied as i dont have access there.
ANy idea why sqlplus writes in /tmp and how to change or stop this ? (2 Replies)
Hello All,
I have exactly same issue @vikas_trl had in following link:
https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html
I wonder if he or somebody else could find the issue's cause or the solution.
Any help would... (4 Replies)
Hi,
I need to perform the untar and rm operation if the file found is a .tar and does not have test.tar or hello.tar as the file names.
Below is the loop to check the same.
for tf in *.tar
do if ]
then found=1
... (1 Reply)
Discussion started by: mohtashims
1 Replies
LEARN ABOUT DEBIAN
audio::mpd::common::item::song
Audio::MPD::Common::Item::Song(3pm) User Contributed Perl Documentation Audio::MPD::Common::Item::Song(3pm)NAME
Audio::MPD::Common::Item::Song - a song object with some audio tags
VERSION
version 1.120881
DESCRIPTION
Audio::MPD::Common::Item::Song is more a placeholder with some attributes. Those attributes are taken from the song tags, so some of them
can be empty depending on the file.
The constructor should only be called by Audio::MPD::Common::Item's constructor.
ATTRIBUTES
album
Album of the song. (format code: %d)
artist
Artist of the song. (format code: %a)
albumartist
Artist of the album. (format code: %A)
composer
Song composer. (format code: %C)
date
Last modification date of the song. (format code: %M)
disc
Disc number of the album. This is a string to allow tags such as "1/2". (format code: %D)
file
Path to the song. Only attribute which will always be defined. (format code: %f)
genre
Genre of the song. (format code: %g)
id
Id of the song in MPD's database. (format code: %i)
last_modified
Last time the song was modified. (format code: %m)
name
Name of the song (for http streams). (format code: %N)
performer
Song performer. (format code: %P)
pos
Position of the song in the playlist. (format code: %p)
title
Title of the song. (format code: %t)
track
Track number of the song. (format code: %n)
time
Length of the song in seconds. (format code: %l)
METHODS
as_string
my $str = $song->as_string( [$format] );
Return a string representing $song. If $format is specified, use it to format the string. Otherwise, the string returned will be:
either "album = track = artist = title"
or "artist = title"
or "title"
or "file"
(in this order), depending on the existing tags of the song. The last possibility always exist of course, since it's a path.
This method is also used to automatically stringify the $song.
WARNING: the format codes are not yet definitive and may be subject to change!
AUTHOR
Jerome Quelin
COPYRIGHT AND LICENSE
This software is copyright (c) 2007 by Jerome Quelin.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-04-01 Audio::MPD::Common::Item::Song(3pm)