Lets do some mathematics!!
We need to calculate factorial of numbers (say from 1 to 10). One of the useful queries can be as follows:
SELECT
rownum,
EXP(SUM(LN(rownum)) OVER (ORDER BY ROWNUM)) Factorial
FROM all_objects
WHERE rownum < 10
(Note : This query was given to me by my friend and mentor Mr. Bucchibabu).
I hope it helps in some way or other!!
To TLS or to NNE? Postquantum hints the former
-
When encrypting Network traffic to your database server, there are two
different approaches. One is to use Oracle Native Encryption by setting
SQLNET.ENCRY...
1 week ago
No comments:
Post a Comment