Question

Create a function called ami1() that queries and displays the contents of the artist table

Ï postgres.localhost Chinook System Schemas 1 I public 1 Tables (11) 3 album artist 1 Columns (2) 99 artistid integer 8 name character varying Constraints Indexes Triggers Rules customer employee ► genre invoice invoiceline mediatype playlist playlisttrack track Views Materialized Views Procedures Functions Trigger Functions Sequences Data Types Domains Event Triggers

Answer 1

/*drop table if already created */

drop table artist;

Create New

create table artist(artistID number(5) primary key,name varchar(20));
desc artist;
insert into artist values(101,'Viral');
insert into artist values(102,'Rajgor');
insert into artist values(103,'Poonam');
insert into artist values(104,'Navin');
Select * from artist;

Run SOL Command Line SQL> creale Lable arlislar LisLID number (5) primary key,niame varchar(20)); Table created. SQL> desc artist; Nane Null? Type ARTISTID NAME NOT NULL NUMBER(5) VARCHAR2(28) SQL> insert into artist values(101, 'viral'); 1 ron created. SQL> insert into artist values(162, 'Rajgor); Table Defination 1 row created. SQL> insert into artist values (183, 'Poonam'); 1 row created. SQL> insert into artist values (104, 'Navin'); 1 ron created. SQL> Select * from artist; ARTISTID NAME 101 viral 102 Rajeor 102 Poon 184 Navin SQL>- Data of Table

Function

CREATE OR REPLACE FUNCTION amit1 RETURN BOOLEAN
IS
BEGIN
dbms_output.put_line('||Artist||Name||');
dbms_output.put_line('_________________');
FOR v_rec IN (SELECT artistID, name FROM artist) LOOP   
dbms_output.put_line('||'||v_rec.artistID || '||' || v_rec.name||'||');
END LOOP;
RETURN TRUE;
END;

Run SQL Command Line Procedure dropped. SQL> CREATE OR REPLACE FUNCTION amit1 RETURN BOOLEAN 2 IS 3 BEGIN 4 dbms_output.put_line('||Artist||Name"); dbms_output.put_line('. FOR v rec IN (SELECT artistID, name FROM artist) LOOP, dbms_output.put_line('Il'llv_rec.artistID | IT || v_rec.name END LOOP; 9 RETURN TRUE; 10 END; 11 T I'); Function created. We can see function created SQL>

Calling Code

DECLARE
answer BOOLEAN;
BEGIN
answer := amit2();
END;

/

Run SOL Command Line SQL> DECLARE 2 answer ROOI FAN; 3 BEGIN 4 answer := amit2(); 5 END; || Artist||Nane|| ||181||Viral 11102||Rajgor!! ||10||Poonan || ||184||Navin PL/SQL procedure successfully completed. SQL). we can see the output here

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........