tag:blogger.com,1999:blog-5237676719536842801.post8833034011790680086..comments2024-03-29T16:09:11.174+04:00Comments on Dive in Oracle: ANYDATA in Oracle DatabaseMahmoud A. Elsayedhttp://www.blogger.com/profile/11349719211814162336noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5237676719536842801.post-83133345879818064142012-07-18T08:16:27.210+04:002012-07-18T08:16:27.210+04:00you can use varchar2 to store for text and number ...you can use varchar2 to store for text and number and date, But it has a lot of drawbacks<br />1- How to distinguish datatype of stored data ( text or number or date)<br />2- You should convert stored data to its original type to use it.<br />3- How can store collection and object types in varchar2, However in ANYDATA you can do it by sys.anydata.convertcollection, sys.anydata.convertobjectMahmoud A. Elsayedhttps://www.blogger.com/profile/11349719211814162336noreply@blogger.comtag:blogger.com,1999:blog-5237676719536842801.post-44087956440255075192012-07-17T16:52:08.524+04:002012-07-17T16:52:08.524+04:00Thanks brother nice work. what is the difference i...Thanks brother nice work. what is the difference if I use varchar2 column and insert number, date and char in that column and I can retrieve all data from varchar2 data type column.Khalid Mehmoodhttps://www.blogger.com/profile/00685498566603129438noreply@blogger.comtag:blogger.com,1999:blog-5237676719536842801.post-78611282423382392542012-04-10T17:42:38.818+04:002012-04-10T17:42:38.818+04:00goog work thanksgoog work thanksAnonymousnoreply@blogger.com