09-14-2009
Accessing the variable from pl sql bolck
I hve a PL SQL block in unix where i define a variable "var_px_cat" and use it for taking count
SELECT COUNT(*) INTO var_px_cat
FROM A
WHERE B = '$CATEGORIE_ID';
Now how do I access the variable "var_px_cat" in unix after exiting from pl sql block.
10 More Discussions You Might Find Interesting
1. HP-UX
When I try to connect to databse from HP box using the following command
sqlplus <username>@<databasename>
I get this error message:
ksh: <database name> : not found
I can connect to the database outside the UNIX box using sqlplus though.
Looks like the problem is the way HP Unix is... (4 Replies)
Discussion started by: dtonse
4 Replies
2. Shell Programming and Scripting
Hi,
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Task:
Check if the network drive exists
Check... (0 Replies)
Discussion started by: sayydevara
0 Replies
3. UNIX for Advanced & Expert Users
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Discussion started by: bright_future
4 Replies
4. Programming
Hi,
I was trying to access Mysql Server sitting in Linux Box from MS-SQL through linked server concept. I am getting the error as :
"Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary... (0 Replies)
Discussion started by: DILEEP410
0 Replies
5. Shell Programming and Scripting
Hi,
Can anyone assist me on how to access a variable in a shell script from another script.
for ex,
Script-1
-------
#! /bin/sh
c=10
Where as, i would like to access the velue of variable c in another script 'Script-2'.
Thankyou to all in advance !! :b:
:b: (2 Replies)
Discussion started by: little_wonder
2 Replies
6. Shell Programming and Scripting
HI all,
How can i access a variable that is
defined in another file as: $$Name= "abhinav;
in my script.
The catch is that it has 2 $s behind it...
Thnaks
---------- Post updated at 10:36 AM ---------- Previous update was at 10:29 AM ----------
the file from which i have to... (0 Replies)
Discussion started by: abhinav192
0 Replies
7. Shell Programming and Scripting
Hi,
Would like to know the purpose and accessing of local variable as in below code snippet:
a=123
( a=321; )
echo "a = $a" #This will print 123
How to access local a variable which is assigned with value 321 ?. .. (3 Replies)
Discussion started by: IND123
3 Replies
8. Shell Programming and Scripting
Hi all,
Here is an outline of the problem:
#variable declared at start of script
x=0;
#a function that increments x by 1 every 10 seconds
incrementX(){
increments x every 10 seconds;
}
#i want this to output the value of x every second. The problem is that x is always reported... (3 Replies)
Discussion started by: free2rhyme2k
3 Replies
9. Shell Programming and Scripting
Hi
I was trying to understand what ':-' means when used with variables
echo ${x:-10}
if
Thanks (4 Replies)
Discussion started by: zulfi123786
4 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT REDHAT
select_into
SELECT
INTO(7) SQL Commands SELECT INTO(7)
NAME
SELECT INTO - create a new table from the results of a query
SYNOPSIS
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ AS output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start ]
[ FOR UPDATE [ OF tablename [, ...] ] ]
INPUTS
TEMPORARY
TEMP If specified, the table is created as a temporary table. Refer to CREATE TABLE [create_table(7)] for details.
new_table
The name (optionally schema-qualified) of the table to be created.
All other inputs are described in detail for SELECT [select(7)].
OUTPUTS
Refer to CREATE TABLE [create_table(7)] and SELECT [select(7)] for a summary of possible output messages.
DESCRIPTION
SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.
Note: CREATE TABLE AS [create_table_as(7)] is functionally equivalent to SELECT INTO. CREATE TABLE AS is the recommended syntax,
since SELECT INTO is not standard. In fact, this form of SELECT INTO is not available in PL/pgSQL or ecpg(1), because they interpret
the INTO clause differently.
COMPATIBILITY
SQL92 uses SELECT ... INTO to represent selecting values into scalar variables of a host program, rather than creating a new table. This
indeed is the usage found in PL/pgSQL and ecpg(1). The PostgreSQL usage of SELECT INTO to represent table creation is historical. It's
best to use CREATE TABLE AS for this purpose in new code. (CREATE TABLE AS isn't standard either, but it's less likely to cause confu-
sion.)
SQL - Language Statements 2002-11-22 SELECT INTO(7)