Friday, 3 October 2014

Converting month number to month name

Step 1: Create Table

create table student(name varchar2(15),age number,month_joining VARCHAR2(20));

Step 2: Procedure

create PROCEDURE studentdetail(id1 VARCHAR2,id2 number,id3 number)
as
begin
insert into STUDENT(name,age,month_joining)VALUES(id1,id2,(SELECT TO_CHAR(TO_DATE(id3, 'MM'), 'MONTH') FROM DUAL));
end studentdetail;

Step3 : Execute

EXECUTE STUDENTDETAIL('aadesh',19,2);
EXECUTE STUDENTDETAIL('aagnya',21,1);
EXECUTE STUDENTDETAIL('ddarun',20,4);

Step 4: Select the table

SELECT * FROM STUDENT;

Step 5: Output