Unix/Linux Go Back    


Web Programming Discuss Web Programming and Web Server Administration, including LAMP, Apache, MySQL, HTML, SEO, and other Web APIs and topics.

Display the contents of a table.

Web Programming


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 08-11-2009
gokulj gokulj is offline
Registered User
 
Join Date: Oct 2008
Last Activity: 8 September 2010, 11:27 AM EDT
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
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...........................
Sponsored Links
    #2  
Old Unix and Linux 08-18-2009
Neo's Unix or Linux Image
Neo Neo is online now Forum Staff  
Administrator
 
Join Date: Sep 2000
Last Activity: 21 October 2017, 6:03 AM EDT
Location: Asia pacific region
Posts: 13,774
Thanks: 892
Thanked 1,219 Times in 569 Posts
The table is a flat text file or in a database?
Sponsored Links
    #3  
Old Unix and Linux 10-06-2009
gokulj gokulj is offline
Registered User
 
Join Date: Oct 2008
Last Activity: 8 September 2010, 11:27 AM EDT
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
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 Unix and Linux 10-06-2009
radoulov's Unix or Linux Image
radoulov radoulov is offline
Registered User
 
Join Date: Jan 2007
Last Activity: 9 January 2017, 4:40 AM EST
Location: Варна, България / Milano, Italia
Posts: 5,690
Thanks: 184
Thanked 630 Times in 587 Posts
Quote:
Originally Posted by gokulj View Post
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?
Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to match all array contents and display all highest matched sentences in perl? vanitham Shell Programming and Scripting 5 06-18-2009 02:02 AM
Display the contents of an array RossMc UNIX for Dummies Questions & Answers 1 10-31-2008 01:25 PM
Unable to display correctly the contents of a file without a line feed Gato Shell Programming and Scripting 1 07-17-2008 04:23 PM
How to display contents of folder when 'cd' is used mumashankar UNIX for Dummies Questions & Answers 3 03-06-2008 06:42 PM



All times are GMT -4. The time now is 06:05 AM.