Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

display null value rows with out using null function?

Answer Posted / nilesh patil

select * from table_name where nvl(column_name,'#')='#';

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mutating error in pl sql?

1020


How can you view the errors encountered in a trigger?

962


How do you get column names only for a table (sql server)?

1166


What is the importance of sqlcode and sqlerrm?

1356


how many sql ddl commands are supported by 'mysql'? : Sql dba

1023


How can I speed up sql query?

963


Are sql connections encrypted?

1029


What is consistency?

1126


How do I delete a trigger?

967


how to create a new table by selecting rows from another table in mysql? : Sql dba

1107


What is difference between pl and sql?

1063


What is left join in postgresql?

1047


What is the difference between nvl function, ifnull function, and isnull function?

1113


How does one use sql*loader to load images, sound clips and documents? : aql loader

1187


What is the use of <> sql?

980