12-15-2008
Check the record count in table (table in oracle)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch file once table count is zero.
I need script for above scenario and i am poor in UNIX.
Please try to help me, please send full-length script.
Please mail: .....@gmail.com
Thanks&Regards,
Ashok
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies
2. Shell Programming and Scripting
Suppose there is a table like the following...I just wanted to know if there is any command using which we can get the record/name of the person who joined before 2005..
Sl Name des y.o.joining
1 Ram Engineer 2001
2 Hari Doctor 2004
3 David Plumber 2005
4 Rahim painter 2007
5 gurmeet... (1 Reply)
Discussion started by: satyajit007
1 Replies
3. Shell Programming and Scripting
I need to write a unix shell script to connect to oracle database and retrieve data from a table, the script should count the total number of rows till date in that table
number of rows which are getting filled per hour on current day and the peak hour of the current day
number of rows which are... (5 Replies)
Discussion started by: PhAnT0M
5 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information.
More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies
5. UNIX and Linux Applications
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
6. UNIX for Advanced & Expert Users
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}"
] && echo... (1 Reply)
Discussion started by: ankit.mca.aaidu
1 Replies
7. Shell Programming and Scripting
I am trying to write a script which allows a user to select the what manipulation he needs to do on a table. I want to check if the table exists or not. If it exists I will continue the other things or else I exit saying table doesn't exist. How might I achieve this. (1 Reply)
Discussion started by: gmatcat
1 Replies
8. UNIX and Linux Applications
Hello All,
I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.
I'm setting below options :
SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
9. Web Development
Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer:
<script>
$(function(){
$('tr, td, fieldset,... (0 Replies)
Discussion started by: Neo
0 Replies
LEARN ABOUT HPUX
elf64_getphdr
elf_getphdr(3E) elf_getphdr(3E)
NAME
elf32_getphdr, elf32_newphdr, elf64_getphdr, elf64_newphdr - retrieve class-dependent program header table for elf32 and elf64 files,
respectively
SYNOPSIS
[flag... ] file... [library] ...
DESCRIPTION
For a 32-bit class file, returns a pointer to the program execution header table, if one is available for the ELF descriptor elf.
allocates a new table with count entries, regardless of whether one existed previously, and sets the bit for the table (see elf_flag(3E)).
Specifying a zero count deletes an existing table. Note this behavior differs from that of (see elf_getehdr(3E)), allowing a program to
replace or delete the program header table, changing its size if necessary.
If no program header table exists, the file is not a 32-bit class file, an error occurs, or elf is null, both functions return a null
pointer. Additionally, returns a null pointer if count is zero.
The table is an array of structures, each of which includes the following members.
The ELF header's member tells how many entries the program header table has (see elf_getehdr(3E)). A program may inspect this value to
determine the size of an existing table; automatically sets the member's value to count. If the program is building a new file, it is
responsible for creating the file's ELF header before creating the program header table.
For a 64-bit class file, returns a pointer to the program execution header table, if one is available for the ELF descriptor elf.
allocates a new table with count entries, regardless of whether one existed previously, and sets the bit for the table (see Specifying a
zero count deletes an existing table. Note this behavior differs from that of (see elf_getehdr(3E)), allowing a program to replace or
delete the program header table, changing its size if necessary.
If no program header table exists, the file is not a 64-bit class file, an error occurs, or elf is null, both functions return a null
pointer. Additionally, returns a null pointer if count is zero.
The table is an array of structures, each of which includes the following members.
The ELF header's e_phnum member tells how many entries the program header table has (see elf_getehdr(3E)). A program may inspect this
value to determine the size of an existing table; automatically sets the member's value to count. If the program is building a new file,
it is responsible for creating the file's ELF header before creating the program header table.
SEE ALSO
elf(3E), elf_begin(3E), elf_flag(3E), elf_getehdr(3E).
elf_getphdr(3E)