Are you interested in joining my Live training? or Self-Paced course?
Please visit our website for more details. www.nicitacademy.com/ Contact me for more details @ 🌕 wa.link/m4lat0 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
At 14:25 min, declare n1 number(6):=&n1; n2 number(6):=&n2; c number(8); begin c:=n1+n2; dbms_output.put_line('the addition of two numbers:'||c); end; It is not executing.when I run the code,it shows "ORA-06550: line 2, column 15: PLS-00103: Encountered the symbol "&" when expecting one of the following: ( - + case mod new not null"
@@NICITACADEMY hi sir... I have mechanical background.. But got job in IT as a Data Engineer. I learn SQL through your videos. In tamil no one can teach like this.. Keep rocking sir... And thanks..
Hi chandra, After execution iam not getting any output on dbms output but i got message like PL/SQL procedure successfully completed. can you please help me on this.
Hi Sir, This videos was very useful. I helps me to understand very easily and learn fast. I am waiting this PLSQL tutorial 2nd part tutorial for longtime (more than 6 months). Can you please post 2nd part ASAP.
please join my live training 🌕For more details contact me on WhatsApp (+91 7010080468) or below link wa.link/m4lat0 Join PLSQL WhatsApp group chat.whatsapp.com/CNAgUu2lMCzI9DIkhC05ym
@@NICITACADEMY Please Sir try to upload soon,very eagerly waiting for decode and pl sql tutorial,I have completed all sql tutorials.All were very helpful.Thanks a lot.
Hi sir .I have one request. I can hear ur voice very clearly but ur presentation is not clear. Its shows like shaking videos. I cant get it what ur typing there .if its possible please to change and put clear video sir . Thank u sir . Ur doing very good job
yen nenga plsql ku full chapetrs tamil la post panala...sql ku matum fulla potrukenga tamil la.. plsql fulla tamil la iruntha enaku nejamave rombaveee usefulla irunthurukum
Hi team, thanks for your useful session for beginners. I had completed this session & practiced as well. Could you please share the link for next/subsequent session on continuing with this session?
DECLARE CURSOR c1 is SELECT ename, empno, sal FROM emp ORDER BY sal DESC; -- start with highest paid employee my_ename VARCHAR2(10); my_empno NUMBER(4); my_sal NUMBER(7,2); BEGIN OPEN c1; FOR i IN 1..5 LOOP FETCH c1 INTO my_ename, my_empno, my_sal; EXIT WHEN c1%NOTFOUND; /* in case the number requested */ /* is more than the total */ /* number of employees */ INSERT INTO temp VALUES (my_sal, my_empno, my_ename); COMMIT; END LOOP; CLOSE c1; END; Sir one small help how can I convert plsql queries into the Java code
CREATE OR REPLACE FUNCTION employer_details_func RETURN varchar; IS var_salary varchar; BEGIN SELECT salary INTO var_salary FROM employee; RETURN var_salary; END; and this two codes sir DECLARE x NUMBER := 100; BEGIN FOR i IN 1..10 LOOP IF MOD(i,2) = 0 THEN -- i is even INSERT INTO temp VALUES (i, x, 'i is even'); ELSE INSERT INTO temp VALUES (i, x, 'i is odd'); END IF; x := x + 100; END LOOP; COMMIT; END;
Are you interested in joining my Live training? or Self-Paced course?
Please visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
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
Thank you so much chandru sir .. Waiting for next session. 🙂
Very soon
Hii sir.. Your teaching is very good. Understandable. Kindly upload video for, functiins, triggers, cursors, cursor loop.
Thanks, Will upload it soon. Keep watching my channel.
Pls provide the video for function, package, trigger, cursors. Ur explanation is too good and easily understandable
Sure I will
Thank you for your videos sir it helps me a lot keep upload more plsql videos
Keep watching
At 14:25 min,
declare
n1 number(6):=&n1;
n2 number(6):=&n2;
c number(8);
begin
c:=n1+n2;
dbms_output.put_line('the addition of two numbers:'||c);
end;
It is not executing.when I run the code,it shows "ORA-06550: line 2, column 15:
PLS-00103: Encountered the symbol "&" when expecting one of the following:
( - + case mod new not null"
Thank you so much sir ❤🤝🤝🔥🔥🔥
I'm glad you liked it!
Thank you sir ☺️
Waiting for your next session
Always welcome. Keep watching.
I will upload more videos on PLSQL.
@@NICITACADEMY hi sir... I have mechanical background.. But got job in IT as a Data Engineer. I learn SQL through your videos. In tamil no one can teach like this.. Keep rocking sir... And thanks..
Great and clear explanation in Tamil. It's super..I'm waiting for your next session plSql Tamil version videos. Thank you.
Keep watching
@@NICITACADEMY but tamil la tha ilaiye
set server output on; dont forget to run this before executing any plsql block
Bro we can use if- then - else in sql but in another keywords like when-then-else
Sir, Make it in english as well. I learn alot from your sql tutorial
Please provide the video in TAMIL for PL/SQL functions, package, trigger and cursor .
thanks for the wonderful lesson sir
You are welcome
Dbms_output.put_line is exisitng package ??
yeah, existing Oracle default package.
Sir.. wch is the continuation video of this topic.. I'm not able to find any video of this continuation..
courses.nicitacademy.com/courses
Sir sql basic theriyum front end back end kolamputhu sir clear panna mudiyuma ya front end back end use pannuraganu
Please watch my SQL session, please check the playlist.
Hi chandra, After execution iam not getting any output on dbms output but i got message like PL/SQL procedure successfully completed. can you please help me on this.
Please share me your procedure
bro epudi plsql install panurtahu atha pathi slunga bro you may share a video reference also it can helpful to me....
please watch the session, I explained. There is no separate installation.
Sir your video's are helping alot
Post plsql in English language sir
Sure, I will do.
Hi Sir, This videos was very useful. I helps me to understand very easily and learn fast. I am waiting this PLSQL tutorial 2nd part tutorial for longtime (more than 6 months). Can you please post 2nd part ASAP.
Will upload soon
@@NICITACADEMY Hi Sir,
I am eagerly awaiting for your next set for PLSQL tutorials for long time.
Kindly Please upload ASAP sir.
Pl SQL developer application install video podunga with trail database
Sure, Keep watching my channel. Thanks
Will U Make a Video in English for All Plsql topics and I didn't get some of SQL topics views indexes performance Tuning and all ...
yes, please stay tuned.
Good explanation better to explain in ENGLISH it usefull for All
Yes, thanks
sir itha run panna app venuma illa online la ethu compiler iruka sir
download link send panunga sir
Sir cursor, exceptions upload sir
Hi sir..may i know most used transformations in informatica sir
SQ, Expression, Lookup, Update strategy, etc
It depends on the project business logic
@@NICITACADEMY Tq sir
Hello sir, thanks for your effort and explanation. Its very usefull. Do you conduct online class for PL/Sql? If yes, can u please reply me?
Pls upload single row function in Oracle!
I already uploaded, please check here
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
Thank you!😍
You're welcome 😊
Iam waiting for next session sir please upload sir 🙏
Sure. I ll do
thank you so so so much.................................sir.
Most welcome
Hi sir i saw your sql full course it was awesome but i am searching for pl/Sql full course. Please provide in english🎉
Sure I will
Sir functions and packages videos podunga sir
Ok sure
Could you please share the queries and ppt used in this video?
Thank you
You're welcome
Sir,
Will make videos in English in future.
PL/SQL Tutorial for Beginners...
Sure I will
enga athukapuram plsql video ethum varalaiye sir.next next video and unix and shell script video poduvinga
Sir,please upload entire PlSql tutorials in english,requesting since long ago.
please join my live training
🌕For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
Join PLSQL WhatsApp group
chat.whatsapp.com/CNAgUu2lMCzI9DIkhC05ym
Hi sir. Plsql playlist link kudunga
Please upload one separate tutorial video on decode function,requested it long time back.
Will upload soon
@@NICITACADEMY Please Sir try to upload soon,very eagerly waiting for decode and pl sql tutorial,I have completed all sql tutorials.All were very helpful.Thanks a lot.
What is the difference between MySQL and plsql
MySql is open source DB, PLSQL is procedural language. Please watch my SQL Day 1 session to get more detailed explanation. check the SQL playlist.
Please upload next sessions sir
Sure.
Hi sir .I have one request. I can hear ur voice very clearly but ur presentation is not clear. Its shows like shaking videos. I cant get it what ur typing there .if its possible please to change and put clear video sir . Thank u sir . Ur doing very good job
Hi, It is due to your network speed and quality, in TH-cam setting, please increase video the quality to high. This is not from my end.
Thank u sir..❤️
Welcome 😊
Sir i want online live class sql and pl/sql,
please contact me nicitacademy@gmail.com
yen nenga plsql ku full chapetrs tamil la post panala...sql ku matum fulla potrukenga tamil la..
plsql fulla tamil la iruntha enaku nejamave rombaveee usefulla irunthurukum
we need full video in plsql sir
I ll upload
Sir could you please make this video in English also.🙏 We don't understand Tamil.
Sure I will do, Keep watching my channel.
@@NICITACADEMY sure sir. Please upload videos ASAP because we need urgently. Thnks sir🙏
courses.nicitacademy.com/
Hi sir ..
Plz give full course in English
Sure
Hi ❤ nice video and are you taking online class for students.please share contact details.
Yes, I am handling online training sessions, please Check description
Antha seven videos oda combined video VA ithu?
Yeah correct, as per the request from followers I combined in it single video.
@@NICITACADEMY ok sir waiting for upcoming plsql videos
if possible Can u please put videos daily on plsql
Sir, Please do in videos in English also...
Sure
Sir plsql videos in English videos upload pls sir
Thanks, Will upload it soon. Keep watching my channel.
super bro.
Thank you
Could you please provide English version also
Yes I ll upload in English
Hello Sir,could you please upload all plsql tutorial in english?
sure
Sir...plsql full notes pdf upload panunga sir...
Hi Sir,
Please upload this tutorial in english language so that we can also understand the concept
Hi sir can i get plsql full class like
Procedure
Function
Tirger
Packages
Sure I will add
Hello Sir, please upload plsql tutorial videos in English also. Thank you.
Hai Brother
Please provide the video for PL/SQL functions, package, trigger and cursor. Your teaching skills very good and easy to understandable..
Will upload soon
Hi team, thanks for your useful session for beginners. I had completed this session & practiced as well. Could you please share the link for next/subsequent session on continuing with this session?
Will upload soon
Sir, please upload in English
🌕For Live training contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
Sir in hindi too please sir
Please do triggers, functions, package, cursors and collection.
Sure, I will post videos
Sir pls do separate videos for procedures functions packages triggers
Can you please upload in English
Sure
Hi sir! Can u plz upload the next session. We are all waiting for the next video.
Yes, sure
English sir atleast subtitles
I will upload in English soon.
Keep support
Not in order by thalapathy fan
DECLARE
CURSOR c1 is
SELECT ename, empno, sal FROM emp
ORDER BY sal DESC; -- start with highest paid employee
my_ename VARCHAR2(10);
my_empno NUMBER(4);
my_sal NUMBER(7,2);
BEGIN
OPEN c1;
FOR i IN 1..5 LOOP
FETCH c1 INTO my_ename, my_empno, my_sal;
EXIT WHEN c1%NOTFOUND; /* in case the number requested */
/* is more than the total */
/* number of employees */
INSERT INTO temp VALUES (my_sal, my_empno, my_ename);
COMMIT;
END LOOP;
CLOSE c1;
END;
Sir one small help how can I convert plsql queries into the Java code
Sir pls give me what's app group link...
please check the about section
Sir pls give me plsql session notes...
CREATE OR REPLACE FUNCTION employer_details_func
RETURN varchar;
IS
var_salary varchar;
BEGIN
SELECT salary INTO var_salary FROM employee;
RETURN var_salary;
END;
and this two codes sir
DECLARE
x NUMBER := 100;
BEGIN
FOR i IN 1..10 LOOP
IF MOD(i,2) = 0 THEN -- i is even
INSERT INTO temp VALUES (i, x, 'i is even');
ELSE
INSERT INTO temp VALUES (i, x, 'i is odd');
END IF;
x := x + 100;
END LOOP;
COMMIT;
END;
Sir, unga mail id...enna sir
nicitacademy@gmail.com or check the about section in TH-cam channel.
new whatsapp link pls
updated, please check now
PL SQL - trigger, package ,
sir can you please upload this video in English