Today's Messages (on)
| Unanswered Messages (off)
Forum: Forms
|
Topic: Problem calling a report from that have a chart
|
Re: Problem calling a report from that have a chart [message #689794 is a reply to message #689793] |
Wed, 24 April 2024 00:15 |
|
Littlefoot
Messages: 21808 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Forms 6i is an old piece of software. I suspect it has difficulties in working with folders whose names contains spaces, as well as some other characters different from letters and numbers (such as parenthesis you have).
I'd suggest you to rename "New folder (2)" to something else; if you can't find anything better than what Windows suggests, rename it to "new_folder_2". Then try again.
|
|
|
Re: Problem calling a report from that have a chart [message #689795 is a reply to message #689794] |
Wed, 24 April 2024 00:25 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You may also try using the old 8.3 name of the folder:
E:\>mkdir "New folder (2)"
E:\>dir /X N*
Le volume dans le lecteur E s'appelle Data
Le numéro de série du volume est 4A9F-7C49
Répertoire de E:\
24/04/2024 07:22 <REP> NEWFOL~1 New folder (2)
0 fichier(s) 0 octets
1 Rép(s) 7 216 553 984 octets libres
As you can see the new "New folder (2)" folder is also named "NEWFOL~1".
|
|
|
Forum: Server Administration
|
Topic: ALLOW_LEGACY_RECO_PROTOCOL
|
Re: ALLOW_LEGACY_RECO_PROTOCOL [message #689796 is a reply to message #689769] |
Wed, 24 April 2024 02:28 |
|
Alien
Messages: 292 Registered: June 1999
|
Senior Member |
|
|
Hi John,
You're probably right that it is another change. In the link, there is a reference to an update of the security. So probably it is not related to raft.
I think poor Ted has plenty reasons to be spinning- with null friction.
Regards,
Arian
|
|
|
Forum: SQL & PL/SQL
|
Topic: Convert input from user into UPPERCASE
|
Re: Convert input from user into UPPERCASE [message #689797 is a reply to message #689761] |
Wed, 24 April 2024 03:34 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Good morning - a bit late, I know, but I happened to come across your question while researching something similar.
It all comes down to the SQL Standard. I don't have the exact reference, but SQL-92 (I think it was 92) specified that lower case identifiers should be converted to upper case, unless double quoted. Oracle is 100% compliant with this: the SQL parser will do the conversion. Some other databases are different. For example, I think that SQL Server will preserve the case of unquoted identifiers when creating an object, but ignore it subsequently. Differences like that can cause bizarre problems when working in a heterogeneous environment.
|
|
|
Topic: Condition based truncate partition
|
|
Topic: Missing records
|
Missing records [message #689798] |
Wed, 24 April 2024 06:25 |
|
ace_friends22
Messages: 9 Registered: December 2023
|
Junior Member |
|
|
Hi All,
I'm working for a shipment company. We get voyage information. Below is requirement and I'm not able to find right solution for this.
- We get Voyage detail on daily basis and we load it into a target table
- There is a table called voyage master, which shows when voyage is discontinued.
- Even if Voyage is discontinued, we need to create dummy record and populate it in the separate table
- Later, we do UNION in the view to combine both tables to show details to users
- There is also challenges that sometimes, voyages gets discontinued and later re-start. In that scenario, we need to make sure process creates dummy records for days, it was discontinued and later start populating main target table when it re-start
The solution should be ro-bust to take care these thing.
Can someone help me with what logic I should put. Googled one is not solving both problems and Lead is expecting dummy record process to robust.
Please note, voyage start date could be different.
I hope, i'm clear with my doubt.
[Updated on: Wed, 24 April 2024 08:21] by Moderator Report message to a moderator
|
|
|
Missing records [message #689799 is a reply to message #689798] |
Wed, 24 April 2024 06:26 |
|
ace_friends22
Messages: 9 Registered: December 2023
|
Junior Member |
|
|
Hi All,
I'm working for a shipment company. We get voyage information. Below is requirement and I'm not able to find right solution for this.
- We get Voyage detail on daily basis and we load it into a target table
- There is a table called voyage master, which shows when voyage is discontinued.
- Even if Voyage is discontinued, we need to create dummy record and populate it in the separate table
- Later, we do UNION in the view to combine both tables to show details to users
- There is also challenges that sometimes, voyages gets discontinued and later re-start. In that scenario, we need to make sure process creates dummy records for days, it was discontinued and later start populating main target table when it re-start
The solution should be ro-bust to take care these thing.
Can someone help me with what logic I should put. Googled one is not solving both problems and Lead is expecting dummy record process to robust.
Please note, voyage start date could be different.
I hope, i'm clear with my doubt.
Source Data:
WITH SRC AS
(
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/05/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/04/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/06/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/05/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/07/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/06/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/08/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/07/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
--SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/09/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/08/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
--UNION
--SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/10/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/09/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
--UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/11/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/10/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/12/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/11/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/13/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/12/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/14/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/13/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/15/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/14/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
UNION
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/16/2024', 'MM/DD/YYYY') FILE_DATE, TO_DATE('04/15/2024', 'MM/DD/YYYY') DATA_DATE, '04/04/2024' SAIL_DATE
)
select * from src order by data_date
Voyage Master:
WITH VOYAGE_MSTR AS
(
SELECT '1234' VOYAGE, '2024' CAL_YEAR, TO_DATE('04/04/2024', 'MM/DD/YYYY') SAIL_DATE, TO_DATE('04/15/2024', 'MM/DD/YYYY') RETURN_DATE
)
In voyage master we can see ship started on 4/4/2024 and returned on 4/15/2024.
In the existing table (SRC) we can see, daily VOYAGE information is getting inserted, but somehow we missed entry on 8th and 9th.
Now we need to generate dummy records for 9th & 10th as well as from 4/16/2024 till date. Attachedis output, records marked with yello needs to be generatyed
-
Attachment: Output.PNG
(Size: 15.42KB, Downloaded 4 times)
[Updated on: Wed, 24 April 2024 08:16] Report message to a moderator
|
|
|
Re: Missing records [message #689800 is a reply to message #689798] |
Wed, 24 April 2024 08:31 |
|
Michel Cadot
Messages: 68645 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
From your previous topic:
Michel Cadot wrote on Wed, 27 December 2023 13:28
If you want to continue to get help feedback in your topics.
Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.
[Updated on: Wed, 24 April 2024 08:32] Report message to a moderator
|
|
|
|
Current Time: Wed Apr 24 20:56:07 CDT 2024
|