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.
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
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......
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
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
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!!!
The sound from your keyboard! So satisfying lol!
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...
Please make a video on ‘how to data migrate from one table to another Table by using store procedure in oracle.
How can we create procedures if we have two tables data
Hi kishan i have questions in plsql how we can use run time variable inside procedure. Could create a procedure please
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.
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
Hi Kishan,it worked. Thanks for your quick reply and easy explanation with less code complexity. Good luck.
Welcome :)
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?
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......
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
if select statement returns more than one row then we have to use cursors variable to hold that no of rows.
How can we create a procedure of total orders of each customers?
THANKS FROM BRASIL SIL SIL SIL
Good Job
Nice explanation
are there any HD videos ?
all of my videos are HD!!!
ah this video is 480p max, my eyes hurt >
I'll try and upload these few again, with better quality :)
Thanks bro :) Love ur videos
Nice explanation sir,pls make a video how to send e-mail through Plsql code.
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
You can send emails by using UTL_MAIL package.
Please make a debug procedure
why we use procedure?? when to use procedure ?
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!!!
super explain....
Thanks :) Hope you have given a "thumbs up" to the video, and have subscribed to our channel.
screen chota rakho .corner me kya edit karte ho wo nahi dikh raha
han bhai, ye 1 aad video mei eesa ho gaya hai, anyways have taken care of it from then on!!!