about Oracle & ＳＱＬＰＬＵＳ
-
Ｈｉ Ｆｒｉｅｎｄｓ， Ｉ ｉｎｓｔａｌｌｅｄ Ｏｒａｃｌｅ １１ｇ ｉｎ ｍｙ ＸＰ ６４ｂｉｔ ＯＳ， ｎｏｗ Ｉ ｔｒｙ ｔｏ ｒｕｎ ｓｏｍｅ ｓｃｒｉｐｔｓ ｉｎ ＳＱＬＰＬＵＳ． Ｈｏｗ ｃａｎ Ｉ ｃｈｅｃｋ ｔｈｅ ｃｕｒｒｅｎｔ ｄｅｆａｕｌｔ ｐａｔｈ ｕｎｄｅｒ ＳＱＬＰＬＵＳ？ Ｎａｍｅｌｙ， ｗｈｅｒｅ ｓｈｏｕｌｄ Ｉ store these scripts? Ｆｒｏｍ ｔｈｅ ｉｎｓｔａｌｌａｔｉｏｎ ｓｕｍｍａｒｙ， Ｉ ｋｎｏｗ ｗｈｅｒｅ ｔｈｅ ＯＲＡＣＬＥ＿ＨＯＭＥ ａｎｄ ＯＲＡＣＬＥ＿ＢＡＳＥ ａｒｅ， ｄｏ Ｉ ｈａｖｅ ｔｏ ｓｅｔ ｅｎｖｉｒｏｎｍｅｎｔ ｖａｒｉａｂｌｅｓ？ Ｃｏｎｆｕｓｉｎｇ．．．．Ｈｏｐｅ ｓｏｍｅｏｎｅ ｃａｎ ｇｉｖｅ ｍｅ ａ ｓｕｇｇｅｓｔｉｏｎ． Ｔｈａｎｋｓ
-
Ｈｉ Ｆｒｉｅｎｄｓ， Ｉ ｉｎｓｔａｌｌｅｄ Ｏｒａｃｌｅ １１ｇ ｉｎ ｍｙ ＸＰ ６４ｂｉｔ ＯＳ， ｎｏｗ Ｉ ｔｒｙ ｔｏ ｒｕｎ ｓｏｍｅ ｓｃｒｉｐｔｓ ｉｎ ＳＱＬＰＬＵＳ． Ｈｏｗ ｃａｎ Ｉ ｃｈｅｃｋ ｔｈｅ ｃｕｒｒｅｎｔ ｄｅｆａｕｌｔ ｐａｔｈ ｕｎｄｅｒ ＳＱＬＰＬＵＳ？ Ｎａｍｅｌｙ， ｗｈｅｒｅ ｓｈｏｕｌｄ Ｉ store these scripts? Ｆｒｏｍ ｔｈｅ ｉｎｓｔａｌｌａｔｉｏｎ ｓｕｍｍａｒｙ， Ｉ ｋｎｏｗ ｗｈｅｒｅ ｔｈｅ ＯＲＡＣＬＥ＿ＨＯＭＥ ａｎｄ ＯＲＡＣＬＥ＿ＢＡＳＥ ａｒｅ， ｄｏ Ｉ ｈａｖｅ ｔｏ ｓｅｔ ｅｎｖｉｒｏｎｍｅｎｔ ｖａｒｉａｂｌｅｓ？ Ｃｏｎｆｕｓｉｎｇ．．．．Ｈｏｐｅ ｓｏｍｅｏｎｅ ｃａｎ ｇｉｖｅ ｍｅ ａ ｓｕｇｇｅｓｔｉｏｎ． Ｔｈａｎｋｓ
Your post has so much spaces, it is very hard to read. Fix it so, people may look at it
Yusuf May I help you?
-
Ｈｉ Ｆｒｉｅｎｄｓ， Ｉ ｉｎｓｔａｌｌｅｄ Ｏｒａｃｌｅ １１ｇ ｉｎ ｍｙ ＸＰ ６４ｂｉｔ ＯＳ， ｎｏｗ Ｉ ｔｒｙ ｔｏ ｒｕｎ ｓｏｍｅ ｓｃｒｉｐｔｓ ｉｎ ＳＱＬＰＬＵＳ． Ｈｏｗ ｃａｎ Ｉ ｃｈｅｃｋ ｔｈｅ ｃｕｒｒｅｎｔ ｄｅｆａｕｌｔ ｐａｔｈ ｕｎｄｅｒ ＳＱＬＰＬＵＳ？ Ｎａｍｅｌｙ， ｗｈｅｒｅ ｓｈｏｕｌｄ Ｉ store these scripts? Ｆｒｏｍ ｔｈｅ ｉｎｓｔａｌｌａｔｉｏｎ ｓｕｍｍａｒｙ， Ｉ ｋｎｏｗ ｗｈｅｒｅ ｔｈｅ ＯＲＡＣＬＥ＿ＨＯＭＥ ａｎｄ ＯＲＡＣＬＥ＿ＢＡＳＥ ａｒｅ， ｄｏ Ｉ ｈａｖｅ ｔｏ ｓｅｔ ｅｎｖｉｒｏｎｍｅｎｔ ｖａｒｉａｂｌｅｓ？ Ｃｏｎｆｕｓｉｎｇ．．．．Ｈｏｐｅ ｓｏｍｅｏｎｅ ｃａｎ ｇｉｖｅ ｍｅ ａ ｓｕｇｇｅｓｔｉｏｎ． Ｔｈａｎｋｓ
The default SQLPlus directory is %ORACLE_HOME%\dbs The SQLPATH environment variable will allow you to specify the default search path for scripts. Personally I don't use SQLPlus, I find it a PITA.
"When did ignorance become a point of view" - Dilbert
-
Ｈｉ Ｆｒｉｅｎｄｓ， Ｉ ｉｎｓｔａｌｌｅｄ Ｏｒａｃｌｅ １１ｇ ｉｎ ｍｙ ＸＰ ６４ｂｉｔ ＯＳ， ｎｏｗ Ｉ ｔｒｙ ｔｏ ｒｕｎ ｓｏｍｅ ｓｃｒｉｐｔｓ ｉｎ ＳＱＬＰＬＵＳ． Ｈｏｗ ｃａｎ Ｉ ｃｈｅｃｋ ｔｈｅ ｃｕｒｒｅｎｔ ｄｅｆａｕｌｔ ｐａｔｈ ｕｎｄｅｒ ＳＱＬＰＬＵＳ？ Ｎａｍｅｌｙ， ｗｈｅｒｅ ｓｈｏｕｌｄ Ｉ store these scripts? Ｆｒｏｍ ｔｈｅ ｉｎｓｔａｌｌａｔｉｏｎ ｓｕｍｍａｒｙ， Ｉ ｋｎｏｗ ｗｈｅｒｅ ｔｈｅ ＯＲＡＣＬＥ＿ＨＯＭＥ ａｎｄ ＯＲＡＣＬＥ＿ＢＡＳＥ ａｒｅ， ｄｏ Ｉ ｈａｖｅ ｔｏ ｓｅｔ ｅｎｖｉｒｏｎｍｅｎｔ ｖａｒｉａｂｌｅｓ？ Ｃｏｎｆｕｓｉｎｇ．．．．Ｈｏｐｅ ｓｏｍｅｏｎｅ ｃａｎ ｇｉｖｅ ｍｅ ａ ｓｕｇｇｅｓｔｉｏｎ． Ｔｈａｎｋｓ
I think on Windows it is not necessary to set Oracle's environment variables manually (different from Linux). Scripts can be stored quite anywhere, as you can give the path e.g.
START e:\temp\myscript.sql
But Oracle has often some problems when the path contains spaces (perhaps also with national characters or when the path is "long"), so just avoid that - Oracle is still an 1980ies legacy software.
-
I think on Windows it is not necessary to set Oracle's environment variables manually (different from Linux). Scripts can be stored quite anywhere, as you can give the path e.g.
START e:\temp\myscript.sql
But Oracle has often some problems when the path contains spaces (perhaps also with national characters or when the path is "long"), so just avoid that - Oracle is still an 1980ies legacy software.