
Last seen: Jul 10, 2022
PLSQL procedure to display the product information for the given product id. declare vprodid prod_dtls.prod_code%type; p_rec prod_dtls%rowty...
You can try this PLSQL procedure to display the information of employee for the given employee id declare --Dynamic declaration of variable ven...
You may try the below PLSQL procedure to display customer account details for the given customer name. declare vcname varchar2(20); vactno numbe...
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...
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 ...
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...
Here is an example, I have attached the image for our better understanding. Hope this will also helful SQL Joins With Practical Examples. J...
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) 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...
I got this select trunc(trunc(sysdate,'MM')-1,'MM') AS FIRSTDAYLASTMONTH, trunc(sysdate,'MM')- 1/(24*60*60) AS ENDOFLASTDAYLASTMONTH, ...
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...
Create a PL/SQL Trigger to display the message "Re-Order Level reached for the item-item name", whenever an item quantity reaches 10 and below while u...
Check this article to know how to delete duplicate records in a table.