OraFAQ Forum: SQL & PL/SQL » Store and Display website Link using plsql

Home » SQL & PL/SQL » SQL & PL/SQL » Store and Display website Link using plsql (Oracle 10.1.0.2.0 Hp-UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Store and Display website Link using plsql [message #418099]

Wed, 12 August 2009 23:22

vinniora
Messages: 56
Registered: October 2008
Location: Mumbai

Member

Hi all, I want to know that how can i store and display a website link in a table and also display the same link using pl-sql.Thanx in advance

Report message to a moderator

Re: Store and Display website Link using plsql [message #418103 is a reply to message #418099]

Wed, 12 August 2009 23:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I want to know that how can i store and display a website link in a table and also display the same link using pl-sql.Thanx in advance

use a VARCHAR2(4095) variable

Report message to a moderator

Re: Store and Display website Link using plsql [message #418106 is a reply to message #418099]

Wed, 12 August 2009 23:34

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

Please explain fully what you want to achieve.
To store links you can use VARCHAR2 type.
And to display those links you can use SELECT. PL/SQL not required.

regards,
Delna

Report message to a moderator

Re: Store and Display website Link using plsql [message #418132 is a reply to message #418106]

Thu, 13 August 2009 02:06

vinniora
Messages: 56
Registered: October 2008
Location: Mumbai

Member

thank you for response but actually i want that when i clicked the link the respective page should open using sql or plsql say for eg
if i just select the link oracle will treat it as varchar type but i want it to be link which can call the respective page
say www.xyz.com then it should open.

[Updated on: Thu, 13 August 2009 02:07]

Report message to a moderator

Re: Store and Display website Link using plsql [message #418137 is a reply to message #418132]

Thu, 13 August 2009 02:31

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Making the data display as a clickable link is entirely up to the client software that you use - it's nothing to do with the database.

Report message to a moderator

Previous Topic:	do i need to pass values in single quotes in IN clause while passing to procedure
Next Topic:	avg function on a date field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 16:48:27 CST 2024