| |

VerySource

 Forgot password?
 Register
Search
View: 13|Reply: 3

One of my fields in the data table was originally of type varchar2 and now I want to change it to Blob, why ca n’t I c

[Copy link]

2

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-3-21 12:30:02
| Show all posts |Read mode
One of my fields in the data table was originally of type varchar2 and now I want to change it to Blob, why ca n’t I change it?
How to deal with the content of a field with a length exceeding 4000? How should I read it?
Reply

Use magic Report

0

Threads

68

Posts

47

Credits

Newbie

Rank: 1

Credits
47

 China

Post time: 2020-6-27 20:30:01
| Show all posts
The type of varchar2 should be changed to Blob now?
clob
Reply

Use magic Report

2

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

 Author| Post time: 2020-7-10 20:15:01
| Show all posts
How to store and read blob?
Reply

Use magic Report

1

Threads

7

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-7-14 10:15:01
| Show all posts
Blob is a lob (large object) data type, used to store large, unstructured data, such as binary files, picture files and other types of external files; lob type data can be stored directly within the data, also Can be stored in an external file. It will only point to the data locator. So you can not change the varchar2 (20) type to blob or clob type
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list