Oracle Database for the Data Type of database fields, oracle Data Type

Source: Internet
Author: User

Oracle Database for the Data Type of database fields, oracle Data Type
Modify the Data Type of Oracle Data Columns

Method 1:


// Create the same temporary table

Create table T_BUSINESS_MODEL_TEMP as select * from T_BUSINESS_MODEL where 1 = 2;

// Change the data type of the temporary table

Alter table T_BUSINESS_MODEL_TEMP modify MODEL_MONEY NUMBER (10, 2 );

// Assign the original table data to the latest Table

Insert into T_BUSINESS_MODEL_TEMP select * from T_BUSINESS_MODEL;

// Delete the original table

Drop table T_BUSINESS_MODEL;

// Rename the temporary table as the original table

Alter table T_BUSINESS_MODEL_TEMP rename to T_BUSINESS_MODEL;

// Add constraints of the original table (primary key, foreign key, index)

Alter table T_BUSINESS_MODEL
Add constraint PK_T_BUSINESS_MODEL primary key (ID );

Method 2:

-- Rename a field
Alter table PROJECT rename column NAME to NAME1;


----- Change the field name to the original name.
Alter table PROJECT add NAME VARCHAR2 (300 );
--- Assignment
Update PROJECT np
Set np. name = np. name1;
Commit;
--- Delete the original renamed Field
Alter table PROJECT drop column NAME1;

I think method 2 is better!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.