Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Getting max date from min date

DipNov 28 2007 — edited Nov 28 2007
Hello.

We have a problem with getting max values out of min values.

Example (table):
date.....................type
27.11.07 06:00........1
27.11.07 10:00........2
27.11.07 10:00........1
27.11.07 10:30........2
27.11.07 10:45........1
27.11.07 15:00........2

Max value is max time with type 1. In this case, max is at time 10:45.
Min value is max time with type 2, which must be smaller than max time with type 1.

So we have 10:45, which is good. And we need 10:30.
But we get two values for min. That is 10:00 and 10:30.

How can we solve that?

Thanks.

Comments

504680
Hi Sudhan

This guide's help's you:

[http://download-west.oracle.com/docs/cd/B32110_01/web.1013/b25947/appendixa.htm#BABHDAHA]

[http://download-west.oracle.com/docs/cd/B32110_01/web.1013/b25947/web_laf.htm#CACIBGBA]

Good Luck
See if this how-to helps:
http://www.oracle.com/global/il/support/tip/nlss11061.html
260010
Hello, Sudhan. Although the document nlss11061.html is for ADF 10g, I hope it can be useful. Please, try it and let me know which issues are still opened.
689305
Thank's for ur replies...
I got the solution..
i need another solution, How to make the browser to understand the arabic language.
when i run my application, the text appears as question marks,(?).
Can u help me out.
260010
Is you text coming from Database? Which charset do you use in your JSP(X) file? Question marks normally are not displayed if charset is UTF-8. Which character set do you have in the Database?

Edited by: ygauchma on Mar 7, 2009 12:36 PM
689305
ygauchma, thank's for ur response.
i'm not retriving the text from database, it is just a text from the UI.
I have changed the charset aslo to UTF-8...
Still it is not displaying in arabic, instead it is displaying wit ?? marks..
John Stegeman
User,

Do you have fonts installed on your computer that have the Arabic characters in them?

John
260010
If text comes from UI, is it hardcoded, resource bundled or Java generated? Where did you set UTF-8? Check your current page encoding in the Browser. For IE it is View -> Encoding. What is it?
689305
i have hardcoded in the resource bundle it self....
in jsp page i have changed the charset to UTf-8 in the view tag......
Alexandar
1. Check if your browser encoding (FF/IE) is UTF-8/Unicode.
2. If your resource bundles are .properties files and they aren't created as UTF-8 encoding then:
- open ti with notepad and save it as UTF-8 (use appropriate text editor for nonwindows OS),
- open it again in JDev and see if everything is OK (usually at beginning of file appears some "blank" character - delete it),
- clean your application and start it again.
1 person found this helpful
689305
The Browser is set to Unicode....
I'm using the resourcebunbles as properties file.
wat all should i have to change..
still my problem is not solved..
260010
Answer
If you have ??? on the Browser, the data was corrupted in Java level. Can you convert your properties Arabic files using native2ascii conversion tool from $JDK_HOME/jdk/bin directory. It should convert all Arabic characters to the unicode format like \u...
So, the main idea you should not see any Arabic character in readble format, but in the Unicode one instead of.
Marked as Answer by 689305 · Sep 27 2020
689305
Ya that is correct, now it is working fine,,,,
In the resource bundle file the arabic should be used as unicode's.....
now i can able to see them in the browser.....

Thank you my friends,
Support me through the entire application i'm working...
1 - 13
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 26 2007
Added on Nov 28 2007
6 comments
8,574 views