Home » SQL & PL/SQL » SQL & PL/SQL » Oracle Sql statements (R12)
Oracle Sql statements [message #684087] Mon, 05 April 2021 08:43 Go to next message
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 Go to previous message
EdStevens
Messages: 1376
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.
Previous Topic: Query PL/SQL Urgent
Next Topic: Display zero if negative value.
Goto Forum:
  


Current Time: Thu Mar 28 06:33:48 CDT 2024