Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re:query suggest

771994May 24 2010 — edited May 24 2010
Hi, 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2010
Added on May 24 2010
2 comments
594 views