Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Get ID Where each value of Flag Field is 1 for that ID

478924Dec 26 2005 — edited Dec 30 2005
I have a table in the following form


ID Flag
1 1
1 1
1 0
2 1
2 1


I have to write a query that will return the ID Whose All Flags Values are 1. i.e if i run the query on the above table it must return 2.
If there is Flag for a specific ID equal to 0 it must return empty.

Please Help me.

Regards,

Ahmad Jalil Qarshi

Comments

Holly DeBaeke

Hi, Ken,

You can use JavaFx by 2 means.

A - Include the jars in the Java Build Path.  I've not been successful with this one, so, let me give you the second means.

B - Install the JavaFx plug-in for eclipse.  These are my notes as I worked through it.  Let me know if anything doesn't make sense.

  1. With Eclipse open, click Help > Install New Software…
  2. Click the Add… button.
  3. Enter a name, such as JavaFX.
  4. Enter the location as follows:  http://download.eclipse.org/efxclipse/updates-released/1.2.0/site/
  5. Check both options “e(fx)clipse – install” and “e(fx)clipse – single components” as shown.  Accept other defaults.  Click the Next button.
  6. These are the items that will be installed.  Click Next again.
  7. Accept terms and click Finish.

You’ll be prompted to reboot Eclipse.  The plug-in is now installed and is ready to use.

Now, to use JavaFx...

  1. Navigate to File > New > Project
  2. In the New Project wizard, select JavaFx > JavaFX Project
  3. Enter a name for the project, ie, JavaFxDemo, etc.  Click Finish.
  4. Go to the project name > src > application.  Click once on application to highlight.  Create classes here (right-mouse click, New > Class)

Hope this helps,

Holly

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 27 2006
Added on Dec 26 2005
20 comments
3,350 views