Re:query suggest
771994May 24 2010 — edited May 24 2010Hi, iam using oracle 10g The version details is
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
See ,
The table name is 'gnum'
select * From gnum;
ID COMP_NAME EMAIL ID URL ZIP SSS
1 INET Portals Software sales1@inetportals.com http://www.inetportals.com/contact.cfm - -
2 NExTT Solutions sales@NexttSolutions.com http://www.nexttsolutions.com/contact.htm - -
There are 30000 records in table
See now i want to add some column in one page source script like this for all the records
website=http://www.nexttsolutions.com/contact.htm (url name)
name=nexttsolutions(comp_name)
align=top
height=800
width=100%
border=1
scroll=auto
</websiteFrame>
Pls suggest me the query?
Regards
Sandeep