Hi,
I'd like to add one line to the top of my file.
I know there is a command to be able to do it.
But I forgot ......
Please help if you can .... (3 Replies)
Hi,
Can anyone tell me how to print the column name anong with the value from the table in shell script e.g
#!/bin/ksh
var=`sqlplus scott/tiger << -e
set heading off feedback off
select * from emp;
quit;
e`
echo $var
My output should be;
... (5 Replies)
:rolleyes: hi there everybody,
i need help,... thanks anyway!
i am working on a very huge table with the name table1. the problem is that i know only one field name in this table...,
working with a ksh environment i don't know how to view the table to check out the field names :confused:.
... (4 Replies)
I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.
I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)
data_12 ... (6 Replies)
Hi, I am running a shell script on Compaq Tru64 UNIX V5.1A. I have attached the shill script with the sql script it is calling to extract some data(hyp_dta_Extr.sql), and the results. I need the file to be tab delimited. (please note that I have renamed hyp_dta_Extr.sql to hyp_dta_Extr.txt to... (1 Reply)
Please advice to rectify below error
#!/bin/ksh
X=$(sqlplus -s user/pass << EOSQL
set serveroutput on;
set heading off feedback off serveroutput on trimout on pagesize 0
INSERT INTO TEST(df)
VALUES('a');
COMMIT;
EXIT;
EOSQL)
echo $X
echo $?
ERROR at line 2: ORA-00984: column not... (1 Reply)
Hi everyone,
I have a file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10... (1 Reply)
Hi, all, I have a file that looks like:
## XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
## YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
#AA AB AC AD AE AF AG AH AI AJ AK AL
20 60039 60039 ... (5 Replies)
Hi All,
The below code is splitting the file "data.csv" into several files based on the"client_code" column.
date_yyyymmdd=$(my_date "" -e"%Y%m%d")
file_format="_$date_yyyymmdd.csv
awk '{print $2, $3> DIR"/clients_" $1 file_out}' FS=' *; *' OFS=";" DIR="$TEMPL" file_out="_$file_format"... (3 Replies)
Hi,
Below is the format of a report generated by a custom reporting solution. I opened the report in Notepad++ and junked data and values as in the image below.
https://www.unix.com/attachment.php?attachmentid=7907&stc=1&d=1575507708
I want to convert the values to a PIPE delimited format as... (2 Replies)
Discussion started by: ramkrix
2 Replies
LEARN ABOUT DEBIAN
sqlline
SQLLINE:(1) User Commands SQLLINE:(1)NAME
sqlline - JDBC command-line utility for issuing SQL
SYNOPSIS
sqlline [ option... ]
DESCRIPTION -u <database url>
the JDBC URL to connect to
-n <username>
the username to connect as
-p <password>
the password to connect as
-d <driver class>
the driver class to use
--color=[true/false]
control whether color is used for display
--showHeader=[true/false]
show column names in query results
--headerInterval=ROWS;
the interval between which heades are displayed
--fastConnect=[true/false]
skip building table/column list for tab-completion
--autoCommit=[true/false]
enable/disable automatic transaction commit
--verbose=[true/false]
show verbose error messages and debug info
--showWarnings=[true/false]
display connection warnings
--force=[true/false]
continue running script even after errors
--maxWidth=MAXWIDTH
the maximum width of the terminal
--maxColumnWidth=MAXCOLWIDTH
the maximum width to use when displaying columns
--silent=[true/false]
be more silent
--autosave=[true/false]
automatically save preferences
--outputformat=[table/vertical/csv/tsv]
format mode for result display
--isolation=LEVEL
set the transaction isolation level
--help display this message
Usage: java sqlline.SqlLine
-u <database url>
the JDBC URL to connect to
-n <username>
the username to connect as
-p <password>
the password to connect as
-d <driver class>
the driver class to use
--color=[true/false]
control whether color is used for display
--showHeader=[true/false]
show column names in query results
--headerInterval=ROWS;
the interval between which heades are displayed
--fastConnect=[true/false]
skip building table/column list for tab-completion
--autoCommit=[true/false]
enable/disable automatic transaction commit
--verbose=[true/false]
show verbose error messages and debug info
--showWarnings=[true/false]
display connection warnings
--force=[true/false]
continue running script even after errors
--maxWidth=MAXWIDTH
the maximum width of the terminal
--maxColumnWidth=MAXCOLWIDTH
the maximum width to use when displaying columns
--silent=[true/false]
be more silent
--autosave=[true/false]
automatically save preferences
--outputformat=[table/vertical/csv/tsv]
format mode for result display
--isolation=LEVEL
set the transaction isolation level
--help display this message
-u <database url>
the JDBC URL to connect to
-n <username>
the username to connect as
-p <password>
the password to connect as
-d <driver class>
the driver class to use
--color=[true/false]
control whether color is used for display
--showHeader=[true/false]
show column names in query results
--headerInterval=ROWS;
the interval between which heades are displayed
--fastConnect=[true/false]
skip building table/column list for tab-completion
--autoCommit=[true/false]
enable/disable automatic transaction commit
--verbose=[true/false]
show verbose error messages and debug info
--showWarnings=[true/false]
display connection warnings
--force=[true/false]
continue running script even after errors
--maxWidth=MAXWIDTH
the maximum width of the terminal
--maxColumnWidth=MAXCOLWIDTH
the maximum width to use when displaying columns
--silent=[true/false]
be more silent
--autosave=[true/false]
automatically save preferences
--outputformat=[table/vertical/csv/tsv]
format mode for result display
--isolation=LEVEL
set the transaction isolation level
--help display this message
sqlline August 2008 SQLLINE:(1)