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...

If there are 1 to 100 numbers in a table and in that 100
numbers some 10 numbers are deleted.I want to find out the
missing numbers between 1 to 100 by pl/sql how?

Answer Posted / sureshramsing@gmail.com

select level from dual connect by level<=100 minus select <column name> from <table name>;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ms sql is free?

955


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

945


What does stand for in sql?

916


What is the difference between local and global temporary table?

987


How do I view tables in mysql?

914


How does cross join work?

874


What is bitemporal narrowing?

1231


what is a table in a database ? : Sql dba

989


Which certification is best for sql?

937


Define a temp table?

965


What do you mean by “trigger” in sql?

1015


How do you change a value in sql?

965


How many types of tables are there?

900


What are the types of dbms?

920


Is sql database free?

923