Skip to Main Content
Forums

SQL Developer

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!

SQL Developer replace system date into a string

samdagaApr 7 2014 — edited Apr 9 2014

Hi,

I have a script which exports the result of a query to a file in a folder whose name includes the current system date. I tried the following code but it keeps asking me to enter the v_today parameter.

def v_today =
select to_char(sysdate, 'yyyymmdd') v_today
     from dual;

spool C:\&&v_today\Test.csv
select....

spool off
undef v_today

Can someone correct the above?

Thanks.
This post has been answered by SchemaCzar on Apr 8 2014
Jump to Answer

Comments

How can they bypass squid all together for all calls to access the website as well as direct links into the content server? Is that best done inside IIS, UCM, Squid or somewhere else?

Couple of places.

1. Expose the direct / web server url for the website / wcc instead of port 8080 one on external configuration.

2. Check in config.cfg if the webserver url parameter is set to point to 8080 or is it still showing native port.

Whoopass

Thanx. How do I do that?

Open SS Designer - On the left hand pane - system / site properties are listed .

There is a setting which shows the url setting , it is there the change has to be done.

1 person found this helpful
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2014
Added on Apr 7 2014
#sql-developer
2 comments
1,311 views