Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Pascal's triangle or binomial coefficients

146850Nov 14 2005 — edited May 3 2008
<font color="red">you know Pascal's triangle like below.</font>

1
11
121
1331
14641
...
...

my question is to find out a query giving nth sequence,
that is to say,

when n=1, that query yields
1

when n=2
1
1

when n=3
1
2
1

when n=4
1
3
3
1

...
...

(oh, but you have NOT to use any subqueries)


for more SQL problems & questions, please visit
http://cafe.daum.net/oraclesqltuning

Comments

843830
oops,
http://forum.java.sun.com/thread.jsp?forum=43&thread=248736
same topic
843830
anyway
assumption: we have a list of delivery failures
-> message.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);
-> and report-type=delivery-status (Content-Type)

any comments ?
843830
i think i found something
-> Final-Recipient (http://www.ietf.org/rfc/rfc1891.txt)

i will test it and post if it works..
843830
Should the notify failure send by the sender's SMTP server or the Recipent's server?
If it is sent by the Recipent's server, we have no control of the delivery status notification's format?

Thanks!
843830
If it is sent by the Recipent's server, we have no control of the delivery status notification's format?
if you set a notify-option (FAILURE,SUCCESS,NEVER,..) the recipient's server must answer with a RFC 1891 DSN ( if RFC 1891 is supported by the server)

??

(just a theory)
843830
Hi, Starzer, thank you!

In one of your previous messages, you said the following can be used:
-> message.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);
-> and report-type=delivery-status (Content-Type)

What is the object type of the message? I could not find the function setNotifyOptions() :(..

By the way, I am thinking of writing my own ESMTP server too. How long do you think it will take for a java programmer? (Only implements the simple sending out functions and bounce back notifications). Any suggestions for where to start and sample code?

Thanks a lot!
843830
-> com.sun.mail.smtp.SMTPMessage

we have built a small smtp server which is able to receive emails (just implement a few smtp commands)

there are some implementations (with source) somewhere (-> google )
843830
Hi,
I have the problem that I don't receive any faliure notification even though I have

SMTPMessage.setNotifyOptions(SMTPMessage.NOTIFY_FAILURE);

Any idea why ? I tried to send an email to a non existing address like tyty@cox.net

If I use my outlook to send a message to this address, I get a message
Your message did not reach some or all of the intended recipients.

Subject:
Sent: 3/21/2003 3:41 PM

The following recipient(s) could not be reached:

'tyty@cox.net' on 3/21/2003 3:41 PM
The recipient name is not recognized
The MTS-ID of the original message is: c=US;a= ;p=NRTC;l=EXCHANGE-030321204040Z-155810
MSEXCH:IMS:NRTC:NRTC1:EXCHANGE 3550 (000B09AA) 550 Invalid recipient: <tyty@cox.net>

Why don't I receive a similar message when I send the email through javamail ?

Thanks

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

Post Details

Locked on May 31 2008
Added on Nov 14 2005
29 comments
8,891 views