*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/I3SxzqfouLF61TGAUQeell Thanks, NiC IT Academy ======================================================================= 🔵Oracle SQL Tutorial - English ruclips.net/p/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* ruclips.net/video/C1zGVRFM3-A/видео.html 📌*Informatica Full Course:* ruclips.net/video/V2FtZ_INmjg/видео.html 📌*SQL Full Course:* ruclips.net/video/iuvzjf7nU1I/видео.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist ruclips.net/p/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist ruclips.net/p/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH ruclips.net/p/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் ruclips.net/p/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist ruclips.net/p/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL ruclips.net/p/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer ruclips.net/p/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos ruclips.net/p/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks
Evolo clear ah begin to end super ah cover panerunkenga. Solla varthai illa bro Tamil medium boys/girls ku ethu rompa useful ah erukum nu nan nambaren.. Nandri bro🙏🙏🙏
Hello sir, 1:00:06 instead of taking backup of a table, we can create one duplicate col of the col datatype to be change. After changing the datatype we can assign back the values to original cols and drop the duplicate col ryt!. It's a much precise way!!. Pls crct me if I'm wrong btw. Thanks
I am an SAP ABAP developer....learning oracle for a purpose....your video helps a lot, each and everything has been explained very clearly..... appreciate your effort...
Very good explanation sir.. very systematic way of teaching.. helped me a lot to start sql from zero level.. Thanks :) Now ll go through your PL SQL videos..
Step by step all the concept explained. Really useful in real time scenario and it helps me a lot. Expecting more videos from different technologies. Kudos for your effort.
6+ hours , i dont know tamil language but i understand technical words so language not big problem for me , but waiting for english version also 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉 Nice video 👍👍
dear sir thanks a lot for your video its helps me more and so many sql concepts now clear. I appreciate your way of explanation and hard work put for your video. 💝
Thanks for all ur efforts, presentation and way of teaching that pushing me to do something. Once again Thanks. I understood all the concepts because of u. 🙏🙏🙏
I am really thankful for your video. Because i love sql and my working platform is plsql, pro c and sql. After this video utilization, will improve my present skills and inform you a good news soon. Thank you
Hello Sir, Thank you so much for your detailed video, with help of this I have cracked the Infosys Interview at the first attempt. Only because of your detailed I was able to answer most of the questions which was asked with me. Your explanations are awesome. Thanks will not enough for you for these efforts 😊😊😊
@@NICITACADEMY dear sir last one year before i wrote above query but that is manually need to change but now i finetune i given one new dynamic query SELECT substr('WELCOME TO CHENNAI RAJA', instr('WELCOME TO CHENNAI NAGA', 'TO ', 1, 1) + 3, instr('WELCOME TO CHENNAI NAGA', ' ', 1, 3)-1 -instr('WELCOME TO CHENNAI NAGA', ' ', 1, 2)) FROM dual; this query will return all city name
select a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name from all_constraints a , all_cons_columns b where a.constraint_name=b.constraint_name and a.owner='HR' and a.table_name='CUSTOMER'; while running this, its showing nothing in my system
Wow super teaching! But, How to install Oracle software; I found internet, installation I don't know.. tools; taps; menu; shortcuts; etc. Please explain! Pervious If you video post please link comments
I couldn’t see any constraint detail in my all_constraints table. Given correct owner too. Please help me sir. If I insert any duplication am getting that mean I created primary key in city_id Column in city table.
Questions from inserting values in city table After alter the primary key for city table we cannot insert the values in the city table because it doesn't allow any duplicate? What to do ?
Hi Sir, select a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name from all_constraints a , all_cons_columns b where a.constraint_name=b.constraint_name and a.owner='HR' and a.table_name='CUSTOMER'; when i use the above code, the output is empty . there is no results displayed in output
Hi sir thanks for your video....I can't find all constraints tables I have followed your steps but I can't find the system constant tables. Please replay.
Thanks for the wonderful video sir , I have one doubt. In duration 1hr:40 minutes, you have used a & b parameters for join two table to look up the constraints, can you please explain why have you used a b?
Hello sir,How to add a column in customer table?? I try Alter table customer Add column unit_instock varchar2(10); But it came error 😢 Please sir kindly requested,solve the question of how to add a column in customer table??
select substr('Welcome to CHENNAI CHROMPET', 12,7) from dual union select substr('Welcome to BANGALURU ITPL', 12, 9)from dual Union select substr('Welcome to MUMBAI KALYAN', 12, 6) from dual; is this correct?
How to import Hr schema in 11 g version sir? I have given alter user hr identified by hr account unlock in system_admin There is a table but there is no bulk records
Thank you so much for this video. This gives a lot of clarity in Basics. Could you give a differentiation between rownum and row_number ? When are we using these in real time ?
*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/I3SxzqfouLF61TGAUQeell
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
ruclips.net/p/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
📌*IICS demo session:*
ruclips.net/video/C1zGVRFM3-A/видео.html
📌*Informatica Full Course:*
ruclips.net/video/V2FtZ_INmjg/видео.html
📌*SQL Full Course:*
ruclips.net/video/iuvzjf7nU1I/видео.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ruclips.net/p/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj
🌕 Informatica training in ENGLISH - Playlist
ruclips.net/p/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd
🌕 Informatica Interview Preparation - ENGLISH
ruclips.net/p/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d
🌕Oracle SQL - தமிழில்
ruclips.net/p/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4
🔵 Informatica training in தமிழில் - Playlist
ruclips.net/p/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3
🔵 Informatica Interview Preparation - TAMIL
ruclips.net/p/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD
🔵Unix for Informatica Developer
ruclips.net/p/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw
🌕Informatica Project videos
ruclips.net/p/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6
Please subscribe, Like, and comment. I will post more videos.
Thanks
Bro ETL Testing and data warehouse videos podunga. Thank you.
மிக்க நன்றி ஐயா... தங்களின் பணிக்கு தலைவணங்குகிறேன்.
மிக்க நன்றி சகோதரா. தொடர்ந்து படியுங்கள்.
Sir u r amezing class sir .....I'm quickly understood ... This one videos watch and definitely go IT job sir very thanks sir .... really amezing sir
Thanks and welcome. Keep watching my channel.
Sir nalla website solunga sir SQL run panna...
Evolo clear ah begin to end super ah cover panerunkenga. Solla varthai illa bro Tamil medium boys/girls ku ethu rompa useful ah erukum nu nan nambaren.. Nandri bro🙏🙏🙏
Thank You very much.
We really appreciate your time and effort sir, thank you so much
It's my pleasure
Actually I have joined SAP , in that way in my project required oracle knowledge so thats I came to watch your video it's really helpful Sir.
Watched so many videos and find your channel, awesome teaching .. you are the best. Great teaching.. thanks lot
You're very welcome!
Great Course. I have thoroughly enjoyed this course. I have learned a lot.
Excellent
Thanks a lot for this free coaching, keep up the good work!
Thank you.
Whenever I have some doubts in SQL I will watch this video 🥰 You r really awesome Sir 👌😍
Glad to hear that, Keep watching my channel.
Bro.. Version 10g use pannalaamaa bro .. thericha sluga
Hello sir,
1:00:06 instead of taking backup of a table, we can create one duplicate col of the col datatype to be change. After changing the datatype we can assign back the values to original cols and drop the duplicate col ryt!. It's a much precise way!!. Pls crct me if I'm wrong btw. Thanks
I am an SAP ABAP developer....learning oracle for a purpose....your video helps a lot, each and everything has been explained very clearly..... appreciate your effort...
Glad it was helpful! Keep watching my channel.
Hi sis any job wanted plz
Sap enna subdivision painna solluga I am a clg student
Very good explanation sir.. very systematic way of teaching.. helped me a lot to start sql from zero level.. Thanks :) Now ll go through your PL SQL videos..
All the best. Keep watching my channel
Nice and clear Explanation. You made the SQL course easy sir.
Glad to hear that
Today only I complete the full video. It's really helpful for me. Once again thank you very much...
You are most welcome
tamil best sql tutorial so far great video in you tube i will definitely recommend this viedo thank you so much sir keep rocking
Thank you so much 🙂
Excellent teaching sir!
I got what I Expected.
Excellent, keep watching my channel.
Step by step all the concept explained. Really useful in real time scenario and it helps me a lot. Expecting more videos from different technologies. Kudos for your effort.
Thanks for your feedback, Sure I will do. Keep watching my channel.
i learned SQL in single day because of your video. thank you
Great to hear!
🙄 is it possible?? 🤔
@@viswal5266 uruttu
A very good tutorial. Real time scenario examples are very useful in understanding. Thanks
Glad it was helpful!
Thank you so much sir!. This is really helpful... And able to learn easily
You are most welcome
6+ hours , i dont know tamil language but i understand technical words so language not big problem for me , but waiting for english version also 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉
Nice video 👍👍
Will upload soon
dear sir thanks a lot for your video its helps me more and so many sql concepts now clear. I appreciate your way of explanation and hard work put for your video.
💝
You are most welcome. Keep watching my channel.
brother.. really your presentation will be helpful for me i guess. thank u.
You are most welcome
Thanks a lot Bro.. I'm Functional consultant and this video is very helpful to understand better on the database side... 👌
You are most welcome
How to be ome a functional consultant
Thanks for all ur efforts, presentation and way of teaching that pushing me to do something. Once again Thanks. I understood all the concepts because of u. 🙏🙏🙏
You're very welcome! Keep watching my channel. I will upload more videos.
Thank You Sir.
Long time waiting for this one.
Most welcome plsql videos
Most welcome
super na , theliva irukku....👍👍👍👍👍
me also waiting for PL sql video sir
Sure, I will add soon.
எனக்கு பிடித்துள்ளது. நன்றி.
Thank You
Thank you sir🙏🙏 very very useful video 💗💗💗💗💗
Keep watching
Sir you are really amazing thank you for helping us through youtube .
Thanks
best channel to learn about database.sir your informatica videos are really awesome
Thanks a ton
Sir, Your sql notes very use full. Nega indha maari plsql video poduga sir most of waiting
Okay, allow me some time ..
Awesome tutorial for beginners 🥰, excellent teaching, by this i can learn very easy,
Thanks, Keep watching my channel.
Thank you soo much 🙏🙏🙏🙏🙏🙏🙏🙏🙏 very helpful 💖💖💖
Thanks
Vera level sir, great🙏🙏💯, thank you sir.
Welcome 👍
It is very useful for all.and thanks for your great effort sir.
You are most welcome
GREAT VIDEO BRO, LEARNED A LOT THINGS
Glad you enjoyed it. Keep watching my channel.
Good job and thank you so much ...pls keep posting for plsql as well👍
Thank you, I will
Sir,Really i'm impressed a lot by the way u teach ... Thank u sir.
Thanks and welcome
This is very useful video for all students including Me ❤❤
Glad to hear that
I am really thankful for your video. Because i love sql and my working platform is plsql, pro c and sql. After this video utilization, will improve my present skills and inform you a good news soon. Thank you
Sure, I am waiting. You can do it.
Sir sql padicha job vacancy iruka freshers ku or addition ah vera ethuvum padikanuma?
Great Efforts Sir
Really Useful
Thanks ❤
Most welcome
Super clean explaination sir
Great
Thank you, Keep watching
select substr('welcome to bangalur itpl',instr('welcome to bangalur itpl',lower('B'),1),8)
from dual
for bangalur
Keep up your good work
Thank you so much sir it's really helpful 🤝🏻💐
Most welcome
But wonderful video sir
Hatts of to you sir
Thanks a lot
Thank you very much for your time and effects sir.😊
Welcome, I put lot of effort to create this video, Kindly watch fully. if you have any queries add in comments, I will respond. Keep watching.
@@NICITACADEMY yeah sure.
Hello Sir,
Thank you so much for your detailed video, with help of this I have cracked the Infosys Interview at the first attempt.
Only because of your detailed I was able to answer most of the questions which was asked with me.
Your explanations are awesome. Thanks will not enough for you for these efforts 😊😊😊
You are most welcome. I am happy that the session is more useful for those job aspirant. Keep learning.
Bro intha 6:00 hour videos patha job la sethuralama
Anna is this wholesome sql video for informatica😃🙌 may i know pls ?....
Yes definitely it is more than enough. Kindly practice and share your comments.
@@NICITACADEMY nuvvu devudu swamy🙏🙂
Sir please give me the Oracle 11g installation video where is it. I couldn't find in the description.
ruclips.net/video/Jrefk1hOJQg/видео.html
Nice video sir.. Love from kerala
Thanks
@@NICITACADEMY can you make tutorials of database administration
select substr('WELCOME to chennai chropet',instr('WELCOME to chennai chropet','c',2),7)
from dual;
for chennai
I appreciate it.
Thank you sir!
You are welcome!
Thanks sir,Pls more video podunga
Sure 👍
Sir really superb and thanks for detailed explanation 👌👌👏then please provide a notepad link for practical purpose..
Check description
Vaaa thalaivaaa.....🥰🥰🥰🥰
Thank you so so so so much sir.......😊
Most welcome
select substr('WELCOME TO MUMBAI KALYAN',12,6) from dual;
for mumbai
Good work
@@NICITACADEMY dear sir last one year before i wrote above query but that is manually need to change but now i finetune i given one new dynamic query SELECT
substr('WELCOME TO CHENNAI RAJA', instr('WELCOME TO CHENNAI NAGA', 'TO ', 1, 1) + 3, instr('WELCOME TO CHENNAI NAGA', ' ', 1, 3)-1
-instr('WELCOME TO CHENNAI NAGA', ' ', 1, 2))
FROM
dual; this query will return all city name
Thank you sir ur class useful ❤️
Always welcome
select a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name from all_constraints a , all_cons_columns
b where a.constraint_name=b.constraint_name and a.owner='HR' and a.table_name='CUSTOMER';
while running this, its showing nothing in my system
please share the degree educational background sir
Ivalothan iruka sql la oracle mysql ena doffernece iruku
Thanks for your effort .
Welcome. Keep watching.
Very useful one I request to DBA videos
Thanks and sure
What is the answer to extract city in 2:46:07
please practice the substr and instr and you can able to do.
Thanks for your great effort sir.. Also request you to do full session in PLSQL which is more useful for us.
Sure I will
how to find the primary key costraints in sql plus ?you have used owner = hr,it refers to what sir
?
HR is the schema name. Refer all_constraints table for constraints.
Wow super teaching! But, How to install Oracle software; I found internet, installation I don't know.. tools; taps; menu; shortcuts; etc. Please explain! Pervious If you video post please link comments
Please check the SQL playlist in my channel, I have posted all the videos and installation.
Very useful sir
Thanks and welcome
@@NICITACADEMY please provide English
I am creating in English, I will post soon.
I couldn’t see any constraint detail in my all_constraints table. Given correct owner too. Please help me sir. If I insert any duplication am getting that mean I created primary key in city_id Column in city table.
Great sir...
Sir table can be brought back after using ddl drop if we use flashback
eg :flashback table tablename to before drop;
Yes, you can. But you have to use before dropping the table.
Keep watching my channel.
Bro. At 12.48 minutes you was saying dba do user and scema creation. And now us. Then who are we?
Since it is our machine, we are acting as DBA and Developer both.
@@NICITACADEMY thanks bro. U r good. I bought a oracle sql course from udemy. But now your video is better than that.👍
Thank you so much sir!!!
Most welcome!
Bro vera level teaching
Thank you very much.
Hi Sir. Is there a separate video for the connection details. I am not sure how to connect. Please help here.
Please watch my Oracle Installation video.
Questions from inserting values in city table After alter the primary key for city table we cannot insert the values in the city table because it doesn't allow any duplicate? What to do ?
Thank you so much ❤ sir
Most welcome
👍🤝🤝@@NICITACADEMY
where can i avail the query and notes matterial ...so that i can practice that
Please check the description, I have updated the link.
Can we use double INSTR in one query sir..?
Hi Sir,
select
a.owner,a.constraint_name,a.constraint_type,b.table_name,b.column_name
from all_constraints a , all_cons_columns b where a.constraint_name=b.constraint_name
and a.owner='HR' and a.table_name='CUSTOMER';
when i use the above code, the output is empty . there is no results displayed in output
Few Questions
1. Do you have CUSTOMER table in HR schema?
2. Run in the query in HR schema
select substr('Welcome to chennai Chrompet',12,instr('Welcome to chennai chrompet','',3) from dual;. ????what's wrong
select substr('Welcome to chennai Chrompet',12,instr('Welcome to chennai chrompet',' ',3)) result from dual;
But answer is coming as chennai chrompet
Bro ithae Mari sap course Ella module video podunga bro
Super explanation sir.
Thanks and welcome
Hi sir thanks for your video....I can't find all constraints tables I have followed your steps but I can't find the system constant tables. Please replay.
Check in which user you are running the query.
@@NICITACADEMY ok thank you for sharing your support. ☺️
Thanks for the wonderful video sir , I have one doubt.
In duration 1hr:40 minutes, you have used a & b parameters for join two table to look up the constraints, can you please explain why have you used a b?
How to owner ,in join constraints column position not showing,thank for great effort sir
Find owner
Can you please help me to get a single row function exercise table (employee).
Install Oracle 21C or 11g by watching my installation video.
Hi sir, need your help regarding ORA-12516,TNS:Listener does not currently know of service requested in connect descriptor ,how to resolve this error
Hello sir,How to add a column in customer table??
I try
Alter table customer
Add column unit_instock varchar2(10);
But it came error 😢
Please sir kindly requested,solve the question of how to add a column in customer table??
alter table customer add unit_instock varchar2(10);
Please join my Live training session
For more details contact me on WhatsApp
wa.link/m4lat0
*action define it as a table check constraint error occurs when make foreignkey , what to do sir?
Check the spelling and make sure it should be a PK in another table.
Thanks for your effort. I am right now in Manual testing. What can be my next job when I learn Oracle - SQL? desperate to move out from Manual testing
You can learn SQL and Informatica, move to ETL testing or ETL developer
@@NICITACADEMY Thank you so much for showing a path
Hi sir, metadata_how to do json data convert to Normalized tables
Bro oru curior service data base created pannum epadi seiradhu
Is this compilation of all videos you uploaded in day wise oracle playlist?
I have added new stuff as well, please watch..
select substr('Welcome to CHENNAI CHROMPET', 12,7) from dual
union
select substr('Welcome to BANGALURU ITPL', 12, 9)from dual
Union
select substr('Welcome to MUMBAI KALYAN', 12, 6) from dual;
is this correct?
How to import Hr schema in 11 g version sir? I have given alter user hr identified by hr account unlock in system_admin
There is a table but there is no bulk records
in Oracle 11g, HR schema is already included, just unlock it.
@@NICITACADEMY now its unlocked thanks
Thank you so much for this video.
This gives a lot of clarity in Basics.
Could you give a differentiation between rownum and row_number ?
When are we using these in real time ?
Both are to identify the records, watch my analytical functions video.
How to handling informatica WRT_8164 ERROR BAD ROWS EXCEEDED SESSION THRESHOLD
It is writer thread error, please share some more log error with data..
@@NICITACADEMY this error only came sir.
error should be there, send session log.