How To Use The Select Statement To Display No Null Values
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.
exit when a>10;
INSERT INTO CUSTOMER ("@id","Mnemonic","Gb Short Name","Gb Name 1","Gb Street","Sector") VALUES ("@id",Mnemonic,'ratheesh','name','anna nagar','1001');
i agree with the others.. first, tell us why you want no nulls? nulls are very important.. its like saying "I only want to breathe oxygen, i dont have any use for the 78% nitrogen in the air that I breathe, can someone tell me how you remove it, so I dont have to breathe it?"