PLSQL Block to generate the report in format of Interview Call Letter - (Using Cursors Demo-3)
This video practically demonstrates the how to generate the interview call letter for each candidate who have applied for interview.
WRITE A PLSQL SQL BLOCK TO PRINT A LETTER IN THE FOLLOWING FORMAT :
INTERVIEW (CANDI_NO,CANDI_NAME,CANDI_ADD, CANDI_CITY, CANDI_PIN, POST_FOR, INTER_DATE_TIME)
TO,
(CANDI_NAME),
(CANDI_ADD),
(CANDI_CITY)-(CANDI_PIN)
DEAR (CANDI_NAME),
WITH REFERENCE TO YOUR APPLICATION FOR POST OF (POST_FOR), YOU ARE SUPPOSED TO BE
PRESENT FOR INTERVIEW ON (INTER_DATE) AT (INTER_TIME) O''CLOCK.
PLEASE GET IN TOUCH WITH ORIGINAL CERTIFICATES.
YOURS TRULY,
X.Y.Z
---------------------------DATA of Interview Table------------
CREATE TABLE INTERVIEW(
CANDI_NO INT PRIMARY KEY,
CANDI_NAME VARCHAR2(20) NOT NULL,
CANDI_ADD VARCHAR2(20),
CANDI_CITY VARCHAR2(15),
CANDI_PIN NUMBER(6),
POST_FOR VARCHAR2(20),
INTER_DATE_TIME DATE)
/
INSERT INTO INTERVIEW VALUES('1001','PARAG SHUKLA','SADHUVASVANI ROAD',
'RAJKOT',360005,'ASSOCIATE PROFESSOR',
TO_DATE('25-09-22 15:25:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1002','DEVEN PATEL','MOTIBAG',
'JUNAGADH',384050,'ASSOCIATE PROFESSOR',
TO_DATE('16-09-22 09:30:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1003','DHARMIK CHOTALIYA','S.G.HIGHWAY',
'AHMEDABAD',380015,'PROGRAMMER',
TO_DATE('20-09-22 16:30:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1004','KAPIL SHUKLA','HARIOM APARTMENT',
'SIDHPUR',384151,'ASSISTANT PROFESSOR',
TO_DATE('15-09-22 14:00:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1005','JIGISH CHITALIYA','KHANDI POL',
'WADHVAN',363001,'ASSISTANT PROFESSOR',
TO_DATE('20-09-22 11:15:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1006','SANDIP RAMANI','JAY AMBE ROAD',
'MODASA',383315,'PROJECT MANAGER',
TO_DATE('21-09-22 11:45:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1007','RAVI MAPARA','KHAU GALI ROAD',
'VALSAD',396001,'SR. PROGRAMMER',
TO_DATE('22-09-22 12:45:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1008','NISAR KALIA','NEAR ALPHA SCHOOL',
'AMRELI',365601,'ASSISTANT PROFESSOR',
TO_DATE('23-09-22 10:45:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1009','VIRAL SARVAIYA','NEAR VAISHNAV DEVI',
'AHMEDABAD',380015,'PROJECT MANAGER',
TO_DATE('26-09-22 14:45:00','DD-MM-YY HH24:MI:SS'))
/
INSERT INTO INTERVIEW VALUES('1010','KULDEEP LAKHATARIYA','NEAR JAMUNA HOTEL',
'LIMBDI',363421,'ASSISTANT PROFESSOR',
TO_DATE('29-09-22 15:45:00','DD-MM-YY HH24:MI:SS'))
/
COMMIT
/
SELECT * FROM INTERVIEW
/
For Learning More about Programming
Subscribe to My Channel: https://www.youtube.com/c/drparagshuk...
Watch video PLSQL Block to generate the report in format of Interview Call Letter - (Using Cursors Demo-3) online, duration hours minute second in high quality that is uploaded to the channel Dr. Parag Shukla 04 September 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 385 times and liked it 13 visitors.
