#!/bin/bash
sqlplus -s xxxx/xxxx@$ORACLE_SID <<EOF
SET HEADING OFF
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE
SALARY NUMBER(8);
BEGIN
SELECT SAL INTO SALARY FROM EMP WHERE EMPID=123;
DBMS_OUTPUT.PUT_LINE(SALARY);
-- write your editing and update instructions of pl/sql here
END;
/
exit;
EOF
Hi Friends,
Can u please help mw with the following query .
I need to run a database sql statement to select particular fields from a table.I need to store the retrieved filed values into variables so that i can print it in a specific format. But the particular select query retrieves more... (12 Replies)
Hi,
My requirement is :
We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this.
Can you please share a code snippet which... (4 Replies)
I know there are caveats about using read in pipelines because read is treated by a subshell. I know this but I can't think of any way to accomplish this regardless, I'm still a rookie.
I hope somebody will be able to interpret what it is that I'm trying to accomplish and correct me.
... (2 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Hi
I'm using an oracle database... Lets call it databasename
My username and password are the same .... lets all that andrea/andrea
So I want to write a script to copy all the data from my table called tablename and store that data to a csv file called filename.
I cant seem to get... (2 Replies)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Hi..
We have a table DB_QUERIES, in which sql queries are stored.
SQL> desc DB_QUERIES
Name Null? Type
----------------------------------------- -------- ----------------------------
QUERY_ID NOT NULL NUMBER(10)
... (2 Replies)
Hi All,
I have written a (bash) function which generates multiple files say file1 file2 file3
now I want to reduce the generation of these three files i.e. store the output of three files in variables, and generate the same results, in-order to avoid multiple creation of files
how is that... (7 Replies)
Hello
Just edited the entry to make it easier to understand what i want
How can i achieve this: GOAL:
read 2 field from a table with PSQL
result of this PSQL command is this
INSTALLEDLANG=$(su - postgres -c "psql -A -t -q -c -d ${DBNAME} -t -c 'SELECT code, iso_code from res_lang'")
... (0 Replies)
Discussion started by: winston6071
0 Replies
LEARN ABOUT OPENDARWIN
unicode_start
UNICODE_START(1) General Commands Manual UNICODE_START(1)NAME
unicode_start - put keyboard and console in unicode mode
SYNOPSIS
unicode_start [font [umap]]
DESCRIPTION
The unicode_start command will put the keyboard and console into Unicode (UTF-8) mode.
For the keyboard this means that one can attach 16-bit U+xxxx values to keyboard keys using loadkeys(1), and have these appear as UTF-8
input to user programs. Also, that one can type hexadecimal Alt-xxxx using the numeric keypad, and again produce UTF-8.
For the console this means that the kernel expects UTF-8 output from user programs, and displays the output accordingly.
The parameter font is a font that is loaded. It should have a built-in Unicode map, or, if it hasn't, such a map can be given explicitly as
second parameter. When no font was specified, the current font is kept.
NOTE
Unicode mode is a parameter with a value per virtual console. However, usually the font and keymap is common to all consoles.
SEE ALSO dumpkeys(1), kbd_mode(1), loadkeys(1), unicode_stop(1), utf-8(7), setfont(8)
3 Feb 2001 UNICODE_START(1)