HomeОбразованиеRelated VideosMore From: simran kaur

SQL TUTORIAL-4 (Create table, Alter table, ADD and DROP column, MODIFY Column Data type)

31 ratings | 16949 views
SQL queries for 1. Create table 2. Add new Column 3. Drop a column 4.change column data type
Html code for embedding videos on your blog
Text Comments (13)
ASWATH MARRI (1 year ago)
It's urgent
ASWATH MARRI (1 year ago)
Hi madam ,I need alter a column data type varchar to varbinary please post that query please
Sandeep Rahul (1 year ago)
can you please make your video clear and re-upload same thing
Matt Conrad (1 year ago)
Your screen is very difficult to see. Shoot in a higher quality
simran kaur (1 year ago)
Oh yes :) That's true!Thanks for your feedback though.
Gabriel Martinez (2 years ago)
A Kid who knows Database...What an Advance in our Species!
Souvick Sen (2 years ago)
how to add data in that column which i added by using alter command???
Dinesh Kumar (3 years ago)
I am using Oracle 10g . i want  to change data type .but it show error . SQL> alter table emp alter column sal int   not null; alter table emp alter column sal int   not null                 * ERROR at line 1: ORA-01735: invalid ALTER TABLE option
simran kaur (3 years ago)
+Dinesh Kumar That's because you are using it with oracle. These queries were meant for SQL server. I believe the keyword is Modify is Oracle.Thanks
Raj Mishra (4 years ago)
what is difference b/w alter table and modify table....so can we use modify in place of alter ???
mohammed shafras (4 years ago)
THANK YOU
Rayon Daley (1 year ago)
Can u help me with a question I have? My email is [email protected] let me know via an email
simran kaur (1 year ago)
You're welcome :)

Would you like to comment?

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