HI,

IAM A NEWBIE TO PL/SQL.i have created a table with 50 fields.in which i have inserted values in 5 fields.what i need is if iam going to select the record with some condidtion it should not display all the records only the fields with value should be displayed.
i have pasted my script.pls check out and tell me.

declare
a number:=1;
Mnemonic number;
"@id" number;
BEGIN
loop
exit when a>10;
a :=a+1;
"@id" :=1001+a;
Mnemonic:=111+a;

INSERT INTO CUSTOMER ("@id","Mnemonic","Gb Short Name","Gb Name 1","Gb Street","Sector") VALUES ("@id",Mnemonic,'ratheesh','name','anna nagar','1001');
commit;
END LOOP;
END;

pls help me out..