Tutorial#8 How to Rename/Modify/Add/Remove column of a table|Alter SQL Statement in oracle database

preview_player
Показать описание
explaining How to add a column of a table, Modify Data type of a table, Rename column and remove the column of a table using Alter table

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:
Рекомендации по теме
Комментарии
Автор

one of the most awesome thing about your teaching is the way you planned the curriculum and the way you explained is amazing

parikshitgurjar
Автор

I search so many channels for learning sql but i didn't understand properly...the way you explained is awesome sir ...

ramvlogs
Автор

Hi..Rakesh...awesome explanation...And i want to add one point..please give explanation for how to add more than one column in a single query..same for dropping columns...thanks

vinothkumar-jmmv
Автор

you written all your code on sqldeveloper ...why are the bottom once are not execute at the same while run we need to bring the on top of sql
by the way thank you so much for the wonderful videos

BibekGhoshh
Автор

how to encrypt a column in th etable. getting wallet is not open error. Thanks in advance

venketatriyambaka
Автор

dear sir
I can do everything in oracle data base instead drop columns.when i drop a column it shows error msg as you are not allowed to drop column.Can you explain regarding this matter?

NiroshanUdayanga
Автор

What you are pressing to see the output, after modify, add and to see the definition of the table.

devit
Автор

ALTER TABLE <Table_name> Drop <Column_Name> dont work, you must use ALTER TABLE <Table_name> Drop Column <Column_Name>

gopixus
Автор

when I try to drop a column from a table .. I gir ORA-12988 error: cannot drop column from table owned by SYS .. why is that! plz help ..

azigtovmasian
Автор

Hi rakesh I want all answers for pratical questions to check my answers are crct or not can u pls provide it.

rajivyallamraju
Автор

When I use a subtitle other than English, I cannot view it.

sonerkocak
Автор

ALTER TABLE employee drop column Employee_Id;


Error starting at line : 9 in command -
ALTER TABLE employee drop column Employee_Id
Error report -
ORA-12988: cannot drop column from table owned by SYS
12988. - "cannot drop column from table owned by SYS"
*Cause: An attempt was made to drop a column from a system table.
*Action: This action is not allowed

how to solve it

Vishal-dkvl
welcome to shbcf.ru