Home » SQL & PL/SQL » SQL & PL/SQL » sql DataType (oracle 10g)
sql DataType [message #309563] Thu, 27 March 2008 22:12 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
Kindly advise.
Declare
v_var_field varchar2(32767);
Begin
v_var_field:='select * from air_book_ticket';
End;

The length of "v_var_field" IS 30 only.Now how much bytes will oracle allocate for this variable.
Re: sql DataType [message #309569 is a reply to message #309563] Thu, 27 March 2008 23:12 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96624/03_types.htm

regards,
Re: sql DataType [message #309593 is a reply to message #309563] Fri, 28 March 2008 01:39 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The number of bytes necessary to hold the data.

Regards
Michel
Previous Topic: Pick records from different group.
Next Topic: Mutating trigger error
Goto Forum:
  


Current Time: Mon Dec 05 12:45:47 CST 2016

Total time taken to generate the page: 0.14112 seconds