Search results for query: *

see http://www.oracledbaexpert.com/oracle/tuningHints.html regards, sudhí

SELECT TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'),'9999')-1 FROM dual; -Sudhí

okie, download works fine... but whats the password for the winzip file !!!

UPDATE_Product_Problem(INSERT_PRODUCT.PROD_ID, 'INVALID'); close the single quotes after INVALID. it'll work if the procedure is valid. :) sudhi

<script language=&quot;JavaScript&quot;> <!-- var sURL = unescape(window.location.pathname); function doLoad() { setTimeout( &quot;refresh()&quot;, 2*1000 ); } function refresh() { window.location.href = sURL; } //--> </script> insert this script in the else part or ur code....

by refreshing after sometime (atuomatically), it keeps the session alive and atferraz dont want the memory issues by keeping a lot of sessions alive. cookies in ur case is good. If u are ready to keep sessions for more longer alive, set the session.timeout property to forever.

javascript:refresh() or javascript:reload() a simple refresh. automatic refresh: add the meta tag as below <meta HTTP-EQUIV=&quot;Refresh&quot; CONTENT=&quot;60;URL=urPage.html&quot;>

one way is to write the cookie. set the expiry property to never for the cookie and read the cookie. this works provided client accepts cookies (sessions allowed means cookies allowed). cheerz. sudhi

check the previous lines of the query; looks like previous line is not completed. The INTO clause is missing in the SELECT statement.

partioning will not help in searching like index. infact it speeds up the processes (I/O) and mainly used for backup and restore. The query needs to be changed to use the specific partition to use the partition advantage, eg: SELECT * FROM DEPT PARTITION(DEPT201);

the problem is bcoz of the close and open in the loop. after all why cant u directly say UPDATE statement, why the looop here? u r just updating a column to 4.

Case works in Where clause also, only thing is you have to remove the CASE with END, that is use only END and not END CASE SELECT * FROM dual WHERE (CASE WHEN SUBSTR('xxxx',0,3)='111' THEN 'A' WHEN SUBSTR('xxxx',0,3)='112' THEN 'B' ELSE 'C' END )= 'C' cheerz sudhi