write a stored procedure for following eg::

Question

i have the backend table like

countryid countryname state

11india ap

12aus sydny

13pak

so when i give the countrynam 'pak' state column display null value but i want display some text msg instead of null pls write the program for that in stored procedure in plsql only

countryname: pak statename:

i want result like that countryname: pak statename:there is not states

Hemant Srivastava · Answer

CREATE PROCEDURE [dbo].[usp_GetComplteteRecord] @countryid varchar(50) -- CountryId as an input AS BEGIN SELECT [countryid] [countryname]  ISNULL([state]'NOT AVAILABLE') FROM [CountryRecordTable] WHERE [countryid] = @countryid END

Sukesh Marla · Answer

CREATE PROCEDURE SprGetCountriesWithStates AS BEGIN Select countryidcountryname ISNULL(state'there is not states') from TblCountry END Hope It Helped. Please Check This is Currect Answer.