SQL & PL/SQL :: Sending Table Data In HTML Format

Jul 11, 2008

I need to send data (mail it ) which is stored in my Oracle Database through PL/SQL in HTML table format.

1. how to do it?
2. If YES, throw some light on it ?

View 12 Replies


ADVERTISEMENT

SQL & PL/SQL :: Mail Sending In DAT Format Instead Of HTML?

Oct 14, 2010

I have learned procedure to send email with html attachment using UTL_SMTP protocol. But I could see the mailed attachment shows .Dat format. I need the attachment should go in .Html format.

find the below code which i am using:

CREATE OR REPLACE PROCEDURE send_email(
pi_from in Varchar,
pi_to in VARCHAR,
pi_subj in VARCHAR,
pi_msg CLOB
)

[code].....

View 2 Replies View Related

SQL & PL/SQL :: Convert A HTML To PDF Format Using Oracle 9i?

May 30, 2011

convert a HTML to PDF format using plsql using oracle 9i.

View 9 Replies View Related

JDeveloper, Java & XML :: Data To HTML Table With Tag

Jul 10, 2012

I've generated XML from oracle:

select dbms_xmlquery.getxml('select * from tbl_nm') from dual
<?xml version="1.0" encoding="ISO-8859-1"?>
<ROWSET>
<ROW num="1">
<NAME>admin</NAME>
<PASSWORD>a</PASSWORD>

[code]....

i tried to get this xml data in html table but the table was not displayed. When I changed the <ROW> tag into any other tag say <CD> the table was displayed.

View 10 Replies View Related

SQL & PL/SQL :: Send Mail As HTML Format In Oracle?

Mar 23, 2012

I want to send the mail as HTML format in oracle.

The email message column is in clob datatype .

if i click the column it shows the text output(various tags ,symbols)

if i click the HTML it shows the correct format .,

i m sending the mail using that message column .,the mail Received with the text format ,actually i need it in the html format., How to send HTML output?

View 4 Replies View Related

SQL & PL/SQL :: How To Send Email In HTML Format By Executing Anonymous Procedure

Oct 11, 2010

How to send email in HTML format as an attachment/email body by executing oracle anonymous procedure

View 1 Replies View Related

Application Express :: Where To Add HTML Format For Phone No So It Dials On Touch In List View

Sep 12, 2013

In Apex 4.2 Jquery mobile list view how can you apply html format for the phone# field to make it dial with a touch.  For example, I see how to do a list view of the 'DEMO_CUSTOMER' sample data, but I cannot figure out how to format the phone # fields so that they will dial on touch.  I know the HTML tags to use and I know how to use it in a standard report, but I can't figure out list view. 

View 3 Replies View Related

SQL & PL/SQL :: Format Table Data

Jul 4, 2013

I have data in bellow format...

NAMEPROMPT CHARACTER1 CHARACTER2 CHARACTER3

MOAAPPROVER15100160 5100165 MUNGAI
MOAAPPROVER25100160 5100165 MUNGAI
MOAFINAL APPROVER5100160 5100165 MUNGAI

so all values which are in CHARACTER1 column belongs to APPROVER1,CHARACTER2 belongs to APPROVER2,and CHARACTER3 belongs to FINAL APPROVER.

Now i want to display records in bellow format

NAMEPROMPT CHARACTER1 CHARACTER2 CHARACTER3
MOAAPPROVER1 5100160 5100160 5100160
MOAAPPROVER2 5100165 5100165 5100165
MOAFINAL APPROVER MUNGAI MUNGAI MUNGAI

View 6 Replies View Related

XML DB :: Generating XML Data From A Table In XML Format

May 3, 2013

generating an xml file using the below data.Table name is T_Data having 4 columns as given below with some data.

Region Divison District Store
---------- ----------------------- ----------- -----------
Northwest Northern California San Jose SJStore1
Northwest Northern California San Jose SJStore2
Northwest Northern California North LA LAStore1
Northwest Northern California North LA LAStore2
Northwest Northern California North LA LAStore3

I want to generate an XML File using SQL/XML Functions and the XML File should look like as given below.

<Region>
<Region Name>Northwest</Region Name>
<Divison>
<Division Name> Northern California </Division Name>
<District>
[code]...

View 3 Replies View Related

SQL & PL/SQL :: Converting HTML Format Text To Plain Text?

Dec 23, 2009

Is there any way to convert HTML format text to Plain Text ?

View 26 Replies View Related

SQL & PL/SQL :: How To Get Data From A Table In Date And Time Format

Jul 24, 2013

how to get data from a Table in Date and Time format? Curently I'm using To_TIMESTAMP for a date range.

Here is the code Snippet -

Select *
FROM TABLE_Name
WHERE COUNTRY= 'IN'
AND CALC_DATETIME between TO_TIMESTAMP('2013/06/05', 'YYYY/MM/DD HH:MI:SS') AND TO_DATE ('2013/07/08', 'YYYY/MM/DD HH:MI:SS')

View 39 Replies View Related

SQL & PL/SQL :: Output Data Format From Input Table?

May 18, 2011

how can i get the output format from given input table

View 2 Replies View Related

PL/SQL :: How To Do A Loop On Table And Export Data In Excel Format

Dec 13, 2012

i need to do a loop on a table and export the data in Excel format (so i need a procedure to do it).

write a java class that build this Excel.. oracle procedure loop around the data and every step my Java class write on Excel file.

So, for this i should initialize my java class for example

public class ExcelExporter{
private String fileName;
public ExcelExporter(String fileName){
this.fileName = fileName;
}
}

So, for this issuse i should call the ExcelExporter costructor from my PL/SQL so i can create an object of it and next i use this to populate my Excel.

How its possible to create Java object from PLSQL ? I've seen on the net all procedure call only Java static methods...

View 5 Replies View Related

SQL & PL/SQL :: From Html To Xml And Insert To Table?

Oct 13, 2010

I basically get it how to insert selected records from html to table by converting into the xml format [URL] (Barbara and Michel know what Im talking about).

But now I cant get the hang of convert one html site where are a very usefull information for my job.

Its about the site[URL]

where I need to get informations about phone specs and insert into the table.
Informations begin with" rozmery telefónu106 x 48 x 16 mm"
and ends "podpora WCSS".

However I try to figure it out always I gonna get some ORA errors.

View 10 Replies View Related

Oracle Response Time In A HTML Table

Apr 24, 2013

How do you Display Response time in HTML? I want to run a PHP script that displays the oracle response time in an HTML table.

View 1 Replies View Related

PIVOT XML Results To HTML Table In SQLPlus?

Jul 27, 2012

I have a PIVOT XML query that returns results that I want to display as an HTML report from SQLPlus. Is there a way that this can be done readily? I have searched the net an found references to XML Publisher but in my current situation we do not have the product available.

View 4 Replies View Related

Retrieving Info From Database And List Out In HTML Table?

Feb 21, 2011

I am having a little trouble retrieving info from my mock database.

here are my definitions:
response.setHeader("pragma", "no-cache");
response.setHeader("Cache-control", "no-cache, no-store, must-revalidate");
response.setHeader("Expires", "01 Apr 1995 01:10:10 GMT");
response.addHeader("Cache-Control", "post-check=0, pre-check=0");

[code]...

and here is my select statement.
ds = (DataSource) context.lookup(dSource);
conn = ds.getConnection();
stmt = conn.prepareStatement("select add_date, campus, name, leader from TABLENAME where id = ? order by xbbo_add_date");
stmt.setString(1, colleagueID);
result = stmt.executeQuery();

***basically I am trying to retrieve this info from my db, and list it out in a HTML table. I am writing this on a JSP page. Also, where i want the retrieved data listed, I am using for ex: <%=name%>

View 5 Replies View Related

SQL & PL/SQL :: HTML Source Code Inserted Into Table As CLOB

Sep 24, 2010

I got html source code inserted into the table as CLOB (or BLOB). And I would like to search a some word from that.When I find a some value I can write this one into the column.It would be easy if this code is xml but isnt.

View 12 Replies View Related

JDeveloper, Java & XML :: Get Some Mobile Specs From Html Page Into Table?

Jan 31, 2012

I need to get some mobile specs from html page into table.

First of all its needed to get html pieces from main url and put page into clob (see below).

When I do this I get an errors:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1819
ORA-01482: unsupported character set
ORA-06512: at line 10

[Code].....

View 3 Replies View Related

Application Express :: Display Page Item Values In HTML Table

Sep 7, 2012

I would like to have a table in HTML region and to display in the table some Page Items from the page.

I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}

It shows the Page Item names as text, not the values. However this code without the table tags:

{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}

works and the Page Item values are displayed.

Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.

what kind of region is the best to be used or if I should only use some escape symbols in the table code.

View 2 Replies View Related

Application Express :: Image Stored In Table Is Not Showing In HTML Or Report Region

Aug 22, 2012

I am using apex 4.1 and database as oracle 11g. I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> (     "ID" NUMBER,
>>     "HR_ID" NUMBER NOT NULL ENABLE,
>>     "PHOTO_BLOB" BLOB,
>>     "MIME_TYPE" VARCHAR2(64),
>>     PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

[URL].......

[URL]........

But the image is not getting populated in the region, I tried with display_item with image i am able to view the image using this item.

View 19 Replies View Related

SQL & PL/SQL :: Display Data In Grouping Format

Oct 13, 2010

I have a query on displaying data as per my requirement. I have created a table called sales it has four columns

create table sales(country,state,district,sales);
and am inserting some same data

insert into sales('india','TN','Chennai',100);
insert into sales('india','TN','KPURAM',120);
insert into sales('india','TN','Bangalore',35);
insert into sales('india','ANDR','Guinder',100);
insert into sales('india','ANDR','Nellai',76);
insert into sales('london','city-a','xstreet',89);
insert into sales('london','city-a','binroad',100);

select * from sales;

country state district sales
india TN chennai 100
india TN KPURAM 120
india TN Bangalore 35
india ANDR Guinder 100
india ANDR Nellai 76
london city-a xstreet 89
london city-a binroad 100

the data is displayed in this format. How i am trying to display data.

View 5 Replies View Related

SQL & PL/SQL :: How To Change Column Data In Row Format

Jun 1, 2012

I want to get the following format of data in row format using PLSQL. I want to do that in using a shell script also.

Suppose I have the data like this

123
45
2
789

how to write it in PLSQL as follows:
1427
25 8
3 9

View 3 Replies View Related

Reports & Discoverer :: Data To Be Taken In Different Format

Dec 2, 2012

I have one table storing all the information about employye, i have to develop three different reports based on the same table with different groupings , is there a easy way to call each format differently using single interface ,something like ref cursor.I dont want to create two or 3 different reports , instead choose the format.

CREATE TABLE OT_JOB_DET
(
JT_TXN VARCHAR2(12 BYTE),
JT_NO NUMBER,
JT_DT DATE,

[Code].....

View 4 Replies View Related

Forms :: How To Convert Data From 6i To PDF Format

Dec 26, 2011

is it possible convert data from forms 6i to pdf format?

View 4 Replies View Related

SQL & PL/SQL :: Print Data From A Clob In XML Format?

Sep 11, 2013

I want to print data from a clob in XML format and use the following

PROCEDURE printClobOut(result IN OUT NOCOPY CLOB) is
xmlstr varchar2(32767);
line varchar2(32767);
cnt NUMBER;

[Code]...

However the length of the clob is 13832630 which is too large for a VARCHAR2. Thus my output of line is cut off at 4000 characters. How can i increase this... Do i overlook something here in my code?

View 13 Replies View Related

SQL & PL/SQL :: To Display Data In Range Format

Apr 25, 2012

I have a table where multiple combination of records are store and i want to display data in range format as below, there is any way to group data as below.

create table ot_shop_Rec ( item varchar2(12), it_name varchar2(20),rev number, qty number)
drop table ot_shop_rec

insert into ot_shop_rec values ( '1018001-1001', 'COL',0,10);
insert into ot_shop_rec values ( '1018001-1002', 'COL',0,10);
insert into ot_shop_rec values ( '1018001-1001', 'GRID',0,10);
insert into ot_Shop_rec values ('1018001-1003','COL',0,10);

I WANT THE OUTPUT IN REPORT LIKE

ITEM RANGE DESC QTY REV

1018001-1001 - 1018001-1003 COL 30 0
1018001-1001 GRID 10 0

View 5 Replies View Related

SQL & PL/SQL :: Query To Get Data In Desired Format?

May 29, 2012

CREATE TABLE DATA1
(
ID NUMBER(6),
DAT_ID NUMBER(6),
RNK NUMBER(2)
);
Insert into DATA1
(ID, DAT_ID, RNK)

[code]....

now after having this data from "data1" table , we need to get the row from "data2" table.in "data2" table there are total 6 combination on basis of "POS,ORDER" [ there are only 2 "ORDER" i.e. 'F' and 'S' , where as POS value can be changed, BUT THE "POS,ORDER" COMBINATION WILL HAVE ONLY 6 UNIQUE COMBINATION. ] so, for "POS and DAT_ID" combination we need to get the lowest rank data first, if that is not present then get the other rank given in "DATA1" table and so on and if no rank is present then select the NULL row row data from "DATA2" table for ex: in DATA1 table for count(*)>1 and id=1, we have data as

--------------
IDDAT_IDRNK

11231
11242
11253
--------------

so, in "DATA2" table, first we will see for "POS and ORDR" combination which DAT_ID is present, i.e. in case od POS=11 and ordr=F, we will select

111231FD1

as it is having lowest rank in "DATA1" table and it is present in "DATA2" table,

for POS=12 and ordr=F, we will select

121242FD1

as we don't have "123 and 1" in "DATA2" table so we will select the next rank given in "DATA1" ( i.e. 124 and 2 ), similarly , for POs=31 and ordr=S, we will select, as this is the next available rank and DAT_ID present in "DATA2" table

1D131S1253

and if there is no rank present from "DATA1" table in "DATA2" table then we will select the NULL row, i.e. for POS=21 and ordr=F, we need to select :

1D121F

"there will be 6 row for each id"

the output we want is :
-----------------------------------------
IDNAMEPOSORDER DAT_IDRNK
1D111F1231
1D112F1242
1D121F
1D12321S1231
1D2322S1242

[code]....

View 4 Replies View Related

Data In Date Format For In Time

Oct 26, 2006

i have data in date format for in time actually it should be 9:30 am and out time at 2:30 pm

SELECT MIN(IN_TIME) AS IN_TIME,MAX(OUT_TIME) AS OUT_TIME FROM EMP_ATND_DETAIL AS ET, EMP_ATND_INFO AS EAI
WHERE ET.EMP_ATND_INFO_ID=EAI.EMP_ATND_INFO_ID AND ATND_DATE = '2006-10-25' AND EMP_ID =24

+---------------------+---------------------+
| IN_TIME | OUT_TIME |
+---------------------+---------------------+
| 2006-10-20 09:30:00 | 2006-10-13 01:30:00 |
| 2006-10-24 02:30:00 | 2006-10-13 06:30:00 |
| 2006-10-24 09:30:00 | 2006-10-13 01:30:00 |
+---------------------+---------------------+

i have should get 9:30 am because that is lessser then 2:30 pm

do i have

SELECT name, emp_id,
min(to_char(IN_TIME, 'DD/MM/YY HH24:MI')) in_time,
max(to_char(OUT_TIME, 'DD/MM/YY HH24:MI')) out_time,
FROM EMP_ATND_DETAIL

View 3 Replies View Related

SQL & PL/SQL :: Extracted Data Is Displayed In Wrong Format

Feb 14, 2013

I use SQL to extract data from Quality Center (QC) to excel. I have a field type String. It contains the following values.

1) 1161, 1162, 1163
2) DHM, 162
3) DTH, 163
etc

But when i extract this to excel the data is displayed as
1) 116111621163
2) DHM, 162
3) DTH, 163

The value in the first row is displayed with out commas. How to extract the data as it is in the field?

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved