Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX Script required for count the records in table
Top Forums Shell Programming and Scripting UNIX Script required for count the records in table Post 302900779 by victory on Thursday 8th of May 2014 03:37:00 PM
Old 05-08-2014
I have written below script plz check it and correct it if any.

Code:
#!/bin/sh
count=`sqlplus $username/$password@$tnsname << EOF
select count(*) from table;
exit;
EOF`
if [ $count = 0 ]
then 
exit 1
fi
mailx -s " record count " abc@xyz.com < $count
exit 0

Last edited by Don Cragun; 05-08-2014 at 04:51 PM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Count No of Records in File without counting Header and Trailer Records

I have a flat file and need to count no of records in the file less the header and the trailer record. I would appreciate any and all asistance Thanks Hadi Lalani (2 Replies)
Discussion started by: guiguy
2 Replies

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

3. Shell Programming and Scripting

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... (1 Reply)
Discussion started by: kamineni
1 Replies

4. Shell Programming and Scripting

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 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

5. Shell Programming and Scripting

count and compare no of records in bash shell script.

consider this as a csv file. H,0002,0002,20100218,17.25,P,barani D,1,2,3,4,5,6,7,8,9,10,11 D,1,2,3,4,5,6,7,8,9,10,11 D,1,2,3,4,5,6,7,8,9,10,11 D,1,2,3,4,5,6,7,8,9,10,11 D,1,2,3,4,5,6,7,8,9,10,11 T,5 N i want to read the csv file and count the number of rows that start with D and... (11 Replies)
Discussion started by: barani75
11 Replies

6. Shell Programming and Scripting

Script to count particular type of records

Hi, I have a huge file containing thousands of records which are of following pattern: TYPE1 { originNodeType : "IVR" originHostName : "AAIVR" originTransactionID : "01310559" originTimeStamp : "20110620192440+0530" hostName : "hhhh" voucher : '0'D rProfileID : "ZZZZ" Before {... (5 Replies)
Discussion started by: madhukar1anand
5 Replies

7. Shell Programming and Scripting

Script to count the dataflow in a table in oracle database

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

8. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the... (18 Replies)
Discussion started by: chetanojha
18 Replies

9. Shell Programming and Scripting

Help Needed: UNIX shell variables to store Oracle table records

Hello Folks, I'm working on a requirement to automate the process of generating report(csv file) using metadata info stored in an Oracle table and E-mail it to respective people. Meta data table: Report_ID,Report_SUB_ID,Report_DB,Report_SQL,Report_to_email_Id 1,1,DEV,'select * From... (2 Replies)
Discussion started by: venkat_reddy
2 Replies

10. Shell Programming and Scripting

Python Script to take file count and insert into DB2 table

Team I have files in different directories . How can i take the count of latest file and insert into Db2 table . I am using awk 'END{print NR+1-ARGC}' (File name) to get the counts. How can i take 1.The count of latest file 2.Insert into Db2 table( File Name and Counts) . cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies

LEARN ABOUT DEBIAN

tcrtest

TCRTEST(1)							   Tokyo Tyrant 							TCRTEST(1)

NAME

       tcrtest - test cases of the remote database API

DESCRIPTION

       The command `tcrtest' is a utility for facility test and performance test.  This command is used in the following format.  `host' specifies
       the host name of the server.  `rnum' specifies the number of iterations.

	      tcrtest write [-port num] [-cnum num] [-tout num] [-nr] [-rnd] host rnum
		     Store records with keys of 8 bytes.  They change as `00000001', `00000002'...
	      tcrtest read [-port num] [-cnum num] [-tout num] [-mul num] [-rnd] host
		     Retrieve all records of the database above.
	      tcrtest remove [-port num] [-cnum num] [-tout num] [-rnd] host
		     Remove all records of the database above.
	      tcrtest rcat [-port num] [-cnum num] [-tout num] [-shl num] [-dai|-dad] [-ext name] [-xlr|-xlg] host rnum
		     Store records with partway duplicated keys using concatenate mode.
	      tcrtest misc [-port num] [-cnum num] [-tout num] host rnum
		     Perform miscellaneous test of various operations.
	      tcrtest wicked [-port num] [-cnum num] [-tout num] host rnum
		     Perform updating operations of list and map selected at random.
	      tcrtest table [-port num] [-cnum num] [-tout num] [-exp num] host rnum
		     Perform miscellaneous test of the table extension.

       Options feature the following.

	      -port num : specify the port number.
	      -cnum num : specify the number of connections.
	      -tout num : specify the timeout of each session in seconds.
	      -nr : use the function `tcrdbputnr' instead of `tcrdbput'.
	      -rnd : select keys at random.
	      -mul num : specify the number of records for the mget command.
	      -shl num : use `tcrdbputshl' and specify the width.
	      -dai : use `tcrdbaddint' instead of `tcrdbputcat'.
	      -dad : use `tcrdbadddouble' instead of `tcrdbputcat'.
	      -ext name : call a script language extension function.
	      -xlr : perform record locking.
	      -xlg : perform global locking.
	      -exp num : specify the lifetime of expiration test.

       If the port number is not more than 0, UNIX domain socket is used and the path of the socket file is specified by the host parameter.  This
       command returns 0 on success, another on failure.

SEE ALSO

       ttserver(1), ttultest(1), ttulmgr(1), tcrmttest(1), tcrmgr(1), ttutil(3), tcrdb(3)

Man Page							    2010-01-20								TCRTEST(1)
All times are GMT -4. The time now is 04:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy