• How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

    ITKE440,470 pointsBadges:
  • Is it possible to kill all sessions connecting to an Oracle database?

    I'm looking for a SQL Plus script that can quickly kill off all external sessions connecting to my Oracle database without the supervision of an administrator. Anyone know how to do this?

    ITKE440,470 pointsBadges:
  • 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.

    Qqqq10 pointsBadges:
  • SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • How can do iSQl*Plus login for DBA

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

    MelanieYarbrough6,345 pointsBadges:
  • 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

    Rsg30 pointsBadges:
  • 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...

    Darryn765 pointsBadges:
  • 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"

    Tota10 pointsBadges:
  • 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...

    Lynrobbins5 pointsBadges:
  • 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 ?

    Mikecold10 pointsBadges:
  • 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.

    Kmuller5 pointsBadges:
  • 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...

    Techguys90 pointsBadges:
  • 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

    Oracle9995 pointsBadges:
  • 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 to complete your...

    DerrickOra5 pointsBadges:
  • 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(*)...

    Kchang7474005 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.