Forum

KV Kumar
KV Kumar
Admin
Eminent Member
Joined: Jul 5, 2019
Last seen: Jul 10, 2022
Topics: 0 / Replies: 27
Reply
RE: Write a PLSQL Program to Display Product Information for the Given Product ID

PLSQL procedure to display the product information for the given product id. declare vprodid prod_dtls.prod_code%type; p_rec prod_dtls%rowty...

1 year ago
Reply
RE: PLSQL Program Display EMPLOYEE Information for The Given Employee ID

You can try this PLSQL procedure to display the information of employee for the given employee id declare --Dynamic declaration of variable ven...

1 year ago
Reply
RE: Write a PLSQL Program to display customer account details for the given customer name

You may try the below PLSQL procedure to display customer account details for the given customer name. declare vcname varchar2(20); vactno numbe...

1 year ago
Reply
RE: SQL The Resort Manager wants to see the review comments given by the customer.

I hope the below query will help. Query: The resort manager wants to see the review comments given by the customer. select gst.name, rsrt.resort...

1 year ago
Reply
RE: Write a query to display all the town names which have summer temperature more than jaipur. Output should be sorted on the town name.

Consider the table called the town and it has two columns like town name and summer temperature then our query would be something as below. Alias ...

1 year ago
Reply
RE: Write a query to display the course name registered by at least two students. Sort the resultsbased on Course name.

Hi Rahul, I hope this query will give you the expected output. Please check and let me know Select a.CourseName,b.FirstName,c.Count(CourseID)Fro...

1 year ago
Reply
RE: Can we join view with table in oracle?

Here is an example, I have attached the image for our better understanding. Hope this will also helful SQL Joins With Practical Examples.  J...

1 year ago
Reply
RE: What is mean by SQL and what are the uses of SQL?

You can see the attached picture to understand the importance of SQL. For more information, you can also check The importance of SQL and the Technol...

1 year ago
Reply
RE: How to Write a PLSQL block to print the list of employee names?

1) Write a PLSQL block to print the list of employee names I am going to show you the 3 different ways by which you can print the name from the empl...

1 year ago
Reply
RE: How do I create a table for all reporting objects using system date?

I got this select trunc(trunc(sysdate,'MM')-1,'MM') AS FIRSTDAYLASTMONTH, trunc(sysdate,'MM')- 1/(24*60*60) AS ENDOFLASTDAYLASTMONTH, ...

1 year ago
Reply
RE: Create a PL/SQL Function to calculate increment for the employees. Function will take increment percentage and salary as input and return increment amount as output.

Hey, try this function it worked for me. SQL> create or replace function calculate_emp_salary_increment 2 (incpercent in number, 3 salary in n...

2 years ago
Reply
RE: How to Delete Duplicate Records From Country Table?

Check this article to know how to delete duplicate records in a table.

2 years ago
Page 1 / 2