Discover
Questions library
Collections library
Find online teacher
login
Discover
questions library
Find online teacher
login
Popular searches:
if-else
class-diagram
flowchart
Polymorphism
Home
Questions
Questions
Study lists
hamza shaheen Questions
5601 Questions
Write a PL/SQL block to show the uses of a variable in explicit cursor query, and no result set is affected despite that value of the variable is incremented after every fetch
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
120
Write a PL/SQL block to display department name, head of the department,city, and employee with highest salary. Display name, city, hod, emp with highest salary
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
124
Write a PL/SQL block to display the department name, name of the manager, number of employees in each department, and number of employees listed in job_history
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
111
Write a block in PL/SQL to displays employee name and number of jobs he or she done at past
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
206
Write a block in PL/SQL to display the name of department and their head
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
120
Write a PL/SQL program to display the name of the employee and increment percentage of salary according to their working experiences
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
160
Write a PL/SQL block to show the uses of a virtual column in an explicit cursor query
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
134
Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
172
Write a PL/SQL procedure to calculate the incentive achieved according to the specific sale limit
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
118
Write a PL/SQL program to count the number of employees in department 50 and check whether this department have any vacancies or not. There are 45 vacancies in this department
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
135
Write a PL/SQL program to count the number of employees in a specific department and check whether this department have any vacancies or not. If any vacancies, how many vacancies are in that department
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
143
Write a PL/SQL program to display the description against a grade using CASE statement
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
122
Write a PL/SQL program to display the description against a grade using CASE statement with EXCEPTION
pl/sql
2022-05-18
Answers
30
Question
40
Followers
30
0
1
135
Total:
5601
Previous
79
80
81
82
83
Next
Go