Complete 48 hours of Self-Paced Courses and Interview Questions Links:* courses.nicitacademy.com/ Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 *WhatsApp group:* chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0 Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html 📌*IICS demo session:* th-cam.com/video/C1zGVRFM3-A/w-d-xo.html 📌*Informatica Full Course:* th-cam.com/video/V2FtZ_INmjg/w-d-xo.html 📌*SQL Full Course:* th-cam.com/video/iuvzjf7nU1I/w-d-xo.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html 🌕 Informatica training in ENGLISH - Playlist th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html 🌕 Informatica Interview Preparation - ENGLISH th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html 🌕Oracle SQL - தமிழில் th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html 🔵 Informatica training in தமிழில் - Playlist th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html 🔵 Informatica Interview Preparation - TAMIL th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html 🔵Unix for Informatica Developer th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html 🌕Informatica Project videos th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html Please subscribe, Like, and comment. I will post more videos. Thanks
Lucky that I found your videos sir. Very easy to understand. Clear and crisp explanation. I love the way to teach. You keep reminding us about the check points to keep in mind. Most teaching professionals would not do that. Great work sir. Thank you so much for this playlist. I am from a non-IT background. I am searching for a job as a Data Analyst. This will help me a lot through my learning journey. Thank you once again.
PL/SQL program #anonnymous black full topic #trigger full topic #curser full topic #stored procedure full topic #functions full topic #packags full topic video post pannunga sir.
thank you sir ... really understood #assignment did using mysql database drop table product; create table product ( prod_id varchar(50), prod_name char(50), manu_name date, company_name char(50), unit_price int not null, category_name char(50) ); insert into product values('E10','redmi','2000-04-01','xiomi',10000,'note 10'); select * from product; alter table product add external_storage int; desc product; alter table product drop column company_name; desc product; alter table product modify prod_name char(100); desc product; alter table product rename to product_table; select * from product_table; alter table product_table rename column unit_price to product_price; desc product_table;
1.ithu oru Fron-end App-la order complete aanathu. atha customer-la manula delete panna mudiyala athai nan 'Database'-la delete pannanum. 2.எனக்கு ஒரு table-ல particular old column-அ delete பண்ண சொல்லறாங்க அப்ப column-மட்டும் delete-ஆகுமா இல்ல அந்த column-த்தோட தொடர்புடைய எல்லா row-வும் delete ஆகுமா . 3.அப்படி delete பண்ணனும்னா எப்படி query use பண்றது plz update . 4.I mean oru 100 old ID-nu solranga particulara athai mattum epadi delete panrathu.
Sir have one doubt.VARCHAR2(3 CHAR)-this means what sir.can u please explain this when u free. when i create the table and given the datatype sql its showing in drop down.
Sir Got an error while insert into datas like product_Id,name,etc..,( Error starting at line : 17 in command - insert into Product (Product_Id,Product_Name,Manu_Date,company_name,unit_Price,Category_Name) Values(37001,'Bingo',to_date('01/20/2024','mm/dd/yyyy'),'ITC',1752,'Snacks') Error report - ORA-01950: no privileges on tablespace 'USERS') Kindly do the needful
Sir all the topics are well explained but can you please tell about the difference between truncate and drop function because both are DDL statement and both will delete the table and cannot rollback then why it has both name?
Truncate is a DDL command whereas Delete is a DML command Similarly , truncate will delete entire data in the table whereas delete command can Delete entire data as well as partial data using Where clause In Truncate rollback can't be achieved whereas in Delete we can rollback
Truncate will not delete the column names. It is like having a blue print of the table with no data in it. Drop will delete the whole table. After Truncate, you can still view the table. But no data will be there. After Drop, you cannot view the table. It will be gone forever.
ORA-12988: cannot drop column from table owned by SYS 12988. 00000 - "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 Please advise.
Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Thanks
Welcome. Thanks Kiruba for your Thanks. Keep watching my channel.
Lucky that I found your videos sir. Very easy to understand. Clear and crisp explanation. I love the way to teach. You keep reminding us about the check points to keep in mind. Most teaching professionals would not do that. Great work sir. Thank you so much for this playlist. I am from a non-IT background. I am searching for a job as a Data Analyst. This will help me a lot through my learning journey. Thank you once again.
Thanks and welcome. Continue to complete all the SQL videos and start learning Informatica, It will take you for the next career path.
Keep learning.
@@NICITACADEMY Thank you sir. Yes I am planning to complete the complete SQL playlist as soon as possible. Also thank you for the suggestion sir.
Sir is there any mobile sites to workout oracle ? Because i dont have a laptop.
livesql.oracle.com/apex/f?p=590:1000
very clear explantion sir good sir keep it up sir . your very easy to way of teach.
Thanks
well explained sir.. Thank you so much.. Please keep uploading videos.. waiting for your updated videos
Thank you, I will
Broo rmbhaa superaa puriyuthu broo...konjaa SQL developer fresher oda resume epdii irkaanuu slii oru video podungaa broo
PL/SQL program
#anonnymous black full topic
#trigger full topic
#curser full topic
#stored procedure full topic
#functions full topic
#packags full topic video post pannunga sir.
No way sir unga Madiri no one teach. Simply superb and it should be go on.👍
Thanks. Keep watching.
nalla understand aaguthu bro, continue it bro
Sure, Please like the video and keep watching other videos
Thank you very very much.
You are welcome!
Excellent, very interesting. Keepit up sir.ur Every word is examination and interview pointofview nice.
Many many thanks
Keep rocking this is very useful
Thanks a lot
42:41 How to change the length of PRODID Column. Could any one help me please
Well explained sir!! Please keep posting videos it really helpful for us.
Thank you, I will
well explained.. keep rocking... it is very useful..
Thanks a lot
Superb..... Explanation.... Great Job....
Thanks a lot
Very well explained sir.. Thank you so much.. Please keep uploading videos.. Great effort sir👍
Keep watching. Thank You.
thank you sir ... really understood
#assignment did using mysql database
drop table product;
create table product
(
prod_id varchar(50),
prod_name char(50),
manu_name date,
company_name char(50),
unit_price int not null,
category_name char(50)
);
insert into product values('E10','redmi','2000-04-01','xiomi',10000,'note 10');
select * from product;
alter table product
add external_storage int;
desc product;
alter table product
drop column company_name;
desc product;
alter table product
modify prod_name char(100);
desc product;
alter table product
rename to product_table;
select * from product_table;
alter table product_table
rename column unit_price to product_price;
desc product_table;
WOW..WELL EXPLAINED SIR
Thanks and welcome. Keep watching.
Good initiative bro.
Thanks a ton
1.ithu oru Fron-end App-la order complete aanathu.
atha customer-la manula delete panna mudiyala
athai nan 'Database'-la delete pannanum.
2.எனக்கு ஒரு table-ல particular old column-அ delete பண்ண சொல்லறாங்க அப்ப column-மட்டும் delete-ஆகுமா இல்ல அந்த column-த்தோட தொடர்புடைய எல்லா row-வும் delete ஆகுமா .
3.அப்படி delete பண்ணனும்னா எப்படி query use பண்றது plz update .
4.I mean oru 100 old ID-nu solranga particulara athai mattum epadi delete panrathu.
Sir have one doubt.VARCHAR2(3 CHAR)-this means what sir.can u please explain this when u free. when i create the table and given the datatype sql its showing in drop down.
It means varchar2(3)
@@NICITACADEMY thank 🙏 you sir.
Could you post video SQL and plsql program video perday two videos podunga sir.
Plsql developer and production support video poduga
If I want to change the column name with out mention the table it is possible
Great
hello sir ,
table product created
but
query results not showing sir
can u pls tell me where is icon of query results?
Enable to query result windows in view.
@@NICITACADEMY sir cant get it.
Very good and clear cut explanation sir....tqsm 👌 👍....plz upload java collection framework sir🙏🙏
Thanks for your feedback, but I do not have much experience in Java. I will upload more Oracle and ETL videos.
@@NICITACADEMY kk sir kk🤗🤗
Why did not still come yesterday video sir.
I need to learn plsql...This oracle sql and plsql are same ??
Plsql will have Procedural language, SP, Function, package, trigger, collections, cursor, etc.. SQL is base for all.
@@NICITACADEMY thank u sir..
@@NICITACADEMY Can I go for Oracle sql..is this related to plsql
Yeah, First learn SQL and Practice more, then go for PLSQL... watch my channel, SQL in 6 hours, that is more than enough. Keep watching.
Tq so much
Welcome 😊
Sir SQL + plsql rendume kandippa learn pannanuma Ila SQL full ah terinjale job Ku ok va
Only SQL also fine but you need to be very very strong. PLSQL we can learn quickly if you know SQL very well.
Tanks a lot sir
Exhalent sir
Rollback to b means b Ku next record la irundu last record Vara rollback aguma
up to 'B' it will be rolled back, just do practice, you will come to know.
ORA-01950: no privileges on tablespace 'USERS' error keeping show bro how to solve
Please watch my Oracle 21C installation video. You can install without issues.
Really useful. Are you providing training session. I am interested to join
Hi, Thanks. Yes, Please contact @nicitacademy@gmail.com. I am handling it. Keep watching my channel.
Commands run panraduku shortcut solunga sir
Ctrl+enter
Sir would like to join a course for informatica etl do you take sessions if so kindly let me know about the payment details and the time slot .
Yes, sure. Please contact @nicitacademy@gmail.com
Sir Got an error while insert into datas like product_Id,name,etc..,(
Error starting at line : 17 in command -
insert into Product
(Product_Id,Product_Name,Manu_Date,company_name,unit_Price,Category_Name)
Values(37001,'Bingo',to_date('01/20/2024','mm/dd/yyyy'),'ITC',1752,'Snacks')
Error report -
ORA-01950: no privileges on tablespace 'USERS') Kindly do the needful
Sir all the topics are well explained but can you please tell about the difference between truncate and drop function because both are DDL statement and both will delete the table and cannot rollback then why it has both name?
Thanks, I have posted the video already on this topic. Kindly check in SQL Playlist.
Truncate is a DDL command whereas Delete is a DML command
Similarly , truncate will delete entire data in the table whereas delete command can Delete entire data as well as partial data using Where clause
In Truncate rollback can't be achieved whereas in Delete we can rollback
Truncate will not delete the column names. It is like having a blue print of the table with no data in it. Drop will delete the whole table. After Truncate, you can still view the table. But no data will be there. After Drop, you cannot view the table. It will be gone forever.
Could you explaine CONDITIONAL EXPREESSION(CASE,DECASE)
Sure I will post. Keep watching my channel
@@NICITACADEMY thank you sir.
No explain for Merge cammand
I will post separate video for Merge. Keep watching.
Datastage videos podunga
Sorry DataStage I do not have experience. I will try my level best. Keep watching my channel.
ORA-12988: cannot drop column from table owned by SYS
12988. 00000 - "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
Please advise.
why you want to drop system tables?
I am working as sys@xe is that wrong
Hi, can we get whatsapp group link. Link in description is not working.
I will check and update
I need to learn plsql...This oracle sql and plsql are same ??