I'm trying to write a PLSQL query that will in two separate columns print random integers.
It will print 1000 numbers total (random 1 - 50 in each row).
What I need to figure out is how I after this has been done, replace the second column with either "yes" or "no" if it matches the first column
Such as:

```
Col A    Col B
 10      NO(42)
 32      NO(12)
 25      YES(25)

```

And so on.
This is my code:

```
CREATE TABLE table

   (random_num INTEGER NOT NULL,
    match INTEGER NOT NULL);

Declare

CURSOR cur_ IS 
(Select 

random_num,
match 
from table);

Begin 

FOR rec_ IN 1..1000 

  LOOP    

 INSERT INTO "table" (random_num,match) VALUES (DBMS_RANDOM.VALUE(1,50),DBMS_RANDOM.VALUE(1,50));

  END LOOP;

  END;

```

Now this works as I get two 1000 rows of each column with random numbers, but I need to implement this select:

```
SELECT random_num, CASE WHEN random_num = match THEN 'yes' ELSE 'no' END as match
FROM table

```

Into the loop so. Any takers on how I can do?