Oracle Sql script to spool to file on unix box

I have a script which executes a stored procedure from my oracle database and spools the results to a file. Now I want to spool the files to a unix file path. I'm executing the script using TOAD. How do I specify the unix file path? Or is there an alternative way to do this?Here is the script:set li ...

Oracle Sql Remove spaces between '-'

HelloI ahve a field called name where there are entries like "HELLO - THERE - MR" and "HOW ARE-U". I need to remove the spaces around the hypen only. Does someone know how to do this? ...

Oracle Specify different location of SQL*PLUS EDIT/SPOOL directory

Where can I specify the location of the SQL*PLUS edit/spool directory such that I can change it from the default? I'm running on Linux (Ubuntu 6.10) if that helps... ...

Oracle Sql Plus Help! (the window remain open)

I'm currently using sql plus to export data from oracle to text with spool command, in this way:sqlplus user/pass@excrhi.world @F:\pathtosql\query.sql (this line is in a bat file)where the file query.sql contain the spool comandspool F:\textfile.txt;set head on;set pagesize 0;set linesize 512;set tr ...

Oracle SQL Plus giving SP2-0024: Nothing to change error

I'm just about to lose my mind.I'm running the following in SQL Plus - set echo offset feedback offset linesize 1000set sqlprompt ''spool c:\TEMP2\App_Eng1.csv replaceSelect A.OBJECTOWNERID||','||B.OBJECTVALUE1 from PSPROJECTITEM B, PSAEAPPLDEFN AWhere B.PROJECTNAME = 'PRJ732075'and B.SOURCESTATUS = ...

Oracle SQL*PLUS has encountered a problem and needs to close

When I have done like below,C:\Documents and Settings\himanshu.chaudhari>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 14 07:38:22 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn sys@dev as sysdbaEnter password:Connected.SQL> spool e:/spool/test.logS ...

Oracle SQL Plus Error - "Can't open file" when spooling

I have a user who is either able or unable to spool when running a script depending on what Oracle user she logs in as. She's always logging in as the same Linux user but connecting to Oracle as different Oracle users via SQL Plus. When spool files are created they are created with that user's accou ...

Converting Oracle SQL to DB2 SQL

Help Please,I have follwoing Oracle SQL, I want to convet it to DB2 SQL. Thanks in advance.SELECT nl.title, NVL(TO_CHAR(ac.currentcy_date,'MM/DD/YYYY'),' '), NVL(TO_CHAR(ADD_MONTHS(ac.currentcy_date, co.current_cy_interval),'MM/DD/YYYY'),'Needs Initial Review'), n.menu_position FROM appl_cu ...

Can't Log ON Oracle SQL*Plus

What User name and Pass word I am going to use since I cannot log on to Oracle SQL*Plus. What shoul I do? ...

Oracle SQL reference guide .....WHERE IS IT?

I've searched....and i've searched...where would i find that beautiful Oracle SQL reference guide for 8,9,10 in HTML....like this bootleg I found:http://www.daimi.au.dk/~oracle/sql/or is there such a thing anymore? ...

DB2 LOAD compatibilty with Oracle SQL*LOADER

Can anyone please let me know is there any clause with the DB2 LOAD utility that is compatible with the Oracle SQL*LOADER WHEN clause in the control file? I am currently using Oracle SQL*LOADER to import records from the log file. We are using WHEN clause in the SQL* LOADER control file to specify s ...

ORACLE SQL DEVELOPER will not download

I am trying to download the windows version of ORACLE SQL DEVELOPER , after I accept the license the server times out almost immediately. This has been happening for over a week. ...

Oracle SQL Guide

Is there an equivalent of the following document:Oracle® DatabasePL/SQL User's Guide and Reference10g Release 2 (10.2)B14261-01for Oracle SQL. I have downloaded:Oracle® DatabaseSQL Reference10g Release 2 (10.2)B14200-02but the latter is more of a reference than a tutorial. I like the tutorial natu ...

download Oracle SQL*Plus help related like word help

I just wanna ask if where i can download Oracle SQL*Plus help related like word help.?ty ...

Error : "com.ibm.db2.jcc.a.be cannot be cast to oracle.sql.BLOB"

I created a store procedure with one input and one output parameter. Output parameter is BLOB.I am calling this procedre by java and inserting the value of that into Oracle table. When i am runing this progarme i am getting the following error."com.ibm.db2.jcc.a.be cannot be cast to oracle.sql.BLOB" ...

DB2 LOAD compatibilty with Oracle SQL*LOADER

Can anyone please let me know is there any clause with the DB2 LOAD utility that is compatible with the Oracle SQL*LOADER WHEN clause in the control file? I am currently using Oracle SQL*LOADER to import records from the log file. We are using WHEN clause in the SQL* LOADER control file to specify s ...

Oracle SQL Developer download page

Oracle SQL Developer 1.5.4 (1.5.4.59.40)[Released 03 March 2008]2008 --> 2009 ...

oracle SQL Developper and SQL Server Connection

HelloI try to connect to a SQL Server 2005 Database under Oracle SQl Developper but I always obtain this error :oracle.jdeveloper.cm.CMException: Unable to find driver: net.sourceforge.jtds.jdbc.Driverat oracle.dbtools.raptor.conntypes.RaptorConnectionWrapper.createConnection(RaptorConnectionWrapper ...

Oracle SQL Developer viewer download fail (404)

HiI am trying to download the Oracle SQL Developer Data modeler viewer but get an error (404) every time?I am following the link at http://www.oracle.com/technology/software/products/sql/datamodeler.html after accepting license.I am using IE v7.0 and I tried the SQL Developer tool and got the same e ...

Oracle SQL

I am new to this Forum.. and intrested in learing SQL , Could any one Suggest me how to start learning Oracle SQL Soon. ...

unable to finish the download of Oracle SQL Developer for 32-bit Windows

Since this morning, I try to download Oracle SQL Developer 2.1I tried the 32 bits version with and without JDK, unsuccessfully...... is there a probleme with it ? ...

Oracle sql dump date formatting options...

Suraj Neupane said: I am dumping SQL for some reports.DB is Oracle 9i and I'm sending date prompt from Cognos to the SQL.The prompt is from the calendar and it sends date as yyyy-mm-dd instead of Oracles dd/mon/yy format.Some field in oracle are string value converted to date such as to_date(oracle_ ...

Oracle SQL tuning guide

We have 10.2.04 RAC database running in production.The application does lot of DML.I need to tune query regularly.Could anybody sugggest a good book for Oracle SQl tuning.Thanks and Regards,jitenderEdited by: user10552550 on Feb 22, 2010 5:53 AM ...

free e-course materials for Exam #1Z0-001 Introduction to Oracle: SQL and PL/SQL

I just need free e-course materials for Exam #1Z0-001 Introduction to Oracle: SQL and PL/SQL. In which website I have to go & download the course materials.I don't need question paper.I just searched in oracle.com website but I didn't get it And I would appreciate if you can tell me in which web ...

ACCESS/ORACLE/SQL - please help

I am trying to learn Oracle and make sure my SQL is correct for my database. I would like to convert an Access DB to SQL scipt that ORacle can read. I tried to convert the NorthWind DB in Access to SQL via the MS SQL Server. This produced an SQL file, but I don't think I run that in my Oracle SQL Pl ...

Oracle SQL Developer 11G document

can anybody let me know the link to documentation of Oracle SQL Developer 11G admin guide ? ...

how do i change this oracle sql code to t-sql

there how would i change the following oracle sql code to t-sql. select NEXT_DAY(((TO_DATE(T1."DDATE" ,'yyyymmdd' )) + (-1)),'Sunday'), T2."TWARD", DECODE(LEAST(RTRIM(T1."DTIME" ) ,'11:00:00'),NULL,0 ,RTRIM(T1."DTIME" ),1,0), T1."DURNO"from "IBA ...

Need help for Oracle sql/plsql certifications

I am planning to do the certification oracle sql/plsql. So please tell any one oracle sql/plsql Certification model has changed or not. If changed when is changed and whats the syllabus now. Please provide any help full materials to [email address removed by moderator for security purposes]Thanks fo ...

Where can I find an Oracle SQL Forum???

I thought there used to be an Oracle SQL Forum out here....Is there and where can I find it??? ...

Oracle sql exam

is there any exam free of cost for oracle sqlthansk ...

How to convert oracle SQL code to SQL server code

i kinda new with SQLserver2008..currently i have a code that generates some function and its work on oracle SQL. What i should do now is how to convert the code to MSSQL server code. Kindly need all of guru's out there to guide me on this. Here are the codesQuote: create or replacePROCEDURE A (tbl_n ...

Oracle SQL

I installed Oracle 8 for Windows NT 4.0 and Oracle SQL*Plus version 8.0.3.0.0Oracle is new to me. When I did a select * from emp, SQL can't find the table.What I did wrong? ...

Can anyone convert this Oracle sql to MySQL?

I am doing some integration from Oracle to MySQL and need to know the quivelent MySQL sql for the following Oracle sql:select trunc(sysdate) from dual Basically selecting the current system date without the time part (ie. 13/02/2007). ...

What are the diffs between oracle,sql server,ma access

Can any one send me all the major diffs between oraclesql server, msaccess.If u find any urls also send me those.If u worked on oracle or sql server and if u find any changes( syntax)also send me those.This is mainly for interview ...

Problem in loggin to ORACLE SQL*PLUS

I have downloaded Oracle 8.0.6.0.0 from this site and installed it. I have not been able to logon to Oracle SQL*Plus. I have tried to log as scott/tiger and used all possible values for the host string but nothing seems to work. The summary of the host string used and the error messages is:Username: ...

Access to Oracle SQL conversion help

guys... Need some help with my queryI converted some Access query to Oracle, but I'm not getting the same number of records. Below are the 2 queries :Oracle SQLSELECT *FROM TOPS.VESSEL_CALL VES, TOPS.BERTHING BERTHING, TOPS.CNTR CNTR, TOPS.NOMINATED_VSL NOMWHERE ((VES.VV_CD = BERTHING.VV_CD) AND (VE ...

How to perform byte operation in oracle sql?

I am new user of oracle and is learning. And now I am working for a project which use oracle8.17.when writing stored procedure and trigger, I found I can not perform byte operation in oracle sql. For example,when '7 and 3', it shold come out with 3.But how can I do this in oracle sql?Is anyone can h ...

Oracle SQL-PL/SQL Manuals

Does Oracle have any PDF documents solely on the topics of Oracle SQL & PL/SQL? I've located Oracle's general documentation (http://download-west.oracle.com/docs...1_01/index.htm), but I'm looking for something more consolidated that I can point our developers to. ...

Oracle SQL Impact Analysis / Reverse Engineering Tool ?

Can anyone recommend a proprietry tool that performs impact analysis / reverse engineering on hand-coded Oracle SQL statements, so that for each SQL script, it determines exactly how it performs, in terms of what tables / columns are accessed or affected, column mappings on INSERT statements, etc., ...

how to chage this informix sql to oracle sql?

anyone know how to chage this informix sql to oracle sql? select cust_name[1,40] from customer;the original cust_name is char(60), i just want its first 40 character. how to do that?thanks for ur help! best ...

oracle.sql.* PAckage specification

Can someone throw light on oracle.sql.* pacakge. There are tons of classes available like LobPlsqlUtil but I don't find any proper documentation on usage. Is it possible to use these Classes to write to CLOB or do we have to use only DBMS_LOB pacakge in Java, which causes some performance issues. An ...

Oracle SQL Plus 8

Hello, I wanted to know if Oracle SQL Plus 8 was compatible with windows 2000 ?If yes, are there any bugs Known ? ...

Format string into oracle.sql.CLOB => exception

I just want to convert a simply String or Document type into the Oracle CLOB datatype, because I use a stored Procedure with an CLOB argument.(not to mix with writing a CLOB into a oracle database).I need some help, I tried this here:public void setdataPackage(Document data, float cid) {Connection c ...

Oracle SQL exam?

It's been hard pinning down exactly what exams have to be taken first, but from what I've seen, you have to take an Oracle SQL exam and a DBA fundamentals exam to get the OCA certification, right?What study materials do you recommend for the Oracle SQL exam? Sorry if this has been posted before. ...

LIMIT Clause for Oracle SQL

Hello, I'm developing web app with PHP and MySQL. And some how I also have to use Oracle DB. I'm just very new to Oracle/ Oracle SQL and have a problem to limit number of data to show for search result.My problem is how to do search result pagenation with Oracle/Oracle SQL.MySQL is simply use LIMIT ...

Oracle SQL

Can someone please point me to a good online resource that has code samples on oracle sql.I have written MS SQL stored procedures but oracle has differences that I need to clear up.How do I call a stored procedure within a stored procedure?I tried putting this inside a stored procedure but it fails. ...

Oracle sql practice exams

where can i get practice exams for Oracle SQL & PL/SQL? any web site please. ...

Oracle Sql Developer

I keep getting error messages when i am using ORACLE SQL DEVELOPER with oracle database. Do you guys know is it just me or it has bugs?Raju ...

java.lang.IllegalAccessError: oracle/sql/TypeDescriptor

I am trying to pass an array from java to Oracle. I have used this same code in other pages and it works fine. Now I am getting a stack dump:I get 500 Internal Server error:java.lang.IllegalAccessError: oracle/sql/TypeDescriptor at oracle.sql.ArrayDescriptor.initPickler(ArrayDescri ptor.java:1951) a ...

oracle SQL query help

I'm taking a database besign class but I cannot get my queries to work, this is what I've got.Using oracle SQL plus I made user name mnfg and granted all permissions, Created two tables Employee and Product with this codeCREATE TABLE employee (TEAMNAME varchar2(6), EMPNUM varchar2(6),EMPLNAME varcha ...