Notifications

Clear all

Write a PL SQL to count the locations, where the various departments are located and print the number.

Last Post

RSS

Posts: 1

Rahul U

Guest

Topic starter

Aug 09, 2020 6:12 am

(@Rahul U)

New Member

Joined: 4 years ago

Please check the attachment for additional information.

Count-the-number-of-locations-procedure.jpg

Topic Tags

procedurecountnumberofloc

3 Replies

Posts: 47

Sambit S

Guest

Aug 09, 2020 6:28 am

(@Sambit S)

Eminent Member

Joined: 4 years ago

Write a PL SQL to count the locations, where the various departments are located and print the number.

Try this one.

To count the locations, where the various departments are located and to print the number.

Declare
V_cnt number:=0;
Begin
Select count(distinct loc_id) into v_cnt
From department;

Dbms_output.put_line('Number of location are '||v_cnt);

End;

Count-the-Number-Of-Locations-Procedure.PNG

This post was modified 3 years ago by SQL Admin

Posts: 17

Rahul Updhyay

Aug 09, 2020 7:52 am

(@rahul)

Active Member

Joined: 4 years ago

getting this error

Cout-Locations-SQL-Results.PNG

This post was modified 3 years ago by SQL Admin

1 Reply

Sandesh Kulkarni

(@sandeshk)

Joined: 3 years ago

New Member

Posts: 1

May 20, 2021 4:52 pm

Reply to

Rahul Updhyay

@rahul can I please get the exact query for that.

This post was modified 3 years ago by Sandesh Kulkarni