| joseph |
Posted: Feb 21, 2006 11:11:23 PM |
Total Post: 2
Joined: Jan, 2003
|
Hi Everyone,
Is there any good document that explain concept of SQL tuning?
Thanks,
Joseph |
|
|
Anil |
| Posted: Feb 21, 2006 11:51:23 PM | |
|
Total Post: 13
Joined: Jan, 2003
|
Check this papers from Vigyan.
http://www.dbapool.com/downloads/whitepapers/tipsforesql.pdf
Anil
|
|
|
|
|
joseph |
| Posted: Feb 22, 2006 12:33:25 AM | |
|
Total Post: 2
Joined: Jan, 2003
|
|
|
|
|
Lochu |
| Posted: Jun 06, 2006 10:55:00 AM | |
|
Total Post: 1
Joined: Jun, 2006
|
Use the following link
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm
|
|
|
|
|
Muks |
| Posted: Jan 22, 2007 12:06:26 PM | |
|
Total Post: 47
Joined: Jan, 2007
|
hello there,
I have a query...
SELECT ename, sal
FROM emp
WHERE deptno = 20;
This I changed to -
SELECT ename, sal
FROM emp
WHERE deptno = :deptno;
but the later one give me an error saying bind variable not declared...my question is ..."where I have to declare a bind variable if I am running a simple sql"
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |