*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 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
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...
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🙏🙏🙏
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 👍👍
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.
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..
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 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
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. 🙏🙏🙏
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 😊😊😊
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. 💝
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
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
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
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?
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 ?
@@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 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?
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.
*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
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
Bro ETL Testing and data warehouse videos podunga. Thank you.
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
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.
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.
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...
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
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.
மிக்க நன்றி ஐயா... தங்களின் பணிக்கு தலைவணங்குகிறேன்.
மிக்க நன்றி சகோதரா. தொடர்ந்து படியுங்கள்.
We really appreciate your time and effort sir, thank you so much
It's my pleasure
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
i learned SQL in single day because of your video. thank you
Great to hear!
🙄 is it possible?? 🤔
@@viswal5266 uruttu
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 🙂
Watched so many videos and find your channel, awesome teaching .. you are the best. Great teaching.. thanks lot
You're very welcome!
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
Great Course. I have thoroughly enjoyed this course. I have learned a lot.
Excellent
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 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?
Nice and clear Explanation. You made the SQL course easy sir.
Glad to hear that
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.
A very good tutorial. Real time scenario examples are very useful in understanding. Thanks
Glad it was helpful!
Thanks a lot for this free coaching, keep up the good work!
Thank you.
Thank You Sir.
Long time waiting for this one.
Most welcome plsql videos
Most welcome
Excellent teaching sir!
I got what I Expected.
Excellent, keep watching my channel.
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
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.
Sir, Your sql notes very use full. Nega indha maari plsql video poduga sir most of waiting
Okay, allow me some time ..
Sir you are really amazing thank you for helping us through youtube .
Thanks
Awesome tutorial for beginners 🥰, excellent teaching, by this i can learn very easy,
Thanks, Keep watching my channel.
best channel to learn about database.sir your informatica videos are really awesome
Thanks a ton
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
It is very useful for all.and thanks for your great effort sir.
You are most welcome
எனக்கு பிடித்துள்ளது. நன்றி.
Thank You
Thank you sir🙏🙏 very very useful video 💗💗💗💗💗
Keep watching
Great Efforts Sir
Really Useful
Thanks ❤
Most welcome
Thank you so much sir!. This is really helpful... And able to learn easily
You are most welcome
brother.. really your presentation will be helpful for me i guess. thank u.
You are most welcome
Good job and thank you so much ...pls keep posting for plsql as well👍
Thank you, I will
Thank you soo much 🙏🙏🙏🙏🙏🙏🙏🙏🙏 very helpful 💖💖💖
Thanks
Vera level sir, great🙏🙏💯, thank you sir.
Welcome 👍
super na , theliva irukku....👍👍👍👍👍
me also waiting for PL sql video sir
Sure, I will add soon.
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.
GREAT VIDEO BRO, LEARNED A LOT THINGS
Glad you enjoyed it. Keep watching my channel.
Thank you so much sir it's really helpful 🤝🏻💐
Most welcome
Super clean explaination sir
Great
Thank you, Keep watching
Thanks for your great effort sir.. Also request you to do full session in PLSQL which is more useful for us.
Sure I will
select substr('welcome to bangalur itpl',instr('welcome to bangalur itpl',lower('B'),1),8)
from dual
for bangalur
Keep up your good work
But wonderful video sir
Hatts of to you sir
Thanks a lot
Sir really superb and thanks for detailed explanation 👌👌👏then please provide a notepad link for practical purpose..
Check description
Very useful one I request to DBA videos
Thanks and sure
Thank you so so so so much sir.......😊
Most welcome
Thank you sir ur class useful ❤️
Always welcome
select substr('WELCOME to chennai chropet',instr('WELCOME to chennai chropet','c',2),7)
from dual;
for chennai
I appreciate it.
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🙏🙂
Thanks sir,Pls more video podunga
Sure 👍
Bro vera level teaching
Thank you very much.
Thanks for your effort .
Welcome. Keep watching.
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.
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
Nice video sir.. Love from kerala
Thanks
@@NICITACADEMY can you make tutorials of database administration
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
Thank you so much sir!!!
Most welcome!
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?
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.
Thank you sir!
You are welcome!
Vaaa thalaivaaa.....🥰🥰🥰🥰
It's very very useful video and very good explanation.can we get this tutorial pdf format?
Please Check description
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
Great sir...
Super explanation sir.
Thanks and welcome
Thank you so much ❤ sir
Most welcome
👍🤝🤝@@NICITACADEMY
Very useful sir
Thanks and welcome
@@NICITACADEMY please provide English
I am creating in English, I will post soon.
please share the degree educational background sir
Sir please give me the Oracle 11g installation video where is it. I couldn't find in the description.
th-cam.com/video/Jrefk1hOJQg/w-d-xo.html
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
Hi thank you for easy learning. Can we have fusion financial video ?
Yes, sure
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.
How to owner ,in join constraints column position not showing,thank for great effort sir
Find owner
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?
Tq for your precious tym
😊 Thanks, Keep watching
Thank you very much sir....
Most welcome
Sir, Your voice almost similar to udhaya nithi stalin voice .
ha ha ha.. Keep watching my channel.
Software engineer aaguradhuku python course padika sonnaga. And adhu kooda SQL padika sonnaga... Ippo neenga sollithara SQL padicha podhuma sir??? Indha video la complete course cover pannirkingala????
yeah, please complete this full video and practice, go for advanced topics and apply for SQL developer role.
@@NICITACADEMY ok sir👍
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. ☺️
Very Good
Thank you! Cheers!
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.
Is this compilation of all videos you uploaded in day wise oracle playlist?
I have added new stuff as well, please watch..
Teach once again constraints sir
okay, sure.
Hello sir..thank you so much for your time and effort...can u pls tell me how to find is there any duplication in record using aggregate functions.
Not possible by aggregate functions
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.👍
Can you please help me to get a single row function exercise table (employee).
Install Oracle 21C or 11g by watching my installation video.
Awesome brother 🔥❤
Thank you so much 😀
Dheivamae Nandri
Mikka nandri, Keep watching my channel.
Thank you sir
Welcome
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..?
Bro ithae Mari sap course Ella module video podunga bro
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.