Oracle Sql statements [message #684087] |
Mon, 05 April 2021 08:43  |
 |
Andrescr5
Messages: 1 Registered: April 2021
|
Junior Member |
|
|
Hi,
I am creating a request set program with mĂșltiple programas including the payable posted ones. I would like to know if there is an Sql statement to bring me the current open period for the parameters, example: Apr-21
Thanks in advance.
|
|
|
Re: Oracle Sql statements [message #684090 is a reply to message #684087] |
Mon, 05 April 2021 11:41  |
 |
EdStevens
Messages: 1375 Registered: September 2013
|
Senior Member |
|
|
Can you write a query when you don't know anything about the tables and data?
(tap, tap, tap ............)
Neither can anyone else.
Please provide DDL (as formatted text, not an image) to create your tables, and INSERT statements to create representative test data, a description or example of desired output, and description of the business logic by which the desired output is derived from the sample data.
|
|
|