Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle Data Type for Memo Fields 1

Status
Not open for further replies.
Michael42

Michael42

Programmer
Oct 8, 2001
1,454
US
Hello I am an MS Access guy trying to learn Oracle 8. In creating a table what data type should I use for Memo type fields (as used in MS Access etc.).

Thanks,

Michael
 
Sort by date Sort by votes
It depends on how large you want the memo to be. Up to 4000 bytes - VARCHAR2; otherwise, try a CLOB (up to 4G, but a little more work to deal with).
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
232
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
258
Andrzejek
Andrzejek
gc6294
  • Locked
  • Question
Search for a character in Oracle SQL statement 1
Replies
3
Views
189
Andrzejek
Andrzejek
LarrySteele
  • Locked
  • Question
Searching multiple fields for any/all words from a search string.
Replies
2
Views
195
LarrySteele
LarrySteele
rk68
  • Locked
  • Question
inserting multi lingual data
Replies
0
Views
136
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top