var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: to_date function
What does this mean?
select to_date('&1', 'MM/DD/YYYY') into v_start_date from dual;
select (to_date('&2', 'MM/DD/YYYY')+1) into v_end_date from dual;
I am mainly asking about the:
What does the '&1' mean?
These are SQL Plus "substitution variables". In a SQL Plus script, these take the values passed as parameters after the script name, e.g.:
SQL> @myscript aaa bbb
This will set &1 to aaa and &2 to bbb
These are then simply "searched and replaced" in the script.
Just to add to Andrew's reply the dual part you see in the sql statement refers to a dummy table in Oracle.
You can select anything from dual just to test you sql or conversion statements like your exampl shows.