*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
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...
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
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🙏🙏🙏
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 👍👍
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..
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. 🙏🙏🙏
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 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, 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 😊😊😊
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
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.
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
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
![[DRAGON BALL LEGENDS REVEALS ＆ STUFF] LEGENDS FESTIVAL 2024 Special Edition Part 1](http://i.ytimg.com/vi/mV5bGIswTtQ/mqdefault.jpg)
*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.
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.
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
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
மிக்க நன்றி ஐயா... தங்களின் பணிக்கு தலைவணங்குகிறேன்.
மிக்க நன்றி சகோதரா. தொடர்ந்து படியுங்கள்.
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
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...
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.
Today only I complete the full video. It's really helpful for me. Once again thank you very much...
You are most welcome
Watched so many videos and find your channel, awesome teaching .. you are the best. Great teaching.. thanks lot
You're very welcome!
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
i learned SQL in single day because of your video. thank you
Great to hear!
🙄 is it possible?? 🤔
@@viswal5266 uruttu
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
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
Nice and clear Explanation. You made the SQL course easy sir.
Glad to hear that
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 🙂
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.
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?
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
select substr('welcome to bangalur itpl',instr('welcome to bangalur itpl',lower('B'),1),8)
from dual
for bangalur
Keep up your good work
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
Excellent teaching sir!
I got what I Expected.
Excellent, keep watching my channel.
Sir you are really amazing thank you for helping us through youtube .
Thanks
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 ..
select substr('WELCOME to chennai chropet',instr('WELCOME to chennai chropet','c',2),7)
from dual;
for chennai
I appreciate it.
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
Awesome tutorial for beginners 🥰, excellent teaching, by this i can learn very easy,
Thanks, Keep watching my channel.
Thank you so much sir!. This is really helpful... And able to learn easily
You are most welcome
It is very useful for all.and thanks for your great effort sir.
You are most welcome
Thank you sir🙏🙏 very very useful video 💗💗💗💗💗
Keep watching
Thank You Sir.
Long time waiting for this one.
Most welcome plsql videos
Most welcome
Thanks for your great effort sir.. Also request you to do full session in PLSQL which is more useful for us.
Sure I will
brother.. really your presentation will be helpful for me i guess. thank u.
You are most welcome
Ivalothan iruka sql la oracle mysql ena doffernece iruku
This is very useful video for all students including Me ❤❤
Glad to hear that
Thank you soo much 🙏🙏🙏🙏🙏🙏🙏🙏🙏 very helpful 💖💖💖
Thanks
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,
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
super na , theliva irukku....👍👍👍👍👍
me also waiting for PL sql video sir
Sure, I will add soon.
Bro ithae Mari sap course Ella module video podunga bro
Great Efforts Sir
Really Useful
Thanks ❤
Most welcome
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.
please share the degree educational background sir
GREAT VIDEO BRO, LEARNED A LOT THINGS
Glad you enjoyed it. Keep watching my channel.
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.
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
Super clean explaination sir
Great
Thank you, Keep watching
Vera level sir, great🙏🙏💯, thank you sir.
Welcome 👍
Thank you so much sir it's really helpful 🤝🏻💐
Most welcome
Good job and thank you so much ...pls keep posting for plsql as well👍
Thank you, I will
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.
Can we use double INSTR in one query sir..?
But wonderful video sir
Hatts of to you sir
Thanks a lot
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.
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.
Thank you sir!
You are welcome!
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
Sir please give me the Oracle 11g installation video where is it. I couldn't find in the description.
ruclips.net/video/Jrefk1hOJQg/видео.html
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
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
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 ?
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🙏🙂
Very useful one I request to DBA videos
Thanks and sure
Vaaa thalaivaaa.....🥰🥰🥰🥰
It's very very useful video and very good explanation.can we get this tutorial pdf format?
Please Check description
Thank you so so so so much sir.......😊
Most welcome
Sir really superb and thanks for detailed explanation 👌👌👏then please provide a notepad link for practical purpose..
Check description
Great sir...
Thanks sir,Pls more video podunga
Sure 👍
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.
where can i avail the query and notes matterial ...so that i can practice that
Please check the description, I have updated the link.
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
Thanks for your effort .
Welcome. Keep watching.
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.
joins la written la eluthi sonninga na easy ah irukum brother
Please watch full video
Thank you so much sir!!!
Most welcome!
Thank you sir ur class useful ❤️
Always welcome
Sir Sap s4 hana explain panuga ?
Please upload English oracle full video
Bro vera level teaching
Thank you very much.
Nice video sir.. Love from kerala
Thanks
@@NICITACADEMY can you make tutorials of database administration
Hi sir, metadata_how to do json data convert to Normalized tables
Is this compilation of all videos you uploaded in day wise oracle playlist?
I have added new stuff as well, please watch..
Sir, Your voice almost similar to udhaya nithi stalin voice .
ha ha ha.. Keep watching my channel.
@NIC IT ACADEMY
Hii bro oracle 11g instal pandrathukku link kuduthutukken sonninga description la.illiye bro
ruclips.net/video/Jrefk1hOJQg/видео.html
Let me check and add it
Sir please sent Syntex step by step.
How to owner ,in join constraints column position not showing,thank for great effort sir
Find owner
ORA-01950: no privileges on tablespace 'USERS'-------values add pana ethu mathiri show akuthu sir
are you trying in SYSTEM schema?
@@NICITACADEMY no sir i try hr and core schema
Bro oru curior service data base created pannum epadi seiradhu
Dheivamae Nandri
Mikka nandri, Keep watching my channel.
Super explanation sir.
Thanks and welcome
Very useful sir
Thanks and welcome
@@NICITACADEMY please provide English
I am creating in English, I will post soon.
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.👍
Sir i worked as MIS analyst from 2016 to 2019 after i took career break but i completed my ug in 2011 is it possible to get a job..