Sponsored Content
Special Forums UNIX and Linux Applications Please help: Oracle gqsql or sqlplus output format like mysql Post 302777741 by Linusolaradm1 on Friday 8th of March 2013 10:52:29 AM
Old 03-08-2013
Please help: Oracle gqsql or sqlplus output format like mysql

On psql

Code:
select titolo,lingua from titolo where titolo ~*  'brivid';

Code:
 titolo  | lingua 
 ------- + ------  
 Brivido | 1

On Sqlplus/gqsql

Code:
SQL> select titolo,genere,anno,lingua  from titolo where titolo like '%rivid%';

Code:
TITOLO --------------------------------------------------------------------------------     GENERE ANNO     LINGUA ---------- ---- ---------- 
Brivido      1 1986      1

How can format the sql output on sqlplus to do something similar like mysql or psql?
Thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ... (2 Replies)
Discussion started by: deepakgang
2 Replies

2. Shell Programming and Scripting

Help needed to format mysql output

Hi all, Does anyone know how to format the output from mysql from within a shell script? i.e. RESULT=`mysql command` echo ${RESULT} the ${RESULT} only displays the output on one line instead of how mysql would display it as columns etc (3 Replies)
Discussion started by: muay_tb
3 Replies

3. Shell Programming and Scripting

Formatting Oracle sqlplus output

a job extracts orcle data into unix as flat file. a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records. (its not single record in two line. but its single record into record. ie., \n come into picture) can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies

4. UNIX for Dummies Questions & Answers

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies

5. Shell Programming and Scripting

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies

6. Shell Programming and Scripting

Format the output from sqlplus while writing to log file.

Hi I have developed bash script to connect to database and execute .sql files. I am logging some statements in to log file using echo. While logging I am adding the date in front of the log statements which makes sense. I am unable to add date in front of output from the sqlplus and sqlldr,... (8 Replies)
Discussion started by: murtymvvs
8 Replies

7. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies

8. Shell Programming and Scripting

Need help getting my output from MYSQL query into right format

Good afternoon! I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first. I have poured some blood, sweat and tears into... (4 Replies)
Discussion started by: brianjb
4 Replies

9. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

10. UNIX for Beginners Questions & Answers

Sqlplus code format

Hi, I have some questions about sqlplus running from bash. I am still new and learning. I have the code shown below: echo "exit" | sqlplus... (10 Replies)
Discussion started by: mohca2020
10 Replies
MAKE-LINGUA-IDENTIFY-LANGUAGE(1p)			User Contributed Perl Documentation			 MAKE-LINGUA-IDENTIFY-LANGUAGE(1p)

NAME
make-lingua-identify-language - creates language modules for Lingua::Identify SYNOPSIS
make-lingua-identify-language Language-Tag Language-Name file1 [file2 ...] or make-lingua-identify-language -d TAG1-LANGUAGE1/ [TAG2-LANGUAGE2/ ...] or make-lingua-identify DESCRIPTION
Creates language modules to be used by Lingua::Identify. After creating the modules, you still have to install them. Please note that this script is still at an early stage. Please do not even look at the code... Without parameters, make-lingua-identify-language assumes mode -d and goes through all the directories in the current one. This is useful to be used in a directory where you something like this: . |-- en-english | `-- english.txt |-- fr-french | `-- french1.txt | `-- french2.txt `-- pt-portuguese `-- portuguese.txt OPTIONS -d Directory mode. Each parameter passed should be a directory whose name must be of the form tag-name (e.g., en-english/ ). Each of the directories passed should contain text files that can be used to train Lingua::Identify. -D Debug mode. Only for development. -h Display help and exit. -v Show version and exit. -verbose Verbose mode. -locale="<locale>" Set a specific locale. This way your text will be all lowercased before analysed. META.yml "META.yml" files are not parsed as other files, they are ignored. In directory mode ("-d" switch), "META.yml" files are checked for info on languages codes and sets. Here's a simple "META.yml" for you to put in your directories: two_letter_code: pt three_letter_code: por sets: spoken_in_portugal With that, the language will be identified with the two letter code "pt" or the three letter code "por"; it will also be in the set ":spoken_in_portugal". CONTRIBUTING WITH NEW LANGUAGES
Please do not contribute with modules you made yourself. It's easier to contribute with unprocessed text, because that allows for new versions of Lingua::Identify not having to drop languages down in case I can't contact you by that time. Use make-lingua-identify-language to create a new module for your own personal use, if you must, but try to contribute with unprocessed text rather than those modules. SEE ALSO
Lingua::Identify(3), langident(1) A linguist and/or a shrink. The latest CVS version of "Lingua::Identify" (which includes make-lingua-identify) can be attained at http://natura.di.uminho.pt/natura/viewcvs.cgi/Lingua/Identify/ ISO 639 Language Codes, at http://www.w3.org/WAI/ER/IG/ert/iso639.htm AUTHOR
Jose Alves de Castro, <cog@cpan.org> COPYRIGHT AND LICENSE
Copyright 2004-2005 by Jose Alves de Castro This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-01-02 MAKE-LINGUA-IDENTIFY-LANGUAGE(1p)
All times are GMT -4. The time now is 05:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy