Session 6 - Stored Procedure in sql Tamil - PLSQL Training in Tamil - plsql தமிழில்

Поділитися
Вставка
  • Опубліковано 21 лип 2024
  • #JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers #oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
    *****************************************************************************************************
    🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
    📌Oracle-PLSQL
    github.com/nicitacademy/PLSQL
    *****************************************************************************************************
    Oracle SQL - Complete tutorial Playlist
    • Oracle SQL - தமிழில்
    *****************************************************************************************************
    Oracle PL/SQL - Complete tutorial Playlist
    • Oracle PLSQL Training ...
    *****************************************************************************************************
    Oracle SQL Day wise Video:
    Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
    Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
    *****************************************************************************************
    PLSQL Session 1:Indroduction
    • Oracle pl sql tutorial...
    PLSQL Session 2:DML Statement
    • Session 2 - DML Statem...
    PLSQL Session 3:IF and Case Statement
    • PLSQL Session 3 - IF a...
    PLSQL Session 4: Anchored datatype in PL/SQL %TYPE %ROWTYPE
    • Anchored datatype in P...
    PLSQL Session 6: Procedure
    • Session 6 - Stored Pro...
    ***********************************************************************************************
    In this video, we’ll learn what is stored procedures in pl sql
    stored procedures in pl sql with examples
    oracle interview questions in tamil
    stored procedure in pl sql developer
    stored procedures sql in tamil
    stored procedure in mysql in tamil
    what is stored procedure in sql tamil
    0:00 PLSQL training in Tamil
    0:47 - Recap of previous session
    2:50 - Stored procedure intro
    4:45 - Stored procedure Syntax
    6:14 - First PLSQL procedure
    10:54 - Procedure to add numbers
    13:45 - Total salary
    17:24 - Data dictionary table for procedure
    Class Notes:
    --------------------
    drive.google.com/file/d/1giB0...
    what is stored procedure in oracle
    how to create stored procedure in sql
    stored procedure in oracle
    stored procedures sql in tamil
    stored procedure vs function in sql server
    oracle sql interview questions for experienced in tamil
    oracle pl sql interview questions in tamil
    oracle pl sql interview questions and answers in tamil
    oracle fresher interview questions in tamil
    oracle fresher interview questions and answers in tamil
    oracle sql interview questions for freshers in tamil
    oracle sql interview questions for developers in tamil
    sql interview questions in tamil
    sql interview questions and answers in tamil
    pl sql interview questions in tamil
    oracle interview questions in tamil
    oracle pl sql interview questions in tamil
    oracle sql interview questions for experienced in tamil
    oracle pl sql interview questions in tamil
    oracle pl sql interview questions and answers in tamil
    oracle fresher interview questions in tamil
    oracle fresher interview questions and answers in tamil
    oracle sql interview questions for freshers in tamil
    oracle sql interview questions for developers in tamil
    sql interview questions in tamil
    sql interview questions and answers in tamil
    pl sql interview questions in tamil

КОМЕНТАРІ • 120

  • @NICITACADEMY
    @NICITACADEMY  2 роки тому +3

    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

  • @caffemilano4168
    @caffemilano4168 2 роки тому +5

    Please upload remaining plsql topics, it's very helpful for lot of us.

  • @vankipurampadmanaban969
    @vankipurampadmanaban969 3 роки тому +1

    Amazing!!
    மிகவும் Excellent ஆ Explain பண்ணிருக்கீங்க!
    ரொம்ப simple ஆ, ஒரு "computer knowledge" இல்லாதவங்களுக்கம் புரியற மாதிரி சொல்லிகுடுக்குறீங்க!
    ரொம்ப - ரொம்ப நன்றி தலைவரே! 🙏

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому

      நண்பரே,
      தங்களின் மென்மையான கருத்துக்கு மிக்க நன்றி.
      இணைந்திருங்கள் நம் சேனலோடு!
      நன்றி.

  • @Jeeva1605
    @Jeeva1605 3 роки тому +2

    20:23 F4 adicha kooda procedure code open aaghum bro

  • @FantasyDark-ub3xh
    @FantasyDark-ub3xh 2 роки тому +1

    Really great sir Detailed Explaination Class kooda ipdi sollitharala aana neenga Freeya ve solli thareenga romba nandri 🙏🙏

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Thank You, Keep watching my channel.

  • @danushkumar5819
    @danushkumar5819 2 роки тому +1

    Thank you so much sir,
    I've learnt lot of things from your PL SQL tutorials, waiting for remaining PL SQL tutorials.

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Thanks, Keep watching my channel. Sure I will post more videos.

  • @pioprince21793
    @pioprince21793 3 роки тому +2

    Kindly continuously keep update the video

  • @pradeepkumar.5172
    @pradeepkumar.5172 3 роки тому +3

    Nice ji... Upload regarding functions too ji...

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому +2

      Sure I will do, I could not spend much time as of now. Soon I will upload.

  • @ashokkumar-rv9tx
    @ashokkumar-rv9tx 2 роки тому +1

    Hi sir I have a doubt , if we insert values into a table through plsql anonymous block, will the inserted values stored in data base or not.

  • @kannanperumal3518
    @kannanperumal3518 2 роки тому +1

    Very good video for PLSQL learning, I subscribed your channel. Please upload more videos.

  • @thenkavimohanasundaram106
    @thenkavimohanasundaram106 2 роки тому +1

    Upload Videos on remaining topics
    This is so helpful

  • @sujithkumar4308
    @sujithkumar4308 3 роки тому +1

    Very clear explanation that is very understandable. Please add cursor, functions and triggers videos too.

  • @ashokkumar-rv9tx
    @ashokkumar-rv9tx 2 роки тому +1

    Thanks for the lesson sir

  • @rinthiyaamoorthy912
    @rinthiyaamoorthy912 Рік тому +1

    Bro apdiye neengaley oru example parameters use panni andha procedure ah compile pannunga bro

  • @jawaharbabu523
    @jawaharbabu523 2 роки тому +1

    You're done very well in other plsql videos

  • @sruthikolla9217
    @sruthikolla9217 2 роки тому +2

    Sir , can you please post the remaining sessions in PL/SQL

  • @lizaffazil9161
    @lizaffazil9161 2 роки тому +2

    Super sir must more video sir and give captions for the video sir

  • @antonyjayaraj95
    @antonyjayaraj95 3 роки тому +1

    உங்கள பதிவிற்கு மிக்க நன்றி

  • @NaveenKumar-xs3no
    @NaveenKumar-xs3no 3 роки тому +1

    NICE EXPLANATION BRO ,WAITING FOR FUNCTIONS,PACKAGES,TRIGGERS VIDEOS,IN BETWEEN PL/SQL SERIES POST SOME OTHER VIDEOS LIKE UNIX COMMANDS THAT MOSTLY USING IN INFORMATICA AND REMAINING INFORMATICA TRANSFORMATION VIDEOS...

  • @bepositive2668
    @bepositive2668 2 роки тому +1

    Sir pls make video on trigger and course pls 😊

  • @anandselvakumar2731
    @anandselvakumar2731 2 роки тому

    Super sir very detailed thank u so much

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Thanks and welcome. Keep watching.

  • @prema716
    @prema716 3 роки тому +2

    create or replace procedure sp_add
    (a in number, b in number, c out number)
    as
    begin
    c:=(a+b);
    dbms_output.put_line(c);
    end;
    EXEC sp_add(14,25,:C);
    print c;
    may i know y am not getting output. Even complied successfully am not getting output jus dispalys as C ..may i know what wrong in that.

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому

      create or replace procedure sp_add
      (a in number, b in number, c out number)
      as
      begin
      c:=(a+b);
      dbms_output.put_line(c);
      end;
      declare
      c number;
      begin
      sp_add(14,25,c);
      end;

  • @sugasugashini1985
    @sugasugashini1985 2 роки тому +1

    I learnt basic concepts from your video ..... I m waiting for new videos.. kindly take cursor i am eagerly waiting sir...

  • @lizaffazil9161
    @lizaffazil9161 2 роки тому +2

    🤗super air 🤗🤗🤗🤗

  • @shanthoshsmart7111
    @shanthoshsmart7111 2 роки тому +1

    Put video about. Function, packages , triggers and curser sir.

  • @PandiyaRaj-nv5ht
    @PandiyaRaj-nv5ht 2 роки тому +1

    Sir please upload the remaining topics in pl/sql. And your teaching is very very good sir.

  • @balajirk3976
    @balajirk3976 2 роки тому +1

    Nice, plz upload Cursor related video

  • @AmitVerma-qy9ge
    @AmitVerma-qy9ge 2 роки тому +1

    or you have already this session in english please share link

  • @gopinathm6784
    @gopinathm6784 2 роки тому +1

    Hi sir, very nice Explanations please upload more video Triggers ,Functions,Packages,Cursor,Exception handling,Bulkbinding and bulk collect,Varry,Collections.
    Thanks,
    Gopinath

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Noted

    • @mani_uxui896
      @mani_uxui896 2 роки тому

      Yes sir please upload the video for those things
      Thank you

  • @grgr1831
    @grgr1831 2 роки тому +1

    Sir cursor epa upload panuvinga

  • @MotivationToMoveForward
    @MotivationToMoveForward 3 роки тому +2

    Thank you so much Sir! All the courses are very useful.
    Could you please post Curser topic PL SQL

  • @harankannan9414
    @harankannan9414 2 роки тому +1

    excellent session sir, it will be helpful if you upload videos on cursor

  • @saminathaneswaramoorthi4217
    @saminathaneswaramoorthi4217 2 роки тому +1

    sir we didnt declare 'commision_pct' so its throwing an error. how u got ouput?

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      if you are going to store a value then you have to declare. Else no need to declare.

  • @ashokkumar-rv9tx
    @ashokkumar-rv9tx 2 роки тому +1

    Sir thankyou so much please post function package triggers.

  • @indrajithkrishnaraj6501
    @indrajithkrishnaraj6501 3 роки тому +1

    Hello ji, I think there is no session of 5 in this PLSQL. Please let me know if I missed.

  • @Muthamil166
    @Muthamil166 3 роки тому +1

    Thank you so much sir your explanation is good sir and understanding easily
    Could you post package topic sir?

  • @chrishems4833
    @chrishems4833 Рік тому +1

    procedure compiled but i m seeing this Errors: check compiler log . Kindly help me out

    • @NICITACADEMY
      @NICITACADEMY  Рік тому

      what is the exact error? share the compiler logs.

  • @prabakaranchandhrasekaran5769
    @prabakaranchandhrasekaran5769 2 роки тому +1

    Thanks bro have watched last 6 session video its very useful for me. Once again thanks for your nice explanation

  • @vijayvj4853
    @vijayvj4853 2 роки тому +1

    ithoda next continue video podunga sir

  • @mani_uxui896
    @mani_uxui896 2 роки тому +2

    Thank you, sir, we want to complete a playlist for PLSQL it's more helpful for us can you post that?

  • @lizaffazil9161
    @lizaffazil9161 2 роки тому +1

    Put more video sir

  • @yuvaraj575
    @yuvaraj575 5 місяців тому +1

    IS , AS keyword edhuku usepandrom nu detail solunga

    • @NICITACADEMY
      @NICITACADEMY  5 місяців тому

      to declare the variable part

  • @vellore_memes_2.041
    @vellore_memes_2.041 3 роки тому +1

    hi bro...kindly post the video for mutating error and how to overcome from this...eagerly waiting for this...

  • @santhoskannan8104
    @santhoskannan8104 3 роки тому +1

    Hi Sir..
    Nice explanation sir. and totally how many Pl/SQL session uploaded sir?
    I can able to see, from session 1 to session 6. IF it is more then 6 please let me know sir.

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому

      Keep watching. I will upload remaining session ASAP.

  • @srilachman2951
    @srilachman2951 3 роки тому +1

    I need explanation for exception handling.. can u make saparate video for exception handling?

  • @noorulameenm2949
    @noorulameenm2949 2 роки тому +1

    thank you so much.. its very usefull and helpfull..then why you did not upload the balance videos..please upload the balance videos we are waiting for your videos......

  • @AmitVerma-qy9ge
    @AmitVerma-qy9ge 2 роки тому +1

    Sir Please post the video in English language

  • @ramkumarrs8218
    @ramkumarrs8218 2 роки тому +1

    Bro knjm edutha videos lam update panunga bro

  • @vigneshmurugan6187
    @vigneshmurugan6187 2 роки тому +1

    hi where can i find remaining sessions of PLSQL

  • @gopir4135
    @gopir4135 Рік тому +1

    HI bro can u upload the topics like plsql functions, triggers, packages, cursors

  • @nasiqthajudeen9486
    @nasiqthajudeen9486 2 роки тому +1

    Your way of teaching is so clear sir.
    One doubt sir,
    is there any Future for PL SQL developer, what kind of jobs and roles can be get?

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому +1

      Yes, we have lot of opening for PLSQL developer still. check in Naukri.

  • @DineshKumar-po5nb
    @DineshKumar-po5nb 2 роки тому +1

    Sir, I need functions , package and cursor pls uploading

  • @jawaharbabu523
    @jawaharbabu523 2 роки тому +1

    Hello sir, please put balance named blocks topics.

  • @jawaharbabu523
    @jawaharbabu523 2 роки тому +1

    Because I'm working in company I have many doubts in plsql

  • @narendrangopal2061
    @narendrangopal2061 3 роки тому +1

    Sir session 5 video is missing

  • @fakeworld3640
    @fakeworld3640 2 роки тому +1

    Plz upload function,cursor topics

    • @NICITACADEMY
      @NICITACADEMY  2 роки тому

      Will upload ASAP. Thanks and welcome. Keep watching my channel.

  • @sivaskarthikesan9304
    @sivaskarthikesan9304 2 роки тому +1

    Hi sir could you please start other topics also (trigger,function,cursor,package)

  • @dharan9203
    @dharan9203 3 роки тому +1

    Upload complete plsql videos

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому +1

      Sure, I will upload. Keep watching. Click on bell button, you will get all update

  • @vishnukumar9179
    @vishnukumar9179 Рік тому +1

    Hi bro online class yedukiringala?

    • @NICITACADEMY
      @NICITACADEMY  Рік тому

      Yes, please contact me at nicitacademy@gmail.com

  • @kalaiselvi-og6gn
    @kalaiselvi-og6gn 2 роки тому +1

    in out topic eppo podaporeenga

  • @thamud6713
    @thamud6713 3 роки тому +1

    Please pl Sql Full course

    • @NICITACADEMY
      @NICITACADEMY  3 роки тому

      Sure, I am working. Soon I will upload.

    • @thamud6713
      @thamud6713 3 роки тому +1

      Ok Thankyou sir👍

  • @_mustanger_
    @_mustanger_ 2 роки тому +1

    Pls add remaining topics!

  • @vtris9936
    @vtris9936 2 роки тому +1

    Please upload remaining plsql topics, it's very helpful for lot of us