Here is the PL/SQL procedure that you requested:

```sql
CREATE OR REPLACE PROCEDURE displayTeamStrength (teamid IN NUMBER) IS
total_players NUMBER;
total_batsmen NUMBER;
BEGIN
SELECT COUNT(*) INTO total_players FROM players WHERE team_id = teamid;

SELECT COUNT(*) INTO total_batsmen FROM players WHERE team_id = teamid AND skill = 'Batsmen';

DBMS_OUTPUT.PUT_LINE('Team Strength');
DBMS_OUTPUT.PUT_LINE('------------------------');
DBMS_OUTPUT.PUT_LINE('NUMBER of PLAYERS : ' || total_players);
DBMS_OUTPUT.PUT_LINE('NUMBER of BATSMEN : ' || total_batsmen);

EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('No Such Team');
END displayTeamStrength;
/
```

This procedure will first try to count the total number of players in the team with the given `teamid`. Then it will count the number of players in the same team who have the skill 'Batsmen'. If the `teamid` does not exist in the `players` table, the SELECT statements will not return any rows, causing a `NO_DATA_FOUND` exception to be raised. In this case, the procedure will catch the exception and output 'No Such Team'.

Question

Here is the PL/SQL procedure that you requested:

```sql
CREATE OR REPLACE PROCEDURE displayTeamStrength (teamid IN NUMBER) IS
  total_players NUMBER;
  total_batsmen NUMBER;
BEGIN
  SELECT COUNT(*) INTO total_players FROM players WHERE team_id = teamid;
  
  SELECT COUNT(*) INTO total_batsmen FROM players WHERE team_id = teamid AND skill = 'Batsmen';
  
  DBMS_OUTPUT.PUT_LINE('Team Strength');
  DBMS_OUTPUT.PUT_LINE('------------------------');
  DBMS_OUTPUT.PUT_LINE('NUMBER of PLAYERS : ' || total_players);
  DBMS_OUTPUT.PUT_LINE('NUMBER of BATSMEN : ' || total_batsmen);
  
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE('No Such Team');
END displayTeamStrength;
/
```

This procedure will first try to count the total number of players in the team with the given `teamid`. Then it will count the number of players in the same team who have the skill 'Batsmen'. If the `teamid` does not exist in the `players` table, the SELECT statements will not return any rows, causing a `NO_DATA_FOUND` exception to be raised. In this case, the procedure will catch the exception and output 'No Such Team'.

Knowee AI · Accepted Answer

Here is the PL/SQL procedure that you requested:

```sql
CREATE OR REPLACE PROCEDURE displayTeamStrength (teamid IN NUMBER) IS
  total_players NUMBER;
  total_batsmen NUMBER;
BEGIN
  SELECT COUNT(*) INTO total_players FROM players WHERE team_id = teamid;
  
  SELECT COUNT(*) INTO total_batsmen FROM players WHERE team_id = teamid AND skill = 'Batsmen';
  
  DBMS_OUTPUT.PUT_LINE('Team Strength');
  DBMS_OUTPUT.PUT_LINE('------------------------');
  DBMS_OUTPUT.PUT_LINE('NUMBER of PLAYERS : ' || total_players);
  DBMS_OUTPUT.PUT_LINE('NUMBER of BATSMEN : ' || total_batsmen);
  
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE('No Such Team');
END displayTeamStrength;
/
```

This procedure will first try to count the total number of players in the team with the given `teamid`. Then it will count the number of players in the same team who have the skill 'Batsmen'. If the `teamid` does not exist in the `players` table, the SELECT statements will not return any rows, causing a `NO_DATA_FOUND` exception to be raised. In this case, the procedure will catch the exception and output 'No Such Team'.

Question

Solution 1

Solution 2

Similar Questions

Upgrade your grade with Knowee