Skip to main content

Posts

Showing posts from July, 2019

How to Create And Excute Function With Refcursor in Postgresql

How to Create And Execute Function With Refcursor in Postgresql Create Two Tables create table EmployeeDetails (EmployeeId serial primary key,FirstName varchar(60), LastName varchar(60),Place varchar(100),Country varchar(40),PhoneNo varchar(40),password varchar(100)); create table RoomDetails (RoomId serial primary key ,RoomName varchar(100),RoomSize varchar(20)) Insert Values Insert into RoomDetails(RoomName,RoomSize) values('Abdul kalam','10'), ('aryabhata','15'), ('Nasa','20'), ('vivekananda','10'), ('Rohini','5'); insert into EmployeeDetails(FirstName,LastName,Place,Country,PhoneNo,password) values('Vasanth', 'R','SGRI', 'India','8056512886','hello'), ('Ram', 'S', 'SGRI', 'India', '9366180976','hello'), ('Ravi', 'E', 'SGRI','India', '12345678...