SQL Plus stops before finishing
Why does SQL+ stop after running so many characters in a long SQL statement?

Answer Question   |  April 3, 2013  12:23 PM
SQL Plus, SQL statement

How can do iSQl*Plus login for DBA
I want to create iSQL*Plus login for DBA. How can i do this ?

Answer Question   |  March 31, 2012  4:25 PM
DBA, iSQL*Plus, SQL, SQL Plus, SQL Server

Strange Oracle 9i behaviour
We are seeing some very strange behaviour in the performance of a query on our database. We have run the same query on the actual database server (s1) using sql+, and on a server (s2) 1 hop away (taking out network performance). The exact same queries, without any bind variables, are kicked off at exactly the same time. The [...]

Answer Question   |  March 28, 2011  1:43 PM
Oracle 9i, Oracle 9i performance, Oracle performance, Solaris 10, SQL Plus

Log on error Oracle enterprise manager
i can log on sqlplus useing : sqlplus “sys/oracle as sysdba” but on em log on: user : sys password : oracle give me error msg “invalid passowrd”

Answer Question   |  February 6, 2011  7:40 AM
Oracle 10g, Oracle 10g administration, Oracle error messages, SQL Plus

Running SQL PLUS on a server
Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I’m trying to host out of Oracle Forms 6i to run a [...]

Answer Question   |  December 1, 2010  8:02 PM
Oracle, SQL Plus, SQL Server, SQLPlus

Can I direct query the Oracle database with SQL Plus?
I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

Answer Question   |  November 18, 2010  8:23 AM
ERP, Oracle, Oracle 10, Oracle Database, Oracle Query, SAP, SQL, SQL Plus, Unix

Error Message ORA-00903 in SQL table
Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I’d be grateful for any help.

Answer Question   |  November 15, 2010  11:53 PM
ORA-00903, SQL, SQL Plus, SQL tables

Large number rounding in Oracle 10g
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]

Answer Question   |  July 19, 2010  8:27 PM
Oracle 10g administration, Oracle 10g Database, Oracle database administration, SQL Plus, TOAD

oracle 9i in windows 7
i installed oracle 9i in windows 7 os,and i open sql plus and login as scott and tiger it gives authentication fail message,pls help me,same i installed in win xp it works fine,one of my frnd says oracle 9i doesnot works on win7,he formatted win 7 and installed win XP

Answer Question   |  October 10, 2011  10:09 AM
Oracle 9i, Oracle 9i installation errors, SQL Plus, Windows 7

about oracle with Java
What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

Answer Question   |  February 15, 2010  7:52 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus

following error when logging into SQLPlus
When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I’m using Oracle 9i Personal Edition

Answer Question   |  August 21, 2009  6:41 AM
ORA-01034, ORA-27101, Oracle SQL, SQL Plus

How to config iSQL Plus on computer without a domain
Hello I have Oracle 9i installed in my home computer and i want to work in iSql Plus, but i am not able to do it. I tried running the apache server but then when i tried to login i get a error message “The server encountered an internal error or misconfiguration and was unable [...]

Answer Question   |  April 20, 2009  3:32 AM
isql, iSQL*Plus, Oracle, Oracle 9i, SQL, SQL Plus

SQL+ running time error
Can anyone let me know I have a problem to run SQL that after runing sql_build_tables.sql why c:sql_build_tables.txt is empty (0 byt)- this use Win XP to run However, when I use Vista to run the SQL show Cannot create SPOOL file “c:sql_build_tables.txt” as show below OBJECT_TYPE COUNT(*) ————————————– ——— SEQUENCE 5 TRIGGER 2 TABLE [...]

Answer Question   |  February 9, 2009  6:27 PM
SQL, SQL error messages, SQL Plus, Windows XP