I am writing a store procedure , which generates reports for every fiscal quarter.
I am passing YEAR as input argument -- input_arg_year , and we have start and end ( day and months for fiscal quarters as constants)
now my question is how can i append start and end dates with the year( input_arg_year) to form a valid date. which can be used further in my store proc, for report generation.
Ex: Jan1st is quarter start date and input arg is 2008
date = 01012008 .......something like this
let me know, how can i append and convert the string into a valid date.
give an example , so that can understand easily , i am a naive developer ( basically asp.net developer)
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY.
Actually there are lot of other tools available in the market for Reporting
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…