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.

SQL to exclude weekends and bank holidays

User581223Apr 7 2016 — edited Apr 11 2016

Hi, I have following SQL where I want to see CLEARING_DATE for each record for previous month and if the CLEARING_FLAG is not N then I need to add 2 days and see if the second days is not following weekends and bank holidays and produce the next working day to WHERE clause and SELECT statement.I have a static table which stores bank holidays in it example called HOLIDAYS_LIST.

SELECT BANK_ID, ACCOUNT_ID, CLEARING_DATE, CLEARING_COUNTRY_FLAG

FROM ACCOUNT

WHERE TO_CHAR(CASE WHEN CLEARING_COUNRTY_FLAG IS 'N' THEN CLEARING_DATE ELSE CLEARING_DATE+2) END,'MMYYYY') = TO_CHAR(ADD_MONTHS(TRUNC(SYSDATE)-1),'MMYYYY')

Can you please help how can I use the logic in above SQL without any procedure or function etc. only with the SQL. Could be very helpful if you could send the query.

Many thanks
This post has been answered by Dairy Land on Apr 8 2016
Jump to Answer

Comments

794342
add the indicated line and it should work
(but you may get other problems, look you don't want, color etc)
public static void main(String[] args){
  SwingUtilities.invokeLater(new Runnable(){
    public void run(){
      JDialog.setDefaultLookAndFeelDecorated(true);//<-----------
      new FileChooserSizeTest();
}});
}
843805
Michael_Dunn
yes it works! if I add JDialog.setDefaultLookAndFeelDecorated(true);

but that's the only way you know?
because yes it give me looks and feel problems my project :(
794342
the only other way I've seen is to add a componenLlistener,
and in componentResized() check the dimension - if under the min, reset to min
but I've not seen anyone happy with this solution - the component can be
dragged to small size, then 'snaps back' to the minimum
843805
the only other way I've seen is to add a
componenLlistener,
and in componentResized() check the dimension - if
under the min, reset to min
but I've not seen anyone happy with this solution -
the component can be
dragged to small size, then 'snaps back' to the
minimum
I think one of the changes introduced in Java 6 is that setMinimumSize() on a Window will actually enforce the set size, meaning that the window size will "freeze" if the user tries to make it smaller. I haven't tried this myself though, so I won't vouch for it.
843805
...and I see now that the OP mentions he is already using Java 6, so never mind.
843805
Try creating the file chooser like this
                JFileChooser fc = new JFileChooser(){
                    protected JDialog createDialog(Component parent) throws HeadlessException {
                        JDialog dialog = super.createDialog(parent);
                        dialog.setMinimumSize(new Dimension(200,200));
                        return dialog;
                    }
                };
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 9 2016
Added on Apr 7 2016
22 comments
13,978 views