HomeОбразованиеRelated VideosMore From: Tutorials Point (India) Pvt. Ltd.

Oracle - SQL - Alter Table

115 ratings | 28127 views
Oracle - SQL - Alter Table Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Html code for embedding videos on your blog
Text Comments (11)
Ashu Shaikh (1 month ago)
How to rename the column? you didnt discuss
Labhansh Gupta (5 months ago)
Sir How can someone know what all columns have been put as " Set Unused" ?
Abhesh Kumar (6 months ago)
how to add col before and after thats like i want to add col after emp_id , so how to add.
Nuruzzaman Bablu (6 months ago)
ERROR at line 1: ORA-12988: cannot drop column from table owned by SYS. now what can i do..???
Dipika sethi (7 months ago)
When I tried to drop salary column it's saying" cannot drop column from table owned by sys". Please suggest do I have to create another user other than sys so that I can perform this drop command.
krishnaveni dunnuthala (1 month ago)
Yes...even I have the same ....wt to do??
Freedomq Clan (8 months ago)
Waiting for you response
Freedomq Clan (8 months ago)
SQL)Alter table employees drop column salary; *Not working* Error: cannot drop column from table owned by SYS
Robert Smith (7 months ago)
The solution is to NOT create the table in the first place as user SYS. Create a new user to do all the steps above that is not SYS. This will solve all your problems. Here are the steps to create a new user: 1. Create a user: CREATE USER <username> IDENTIFIED BY <password> ; 2. Grant connect access to this user: GRANT CONNECT TO <username>; 3. Grant default access to user: GRANT RESOURCE TO <username>; 4. Now you can do an EXIT to logoff as SYS, then logon with the new user created, create the tables and perform the alters, drops, etc with no problems.
Savita A Meti (8 months ago)
Video is not clear after Alter add topic
Sayanthan Mahendran (1 year ago)
How to retrieve an unused column?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.