Visit Our UNIX and Linux User Community


Display the contents of a table.


 
Thread Tools Search this Thread
Top Forums Web Development Display the contents of a table.
# 1  
Old 08-11-2009
Bug Display the contents of a table.

Dear Friends,

Am an newbie to this domain. I have a table which is filled with contents which i need to be updated with,so am trying to design a flow which would read the data from the table and mail it to me at regular intervals. I could make out the flow using mailx command but want to customize the appearance of data on my mail. Could someone kindly help me with the steps about how should i proceed??

Eg:

Data which i currently receive is as,

No of files---24
Processed---14
Failed--------10

I want the above data to be displayed neatly in a table.
Can i use html for this??? If so how to do it???


Plzzzzzzzzzzzzzzz help...........................
# 2  
Old 08-18-2009
The table is a flat text file or in a database?
# 3  
Old 10-06-2009
The data is in a oracle table.

---------- Post updated at 06:32 PM ---------- Previous update was at 06:31 PM ----------

Neo request you to help me ...
# 4  
Old 10-06-2009
Quote:
Originally Posted by gokulj
The data is in a oracle table.
[...]


Code:
printf '%s\n' "set markup html on" "select * from table_name;" |
  sqlplus -s user/pass[@service] |
    mailx -s ...


Is this the right forum for this question?
Or you want to do it from a web page/service?

Previous Thread | Next Thread
Test Your Knowledge in Computers #668
Difficulty: Medium
IEEE 802.11 is part of the IEEE 802 set of LAN protocols, and specifies the set of media access control (MAC) and physical layer (PHY) protocols for implementing virtual local area network (VLAN) Wi-Fi computer communication in various frequencies.
True or False?

10 More Discussions You Might Find Interesting

1. Web Development

How to create a link that will display the contents of a PHP variable?

Greetings, I've wrote a script that when you point your browser to a machine it displays info about itself. Below is a small snippet of the script: <?php $iloipaddr = `ipmitool lan print | grep 'IP Address ' | cut -d\: -f2 | sed 's/ //'`; $sftwrlist = `rpm -qa | sort`; ?> <p><a... (9 Replies)
Discussion started by: crimso
9 Replies

2. UNIX for Dummies Questions & Answers

HTML: Display contents of file using Variable

<tr><td bgcolor=#D7EBAD><b>Instructions :</b></td> <td>`cat temp.txt`</td></tr> Hi Experts, I have an requirement of displaying file contents in HTML mail , for which am using the above approach, Where as the output is kind of not as expected. If there are 5 lines in the file, in the... (4 Replies)
Discussion started by: scott_cog
4 Replies

3. Shell Programming and Scripting

Display array contents on a new line

ksh eg arrayname=(1 2 3 4 5) I'm trying to display the individual contents of an array on a new line without using a loop, using one line of code. output 1 2 3 4 5 (3 Replies)
Discussion started by: squrcles
3 Replies

4. Shell Programming and Scripting

Bash script to display result in table

My script gives the following result. Is it possible to display the same in table format ? 1. rex_best Latest feeds are not avaialable. The last feed was generated on 2012-05-17 File Name = ekb_best_20120517_010949_665.tar.gz The Number of entry elements = 4209539 2. rex_genre Latest... (2 Replies)
Discussion started by: kishorekumar87
2 Replies

5. Shell Programming and Scripting

Help with ksh script to display output with specific contents

This is Input - starts with Storage Group Name and ends with Shareable and the loop continues all I need is Storage group name and Alu numbers in the below output format requested. Storage Group Name: abcd Storage Group UID: 00:00:000:00:0:0:0 HBA/SP Pairs: HBA UID ... (6 Replies)
Discussion started by: maddysa
6 Replies

6. Programming

SIOCGARP to display the entire ARP table.

Hello everybody, I have a working code that displays an entry from a given IP address. but, how can i display the entire ARP table? like the option 'arp -a' of the standard linux program. This is the code:#include <stdio.h> #include <string.h> #include <stdlib.h> #include <netdb.h>... (4 Replies)
Discussion started by: semash!
4 Replies

7. Shell Programming and Scripting

Store table contents in csv file

I need to write a script to store the contents of a table in a csv file I'm using Toad, it's a Oracle database. (5 Replies)
Discussion started by: ladyAnne
5 Replies

8. UNIX for Advanced & Expert Users

acpi table contents

Can anyone please tell me what information is present in the acpi tables ? (4 Replies)
Discussion started by: vishwamitra
4 Replies

9. UNIX for Dummies Questions & Answers

Display the contents of an array

Hi i have just registered So i am at university studying forensic computing and we have to learn c++ i have never done anything with c++ before and i am abit stuck i need to create a programme to display the contents of an array of characters forwards and in reverse Can anyone help me... (1 Reply)
Discussion started by: RossMc
1 Replies

10. UNIX for Dummies Questions & Answers

How to display contents of folder when 'cd' is used

Hi, I am a new learner of Unix. I am currently working on a Solaris 8 machine. Earlier, when I use 'cd <folder name>' command, I am not only able to change the folder but also able to see the contents of the folder as if a 'ls -lt' command was executed. However, since a week, suddenly this... (3 Replies)
Discussion started by: mumashankar
3 Replies

Featured Tech Videos