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 :

4 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