Home » SQL & PL/SQL » SQL & PL/SQL » filter oder record on tacle (merged 3)
filter oder record on tacle (merged 3) [message #381569] Sun, 18 January 2009 10:59 Go to next message
haibec
Messages: 1
Registered: January 2009
Junior Member
Hi all!

I have table USERS include fileds

ID, USERID, PRODUCT_ID

Now , I want promotion for product have code (PRODUCT_ID = 26). When user insert into table are order number 100,200,300 i will view name that user. Plase help me SELECT statement for this problem.


Thank
Re: filter oder record on tacle (merged 3) [message #381573 is a reply to message #381569] Sun, 18 January 2009 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Don't multipost your question
2/ Your question is not understandable. For instance, what does this mean " I want promotion for product have code"?
3/ Post a Test case: create table and insert statements along with the result you want with these data.
4/ Also always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Sun, 18 January 2009 11:28]

Report message to a moderator

Re: filter oder record on tacle (merged 3) [message #381574 is a reply to message #381569] Sun, 18 January 2009 11:28 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You have table & provided us no DDL for it.
You have data & provided us no DML for test data.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

You have not shown us via CUT & PASTE what you actually did or how Oracle responded.

You have not provided any expected output.
Previous Topic: update record using Trigger from the same table during insertion
Next Topic: Primary key vs foreing key
Goto Forum:
  


Current Time: Wed Dec 07 12:44:21 CST 2016

Total time taken to generate the page: 0.15958 seconds