| Question about parsing. [message #372272] |
Wed, 24 January 2001 10:41  |
BoOsTaH
Messages: 1
Registered: January 2001
|
Junior Member |
|
|
Hi all,
I thought that when a user executes 5 times exactly the same sql-statement with exactly the same values for the where condition, that oracle would only parse the statement once and use the parsed information for the other 4 executions. (like it's the case with bindvariables).
Anyone could tell me what oracle prevents from just parsing the statement once instead of 5 times ? (knowing that the sql is in still in the shared pool)
I would also very much appreciate if you could tell me some good links on the topic.
Thanx a lot !
|
|
|
|
| Re: Question about parsing. [message #372276 is a reply to message #372272] |
Wed, 24 January 2001 15:01  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
select to_char(sysdate, 'd') from dual;
gives the day of the week. 1=sunday, 7=saturday.
You could use this in conjunction with regular date arithmetic (date1-date2) to figure how many Sat., Sun. there are and subtract them?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
