Procedures in Oracle PL/SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ธ.ค. 2024

ความคิดเห็น • 32

  • @saishsawant7831
    @saishsawant7831 3 ปีที่แล้ว +1

    The sound from your keyboard! So satisfying lol!

  • @srinivasreddy186
    @srinivasreddy186 4 ปีที่แล้ว +1

    Hello Kishan, i hope u r dng well. I like ur collection of video series nd also plz do a few videos on performance tuning. Thanks so much always...

  • @SatyendraSingh-ul5iq
    @SatyendraSingh-ul5iq 3 ปีที่แล้ว +1

    Please make a video on ‘how to data migrate from one table to another Table by using store procedure in oracle.

  • @satvinderbhangu361
    @satvinderbhangu361 4 ปีที่แล้ว +1

    How can we create procedures if we have two tables data

  • @joaovinicius4838
    @joaovinicius4838 9 หลายเดือนก่อน +1

    THANKS FROM BRASIL SIL SIL SIL

  • @satvinderbhangu361
    @satvinderbhangu361 4 ปีที่แล้ว +1

    Hi kishan i have questions in plsql how we can use run time variable inside procedure. Could create a procedure please

  • @rajvizag6757
    @rajvizag6757 7 ปีที่แล้ว +1

    Hi Kishan, I have a requirement like, i need to create a Package with procedure which needs to print randomly any 10 employees data in the log file. And also , if I pass a specific emp_id, i need to get that particular emp details . If this parameter emp_id is not a mandatory parameter, then it needs to print all the 10 emp details in the log file. Can you please explain how to achieve this functionality? Its an interview question which I faced recently.

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว +5

      We do not need a package to achieve this, you can do it simply by creating a procedure as follows:
      -- TABLE
      CREATE TABLE EMPLOYEES
      ( EMPLOYEE_ID NUMBER,
      FIRST_NAME VARCHAR(100)
      );
      -- TABLE VALUES
      INSERT INTO EMPLOYEES VALUES (100, 'Steven');
      INSERT INTO EMPLOYEES VALUES (101, 'Ellen');
      INSERT INTO EMPLOYEES VALUES (102, 'Sundar');
      INSERT INTO EMPLOYEES VALUES (103, 'Mozhe');
      INSERT INTO EMPLOYEES VALUES (104, 'David');
      INSERT INTO EMPLOYEES VALUES (105, 'Hermann');
      COMMIT;
      --CREATE PROCEDURE
      CREATE OR REPLACE PROCEDURE PRINT_EMP(P_EMP_ID NUMBER DEFAULT NULL)
      IS
      P_NAME VARCHAR(50);
      BEGIN
      IF P_EMP_ID IS NULL THEN
      FOR ROW IN (SELECT FIRST_NAME FROM EMPLOYEES WHERE ROWNUM

    • @rajvizag6757
      @rajvizag6757 7 ปีที่แล้ว

      Hi Kishan,it worked. Thanks for your quick reply and easy explanation with less code complexity. Good luck.

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      Welcome :)

    • @ashokmark4858
      @ashokmark4858 4 ปีที่แล้ว

      Everytime the result will be same..but I really want it like randomly...( Don't want same set of employees everytime )
      How is it possible?

  • @pankajkharade6936
    @pankajkharade6936 4 ปีที่แล้ว +1

    Good Job

  • @aldiwiryatama774
    @aldiwiryatama774 3 ปีที่แล้ว

    How can we create a procedure of total orders of each customers?

  • @sowmyagayam3518
    @sowmyagayam3518 7 ปีที่แล้ว

    Hi kishan, I'm Sowmya. I'm using TOAD, when ever I run a PLSQL program I got "ora-24344 success with compilation error" ...
    All my SQL queries run properly, But PLSQL code is not working. Same code is running on my friends machine...
    Please give me the solution..........Please help me......

  • @rk-ej9ep
    @rk-ej9ep 5 ปีที่แล้ว

    Nice explanation

  • @harishjeerla265
    @harishjeerla265 6 ปีที่แล้ว

    Hello,
    in my table i have deptno column. In that 10th dept having 5 rows (it showing error like .
    ERROR at line 1:
    ORA-01422: exact fetch returns more than requested number of rows

    • @ramchinthakayala2092
      @ramchinthakayala2092 5 ปีที่แล้ว

      if select statement returns more than one row then we have to use cursors variable to hold that no of rows.

  • @junaidtanoli1
    @junaidtanoli1 7 ปีที่แล้ว

    are there any HD videos ?

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      all of my videos are HD!!!

    • @junaidtanoli1
      @junaidtanoli1 7 ปีที่แล้ว

      ah this video is 480p max, my eyes hurt >

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      I'll try and upload these few again, with better quality :)

    • @junaidtanoli1
      @junaidtanoli1 7 ปีที่แล้ว +1

      Thanks bro :) Love ur videos

  • @veeranji2455
    @veeranji2455 7 ปีที่แล้ว +1

    super explain....

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      Thanks :) Hope you have given a "thumbs up" to the video, and have subscribed to our channel.

  • @bheeman3831
    @bheeman3831 3 ปีที่แล้ว

    Please make a debug procedure

  • @etishridas1555
    @etishridas1555 6 ปีที่แล้ว

    why we use procedure?? when to use procedure ?

    • @KishanMashru
      @KishanMashru  6 ปีที่แล้ว

      Etishri :) the most common question that developers face!!! Say you are assigned a task where you need to perform various tasks (insert/update/delete on various conditions) you need procedure.
      This video can help you get better understanding
      th-cam.com/video/pofSn7lzqxA/w-d-xo.html
      Hope you have liked the video and subscribed to our channel!!!

  • @shashank2004
    @shashank2004 7 ปีที่แล้ว +1

    Nice explanation sir,pls make a video how to send e-mail through Plsql code.

    • @KishanMashru
      @KishanMashru  7 ปีที่แล้ว

      Thanks shashank, to be fair, I haven't used plsql to send mails mostly take careof it through .Net code, but there are built in packages to send emails from plsql, will explore it and possibly make a video :)
      you can have a look at the below link for the video on sending mail through .Net
      th-cam.com/video/LbLyOLyozhs/w-d-xo.html

    • @ramchinthakayala2092
      @ramchinthakayala2092 5 ปีที่แล้ว

      You can send emails by using UTL_MAIL package.

  • @akshaychikhale8072
    @akshaychikhale8072 6 ปีที่แล้ว

    screen chota rakho .corner me kya edit karte ho wo nahi dikh raha

    • @KishanMashru
      @KishanMashru  6 ปีที่แล้ว

      han bhai, ye 1 aad video mei eesa ho gaya hai, anyways have taken care of it from then on!!!