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

Pages

» » Query to Get DB Parameters

Thursday, 16 June 2016

Query to Get DB Parameters

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

4 comments:

  1. preethi Sharma3 May 2018 at 04:37

    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. Radhey Radhey17 June 2018 at 21:51

    This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Radhey Radhey17 June 2018 at 21:53

      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. preethi Sharma19 June 2018 at 03:10

    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

Subscribe to: Post Comments (Atom)