*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 ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html 📌*IICS demo session:* ua-cam.com/video/C1zGVRFM3-A/v-deo.html 📌*Informatica Full Course:* ua-cam.com/video/V2FtZ_INmjg/v-deo.html 📌*SQL Full Course:* ua-cam.com/video/iuvzjf7nU1I/v-deo.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html 🌕 Informatica training in ENGLISH - Playlist ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html 🌕 Informatica Interview Preparation - ENGLISH ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html 🌕Oracle SQL - தமிழில் ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html 🔵 Informatica training in தமிழில் - Playlist ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html 🔵 Informatica Interview Preparation - TAMIL ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html 🔵Unix for Informatica Developer ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html 🌕Informatica Project videos ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html Please subscribe, Like, and comment. I will post more videos. Thanks
Hi Sir, can u please let me know how to load Cities like HYD, MI and COUNTRY_ID is 'INDIA' using Instr function in IICS ?? I have used Instr(CITY, 'Hyd', 'MI') AND Instr(COUNTRY_ID, 'INDIA') but getting an error . Please help me on this. Thank you
Hi there, Your tutorials are really helpful. Just a suggestion, it would be great if you can update the TOPIC of these tutorial videos for us to identify. Thanks!
Hello Sir, Good Day! I tried to access the files in your drive. Unfortunately I couldn't get into it, Shows "Page Not Found". Can you please help me with your Notes. Thank You.
Please post SQL looder External table Table partition Virtual colum And SQL identity colum 11g Sequence with Syntex and example program in detail with level and connect by clause and pseudo column explain with in detail sir...😊 Synonyms
Please post virtual column topic with defination and index organized table topic and identity colum these are associated with each other sir.pleast post video subractly or in all sir... because it is very very small topic sir....i hope you to post video as soon as possible .....thank you sir.....😊
What is SQL Regular Expressions in 11g regex how to use with syntax and example and please explain sir with listagg and pivot and unpivot please explain And post video as soon as possible sir.....thank you sir
Please post index and index organized table and fragmentation rebuild and re organize index and What is cluster index and noncluster and unique index how it will work with example and explain in details sir.please post video as soon as possible sir....😊
hello sir day 5 or single row functions notes are missing in this link can you please provide the notes for practice. your class all are awesome with detailed explanations.
When will you post merge and correct subquery with defination and syntex with example and interview questions please post viedos sir.this topic spending for the long time sir.please post it as sooN as possible sir.....thank you....😊
Hi Sir, As we have thousands of data in real time project how can we use substr, instr for all rows of data ? is there any way if we write one query (dynamically ) to do findout substr,instr?
@@NICITACADEMY very thanks sir,i m fresher and i got this question in my interview,but i unable to answer.i m not selected. i watched all your videos,and wait for next videos.
What is difference between for loop and forall and cursor for loop please explain with in detail and exampl and syntex....😊 Already post loop concept sir ...I am waiting this part please post video as soon as possible.if you get free time please post small topics please post regularly sir.....😊
Please post video plsql collection topic with example and syntax there after wherein what is difference between please explain video eventually and interview questions and answers sir....thank you ....please explain in detail sir.😊
Please post performance tuning video for plsql interview. please will post video as soon as possible sir.... nowadays, it's necessary one for interview....please post sir....😊
Sir have already posted in view topic quiz end what's query rewrite?.I need video subractly this topic please video upload in detail with example much.please post topic sir.....if you could posible to post video matrialized view topic subractly because I couldn't not understand this topic .. could you teach in another way in order to easy understanding sir...... because it is very very important topic sir... Only then performance tuning topic it could understand for that is reason only please explain with in detail sir.it is my humble request sir......thank you ....sir😊
*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
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Sir if I take membership of 199 then oracle 20 videos will come
Please reply
Thank you sir for your videos really helps to learn knowledge 🥰
It's my pleasure
Agenda is awesome...thanks for this wonderful video....nice
It really is! Keep watching.
It is very helpful sir..thank you so much.
Most welcome
Thank you so much sir....😊
Most welcome
In Translate function if we translated particular alphbet with null then we can not recover it by reverse way.
very understandable thank you
Hi Sir, can u please let me know how to load Cities like HYD, MI and COUNTRY_ID is 'INDIA' using Instr function in IICS ??
I have used Instr(CITY, 'Hyd', 'MI') AND Instr(COUNTRY_ID, 'INDIA') but getting an error . Please help me on this. Thank you
Thank you very much sir.
Most welcome
Hi there,
Your tutorials are really helpful. Just a suggestion, it would be great if you can update the TOPIC of these tutorial videos for us to identify.
Thanks!
Thanks
Hello Sir, Good Day! I tried to access the files in your drive. Unfortunately I couldn't get into it, Shows "Page Not Found". Can you please help me with your Notes. Thank You.
Due to security reason, notes are deleted.
Please post SQL looder
External table
Table partition
Virtual colum
And SQL identity colum 11g
Sequence with Syntex and example program in detail with level and connect by clause and pseudo column explain with in detail sir...😊
Synonyms
Please post virtual column topic with defination and index organized table topic and identity colum these are associated with each other sir.pleast post video subractly or in all sir... because it is very very small topic sir....i hope you to post video as soon as possible .....thank you sir.....😊
Noted
What is SQL Regular Expressions in 11g regex how to use with syntax and example and please explain sir with listagg and pivot and unpivot please explain And post video as soon as possible sir.....thank you sir
I can't find the exercises in the description. Please guide me to get it.
Please post index and index organized table and fragmentation rebuild and re organize index and
What is cluster index and noncluster and unique index how it will work with example and explain in details sir.please post video as soon as possible sir....😊
Great suggestion!
hello sir day 5 or single row functions notes are missing in this link can you please provide the notes for practice. your class all are awesome with detailed explanations.
select substr('Welcome to CHENNAI CHROMPET', 12, instr('Welcome to CHENNAI CHROMPET' , ' ', 3,1)-1) from dual;
Good work
When will you post merge and correct subquery with defination and syntex with example and interview questions please post viedos sir.this topic spending for the long time sir.please post it as sooN as possible sir.....thank you....😊
Hi Sir,
As we have thousands of data in real time project how can we use substr, instr for all rows of data
?
is there any way if we write one query (dynamically ) to do findout substr,instr?
we can handle up to millions of data too.. if any performance issue, then we have to do performance tuning.
@@NICITACADEMY Thank you sir🙂
Sir,how can i write query with mod in emp_id =112.124,136,148........160.
please reply.
Here is the solution.
select * from (
select * from employees where mod(employee_id,4) =0)a where mod(a.employee_id,3) =1 ;
@@NICITACADEMY very thanks sir,i m fresher and i got this question in my interview,but i unable to answer.i m not selected.
i watched all your videos,and wait for next videos.
Sir, Decode topics are not covered in the English version, Tamil version is available and could you please check and advise us..
What is difference between for loop and forall and cursor for loop please explain with in detail and exampl and syntex....😊 Already post loop concept sir ...I am waiting this part please post video as soon as possible.if you get free time please post small topics please post regularly sir.....😊
Noted
Please post video plsql collection topic with example and syntax there after wherein what is difference between please explain video eventually and interview questions and answers sir....thank you ....please explain in detail sir.😊
Noted
Please post performance tuning video for plsql interview. please will post video as soon as possible sir.... nowadays, it's necessary one for interview....please post sir....😊
As soon as possible
Sir have already posted in view topic quiz end what's query rewrite?.I need video subractly this topic please video upload in detail with example much.please post topic sir.....if you could posible to post video matrialized view topic subractly because I couldn't not understand this topic .. could you teach in another way in order to easy understanding sir...... because it is very very important topic sir... Only then performance tuning topic it could understand for that is reason only please explain with in detail sir.it is my humble request sir......thank you ....sir😊
What is index views using shema bind and unique cluster index please in addition to index topic ...sir.
Okay
Of i take membership I will get remaining videos of oracle
No, As of now I have uploaded only 10 videos. I need to upload remaining videos.
Please post video sir about UNIX important commend s for interview purpose please post video as soon as possible sir....thank you...sir...😊
As soon as possible
@NIC IT ACADEMY Sir, Can you please upload the next sql videos in English. You already uploaded in Tamil.
Can you please upload video on triggers, cursors exception handling and all other advanced concepts in pl/sql."" Thnaks
Yes, sure
Sir please complete all the topics.. ASAP..please sir🙏🙏🙏
sure
Please post video sir.how to install oracle 21c express edition....thank you sir.....😊
Okay Sure.
Sir please discuss DECODE() method
sure, I will upload new video for decode alone.
@@NICITACADEMY Thank you Sir,please try to upload soon as I am preparing for interview.
Waiting for this sir
Thanks, keep watching fully and support.
What is difference between in and exists please post video sir.
noted
Hi sir,
Could you please upload the remaining SQL course
Thanks
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
Sir, what is the difference between 0 & null
0 is a value and it will occupy memory space
null means nothing, no memory space. (blank)
sir i had few questions on sql , how to connect you ?
please send mail to nicitacademy@gmail.com
@@NICITACADEMY i shared my queries to you sir from another mail id
Hii sir where is notes
Kindly check in the description.
sir please upload day 6 day 7 day 8 video asap[
I will post soon
Thank you so much sir
Most welcome
@NIC IT ACADEMY Sir, Can you please upload the next sql videos in English. You already uploaded in Tamil.
Sure I will do