> regy1'> output_rec := user_rec;
Here you can't assign the entire record (user_rec) into a variable. You
can assign either one of the following.
1. output_rec := user_rec.fname;
2. output_rec := user_rec.lname;
3. output_rec := user_rec.fname || user_rec.lname (This will concantenate
the two f
Dear Friends,
I created a table with no 'unique constraints' which is depicted as
follows.
create table junk (id int, name varchar);
Then, i inserted some records into the table. My table contents is listed
below.
id | name
-+--
1001.00 | bolt
1002.00 | nut
