|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
oracle process query !
Post 302144314 by kpatel786 on Wednesday 7th of November 2007 10:13:59 AM
11-07-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Discussion started by: ashokjaysiv
4 Replies
2. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
3. Shell Programming and Scripting
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)
Discussion started by: balaeswari
6 Replies
4. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
5. Programming
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Discussion started by: SkySmart
3 Replies
6. Shell Programming and Scripting
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies
7. Shell Programming and Scripting
Hi,
I am new to perl.How to query oracle database with perl???
Thanks (1 Reply)
Discussion started by: tdev457
1 Replies
8. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
9. Programming
Dear community,
I have to make a query from a database and apply the following filter:
select filed1,field2,field3
from database
where (field1 contains only alphanumeric chars and NOT only numbers)
Let me explain better what I Need:
21test ==> OK
test ==> OK
test21 ==> OK
te21st ==>... (6 Replies)
Discussion started by: Lord Spectre
6 Replies
10. Programming
Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
FIELD1 FIELD2 FIELD3
========= ============== ... (3 Replies)
Discussion started by: Lord Spectre
3 Replies
LEARN ABOUT SUSE
udhcpd.conf
UDHCPD.CONF(5) GNU/Linux Administrator's Manual UDHCPD.CONF(5) NAME
udhcpd.conf - udhcp server configuration file DESCRIPTION
The file /etc/udhcpd.conf contains configuration information specific to the udhcp server. It should contain one configuration keyword per line, followed by appropriate configuration information. OPTIONS
start ADDRESS The starting address of the IP lease block is ADDRESS. The default is 192.168.0.20. end ADDRESS The ending address of the IP lease block is ADDRESS. The default is 192.168.0.254. interface INTERFACE The udhcp server should listen on INTERFACE. The default is eth0. max_leases LEASES Offer at most LEASES leases (including those reserved by OFFERs, DECLINEs, and ARP conflicts). The default is 254. remaining REMAINING If REMAINING is yes, store the time remaining for each lease. If it is no, store the expiration time for each lease. The default is yes. auto_time SECONDS Write the lease information to a file every SECONDS seconds. The default is 7200. decline_time SECONDS Reserve an IP for SECONDS seconds if a DHCP decline message is received. The default is 3600. conflict_time SECONDS Reserve an IP for SECONDS seconds if an ARP conflict occurs. The default is 3600. offer_time SECONDS Reserve an IP for SECONDS seconds if it is offered. The default is 60. min_lease SECONDS Reserve an IP for the full lease time if the lease to be given is less than SECONDS seconds. The default is 60. lease_file FILE Write the lease information to FILE. The default is /var/lib/misc/udhcpd.leases. pidfile FILE Write the process ID to FILE. The default is /var/run/udhcpd.pid. notify_file FILE Execute FILE after the lease information is written. By default, no file is executed. siaddr ADDRESS BOOTP specific option. The default is 0.0.0.0. sname NAME BOOTP specific option. There is no default. boot_file FILE BOOTP specific option. There is no default. option OPTION DHCP specific option. subnet ADDRESS timezone OFFSET router ADDRESS... timesvr ADDRESS... namesvr ADDRESS... dns ADDRESS... logsvr ADDRESS... cookiesvr ADDRESS... lprsvr ADDRESS... hostname HOSTNAME bootsize SIZE domain DOMAIN swapsvr ADDRESS rootpath PATH ipttl TTL mtu MTU broadcast ADDRESS ntpsrv ADDRESS... wins ADDRESS... requestip ADDRESS lease SECONDS dhcptype TYPE serverid ADDRESS tftp FILE bootfile FILE The default for lease is 864000. There are no defaults for the other options. SEE ALSO
udhcpd(8). GNU
/Linux 2001-09-26 UDHCPD.CONF(5)