Home » SQL & PL/SQL » SQL & PL/SQL » Store and Display website Link using plsql (Oracle 10.1.0.2.0 Hp-UX)
Store and Display website Link using plsql [message #418099] Wed, 12 August 2009 23:22 Go to next message
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
Re: Store and Display website Link using plsql [message #418103 is a reply to message #418099] Wed, 12 August 2009 23:27 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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
Re: Store and Display website Link using plsql [message #418106 is a reply to message #418099] Wed, 12 August 2009 23:34 Go to previous messageGo to next message
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
Re: Store and Display website Link using plsql [message #418132 is a reply to message #418106] Thu, 13 August 2009 02:06 Go to previous messageGo to next message
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 Go to previous message
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.
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:
  


Current Time: Sat Dec 10 04:58:57 CST 2016

Total time taken to generate the page: 0.25120 seconds