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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

4. Using a set operator, display the creditor number of all
creditors who have ever been paid.

Question Posted / srinivas

Answer Posted / srinivas

select credit_number from table where paid <> 1

[NOTE: Here we can use boolean value to paid field, if paid is success 1 inserted and if not paid then insert 0].

From above query , there is displays credit numbers with never paid.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is rowid unique in oracle?

999

Explain about integrity constraint?

1125

How to check the server version in oracle?

1093

Explain about the analyze command in oracle?

1053

Can we save images in a database and if yes, how?

1065

what is the difference between restoring and recovering?

1011

How to see the table columns used in an index?

1024

What is catalog in Oracle?

1367

How different is ms access and oracle?

1040

What is program global area (pga) in oracle?

1030

What to do if dba lost the system password?

1172

What are the differences between char and nchar in oracle?

1096

What is a subquery in oracle?

1110

How to use windows user to connect to the server?

990

How to create a table index in oracle?

1134