Forum

Rahul Updhyay
@rahul
Forum Home   |   Recent Posts
Active Member
Joined: Aug 8, 2020
Last seen: Jan 14, 2026
Profile Activity
Topics: 12 / Replies: 5
AllTopicsReplies
Topic
How to Write a PL/SQL Package with Procedure in it. Procedure will take designation and incentive as input and update the employee salary by adding the incentive for the given designation. Display the number of employee records that have got updated
6 years ago
Forum
Other Documents
Replies: 2
Views: 5676
Topic
SQL Query to DELETE Rows From the Employee Table and Raise Exception
6 years ago
Forum
Other Documents
Replies: 0
Views: 3084
Topic
Write 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.
6 years ago
Forum
Other Documents
Replies: 3
Views: 7232
Topic
Write a PL/SQL Procedure to insert employee details into the Employee table. Before inserting, check whether the employee's age is eligible or not.
6 years ago
Forum
Other Documents
Replies: 1
Views: 3762
Topic
Write a sql query resort located In jaipur display the resort name and the manager Name
6 years ago
Forum
Other Documents
Replies: 1
Views: 1976
Topic
Write a query to display all the town names which have summer temperatures more than jaipur
6 years ago
Forum
Other Documents
Replies: 2
Views: 5101
Topic
Write a query to display the guest id and guest name who has charged the highest amount in the resort. sort the output on the guest id.
6 years ago
Forum
Other Documents
Replies: 3
Views: 3675
Topic
Write a query to display the Cabin ID, Cabin Type, Cabin Description and The Number or Bedroom
6 years ago
Forum
Other Documents
Replies: 1
Views: 1528
Topic
The Resort Manager Wants to See the Review Comments Given by the Customer.
6 years ago
Forum
Other Documents
Replies: 2
Views: 2154
Topic
SQL Query Review Comments Shared by the Guest in SQL
6 years ago
Forum
Other Documents
Replies: 1
Views: 9269
Topic
SQL Query to display BOOKING and the PAYMENT made y the Guest
6 years ago
Forum
Other Documents
Replies: 1
Views: 2221
Topic
Write a Query to Display the Course Name Registered by at least two Students. Sort the results based on Course Name.
6 years ago
Forum
Other Documents
Replies: 1
Views: 5426
Reply
RE: Write a PL/SQL procedure to perform withdraw operation that only permits a withdrawal, if there is sufficient funds in the account then update the Account table and print the message, 'Transaction successful.' else print, 'Insufficient Amount'. T...

@Sambit S only 1 test case is passed  Screenshot-35.png

6 years ago
Forum
Interview Questions & Answers
Reply
RE: Create a program that copies the departments located in 'CBE' to a table called 'DEPARTMENT_CBE. Do not use a cursor FOR loop. Display how many rows where copied else display the message 'No Records found'.

@Sambit S sir it worked but output is different i want Record(s) got find one  but is giving no record found  Screenshot-34.png

6 years ago
Forum
Interview Questions & Answers
Reply
RE: Create a program that copies the departments located in 'CBE' to a table called 'DEPARTMENT_CBE. Do not use a cursor FOR loop. Display how many rows where copied else display the message 'No Records found'.

sir getting this error after compilation  Screenshot-30.png

6 years ago
Forum
Interview Questions & Answers
Page 1 / 2