Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Thursday, 16 June 2016

Query to Get DB Parameters

SELECT a.name "Parameter"
,      a.value "Name"
FROM   v$parameter a
ORDER BY a.name
Share this article :

5 comments:

  1. Hi there,

    I’ve often thought about this Query to Get DB Parameters. Nice to have it laid out so clearly. Great eye opener.

    I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So, if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be beginning to show 3-11-16. Is that possible?

    Appreciate your effort for making such useful blogs and helping the community.

    Obrigado,
    Preethi

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Merhaba,


      I’ve often thought about this Query to Get DB Parameters. Nice to have it laid out so clearly. Great eye opener.

      I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So, if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be beginning to show 3-11-16. Is that possible?


      Appreciate your effort for making such useful blogs and helping the community.


      Obrigado,
      Radhey

      Delete
  3. Hi there,

    I’ve often thought about this Query to Get DB Parameters. Nice to have it laid out so clearly. Great eye opener.

    I'm trying to set up a reminder. It needs to remind users of a reassessment date that occurs every 90 days based upon the first contact (enrollment_date) with a potential client. But I only need to show the closest upcoming date. So, if a client's next closest assessment date is 12-12-15 it would show that date until 12-13-15 when it would be beginning to show 3-11-16. Is that possible?

    Appreciate your effort for making such useful blogs and helping the community.

    Obrigado,
    Preethi

    ReplyDelete
  4. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete