Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic variable length (oracle, 9.2.0.8. unix)
Dynamic variable length [message #282504] Thu, 22 November 2007 03:35 Go to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Hi,

Can we create variable length dynamically?

Let say I have one table person which having last_name and first_name field.

Last_first varchar2(last_name.lenght+first_name.lenght+1) some thing like that.

Is it possible.

Thanks,
Sagar
Re: Dynamic variable length [message #282506 is a reply to message #282504] Thu, 22 November 2007 03:38 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

no.what's the requirement?


regards,
Re: Dynamic variable length [message #282508 is a reply to message #282504] Thu, 22 November 2007 03:39 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do that.
Create your variable wide enough (VARCHAR2(32567)) then you don't have any problem. As its name tells, it is a varying length string.

Regards
Michel
Previous Topic: How to get all created indeces that belongs to a special table
Next Topic: Old Oracle standard and ANSI standard help
Goto Forum:
  


Current Time: Sun Dec 04 18:55:01 CST 2016

Total time taken to generate the page: 0.04455 seconds