Oracle - SQL - Alter Table

[@TutorialsPoint_]

To Get Certification, Click Here: bit.ly/4537Uyk Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@Krishnakumar-fr5sw]

@tutorials point anadi bro you missed one point how to rename the column by using alter statement 😅 OK guys how to rename the column name by using alter statement it's simple just apply sql>alter table employess rename column col1 to newcol1; syntax is sql> alter table [table name] rename [existing column name ] to [new column name ]; guys apply this first and after apply the drop unused columns command

[@saikumarchowdada6309]

NICE

[@ahsanulmoyej4993]

Thanks brother for your nice tutorials, I faced a problem can not drop colunm in SYS user which is connect as sysdba.

[@dhaneshpt8641]

Thank you...

[@VadlakondaHasini412]

Sir, Which software should we use if the table data is huge?

[@Chinni1424]

Sir agar ushme koi value add karna ho to kaise karenge?

[@kaushikaa9033]

Thank u sir.

[@rahulchatterjee9910]

2:19 how did you automatically select desc employees command without even typing it fully?

[@sarthakgandhi7552]

down button press karo keyboard mai pata chal jayega

[@syedjawadshah79]

Hi, I'm unable to drop the column name "Salary". Please help!!

[@coolstuff7327]

Same Problem

[@mozi4712]

you have to connect to your own schema

[@sadiasadiaqamar9977]

Sir ager alter table ka table dakna chyeta ho to Kay kar Jasy simple table ma (desc or tablet name) write kerty Han to table show hota ga asy alter table ka liy kon si command day gay to table ay ga

[@Karai-x7r]

Can u telll me how to insert the table

[@sppatro9477]

What i have to do if i want to add Column by position....???? please help

[@asmashaikh2141]

How to rename the column? you didnt discuss

[@abheshkumar2232]

how to add col before and after thats like i want to add col after emp_id , so how to add.

[@Krishnakumar-fr5sw]

What about rename our column?

[@bablu8752]

Cannot drop column from table owned by sys

[@labhanshgupta6873]

Sir How can someone know what all columns have been put as " Set Unused" ?

[@bablu001100]

ERROR at line 1: ORA-12988: cannot drop column from table owned by SYS. now what can i do..???

[@manmeetjha5056]

Did you get any solution?

[@addybeez3277]

same bro;...

[@harshitamirase4663]

Write querry How to select domain in email address or service provider

[@sayanthanmahendran2777]

How to retrieve an unused column?

[@dips8921]

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.

[@krishnavenidunnuthala2748]

Yes...even I have the same ....wt to do??

[@feminist098]

@@krishnavenidunnuthala2748 oracle is death

[@syedjawadshah79]

I'm having same issue

[@savitaameti9155]

Video is not clear after Alter add topic

[@harshneema8961]

How can I find the workspace name in Oracle 11g

[@freedomqclan2528]

Waiting for you response

[@freedomqclan2528]

SQL)Alter table employees drop column salary; *Not working* Error: cannot drop column from table owned by SYS

[@robertsmith9474]

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 IDENTIFIED BY ; 2. Grant connect access to this user: GRANT CONNECT TO ; 3. Grant default access to user: GRANT RESOURCE TO ; 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.

[@Imrajeshsandhuvlogs]

desktop system date once cheack it.

[@lindavijayapriyagondhi5827]

@@robertsmith9474 thank you :)

[@thetruereality2]

@@robertsmith9474 Thank you very much, this helped a lot

[@addybeez3277]

@@robertsmith9474 bro the query u written for creating the new user , So from where we suppose to write ?,i mean sqlplus statement?

[@skabdulazeez1818]

Rename yedi bey .......

[@Tech-jf6pt]

*Nee guddani rename chesuko ade othadi sir ki telugu radu ani telugu lo dengaku matalu gudda muskoni po bey...* *vadu endhuko edo issue undachu or anything else bey ani tittadam endi bey... neeku gade neripinchindra nee badilo teachers day* *roju whatsapp status lo prema suppetadam kadhu eppudu respect evvu adhi chalu nee comment evvadu pattichkodu... Rename* *command gurinchi neeku google mastu content susuko po bey...*