10 More Discussions You Might Find Interesting
1. Programming
HI Guys ,
Below are the two columns ITEMS and STATE of table .
ITEMS STATE
'2345','ggdh','k5tg','dgyt','hFF' DF
'1234','ghyt','DDD','GHTD','ABF' PQ
Can we get output in PL/SQL in below way ?... (7 Replies)
Discussion started by: Perlbaby
7 Replies
2. Programming
HI ,
Please guide to get the PL/SQL logic to retrieve parameter VALUES passed IN variable seperated with comma(,)
Say items =(MTH,WKL,DLY,QTR)
It should send above parameters seperatly USING LOOP condition IN the below IN clause
SELECT * FROM tb_data_storage
WHERE items IN... (4 Replies)
Discussion started by: Perlbaby
4 Replies
3. UNIX and Linux Applications
Hi,
Where do i post Oracle DB related questions??
I basically have 2 questions -
1. What is pmon and smon? Difference between them? If either or both process fail then how can we monitor them?
2. Is lsnrctl same as tnslsnr? if i want to check for listener status then how would i do... (2 Replies)
Discussion started by: Mr. Zer0
2 Replies
4. Shell Programming and Scripting
I want to use Perl to connect to a remote Oracle DB
I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server.
Is this possible?
I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies
5. Shell Programming and Scripting
Hello All,
I need to now how can I establish connection with oracle database then shutdown abort and then startup, In other words need to implement the following lines to perl script:
export ORACLE_SID=<some user>
${ORACLE_HOME}/bin/sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown... (2 Replies)
Discussion started by: Alalush
2 Replies
6. Shell Programming and Scripting
Dear Sir/Madam,
I use the following way to call the oracle stored procedure in a perl script, but I do not know how to call a oracle function by the following way ?
# ARGV is the oracle stored procedure name with parameters
$str = "sqlplus -s <<-eof \n" .
"$db_login... (0 Replies)
Discussion started by: ili
0 Replies
7. Shell Programming and Scripting
Hi
All,
I have issued ps -ef | grep oracle command and i got these result
oracle 356394 1 0 09:32:06 - 0:03 oracleCMS (LOCAL=NO)
Now I can see user from here but I can not from which machine they are running this process. How can I see that?
Thanks,
Vishal (5 Replies)
Discussion started by: vishalpatel03
5 Replies
8. Programming
hi i am trying to connect to an oracle database using dbi and i get this ::
Driver has not implemented the disconnect_all method. at /opt/perl/lib/site_perl/5.8.0/sun4-solaris/DBI.pm line 575
END failed--call queue aborted.
for all i know, the script was working earlier, but has... (1 Reply)
Discussion started by: poggendroff
1 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
I have a 2 questions; 1 is oracle and another is korn shell
say TIME=20060928
desired output: 20060927
say TIME=20061001
DESIRED output: 20060930
If i substract one day from 'TIME' i am looking for previous day.
can anyone please suggest me how do i do this is SQL.
i... (4 Replies)
Discussion started by: pavan_test
4 Replies
10. UNIX for Dummies Questions & Answers
Hi friends,
I am new to Perl programming. I have a requirement, using perl I need to connect to Oracle DB and get some records ( on unix environment). I googled and found that we need to use DBD (Database Drivers), DBI (DataBase Interface) to connect to oracle. I tried using " sqlplus... (1 Reply)
Discussion started by: satguyz
1 Replies