oracle

SQL Plus convert table to CSV file problem

I'm having a problem that I can't figure out while converting a table field in an Oracle database to a CSV file. I have a column of varchar2(4000) where users enter their comments. Sometimes the users copy and paste text from other programs such as MS Word therefore, a lot of extra information is pasted into the field such as carriage ...

How can I see other schemas apart from my own when connecting to an Oracle database through server explorer?

I am attempting to add a connection to an Oracle database through Server Explorer. The 'Test' Connection' is successful, however whenever I go to view the list of tables / schemas, I can only see the one associated with my login. I realise this sounds silly, but when I use the same login/password through Toad for Oracle, I am still allo...

how to change Oracle TNSlistiner path

hi how to change this path: F:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR to this path: d:\app\MyLAP\product\11.1.0\db_1\BIN\TNSLSNR in the service ? thank's in advance ...

Oracle: exporting only schema

Hello I have an Oracle 10g database, and now I need to export, if possible, only the schema. (Only table structures with index etc... without data!) Is this possible with exp/imp or do I need expdp/impdp? Greets ...

Retrieve image from oracle blob field in asp vb

This is my script to load the image from the database: <%@LANGUAGE="VBSCRIPT" %> <!--#include file="db_connection.asp"--> <% Response.Expires = 0 Response.Buffer = TRUE Response.Clear Dim sql Dim rs Dim userID,str Set rs = Server.CreateObject("ADODB.Recordset") str = "SELECT b.itemimg_image FROM sct_item_image b where b.item_id...

how to delete SID name (oracle) from my computer

hi how to delete SID name (oracle) from my computer ? thank's in advance ...

Order By Columns

Does adding more columns to ORDER BY have a performance penalty? ORDER BY STYLE vs. ORDER BY STYLE, SIZE, COLOR ...

update same record which fires a trigger

I want to update the same record which fires a trigger. I have done that using "BEFORE INSERT" option. But note that I have use a transaction to rollback the operation if there is an any faliure. CREATE OR REPLACE TRIGGER GANUKA.INTF_CONTROLLER_UPLOADER BEFORE insert ON GANUKA.INTF_CONTROLLER for each row DECLARE PRAGMA AUTONOMOUS_...

ORACLE SQL: Replace part of text field ignoring case

I need to replace a path stored in an Oracle DB text field. However paths have been specified with different cases (ie MYPATH, MyPath, Mypath, mypath). When using a combination of REPLACE and UPPER, it does not work as I need it to, ie: UPDATE Actions SET Destination = REPLACE(UPPER(Destination), 'MYPATH', 'My_New_Path') This does th...

How well do PHP and Oracle fit together in an enterprise setting?

We use Oracle and PHP together with some success. It seems there are a lot of rough edges as compared to, for instance, Java + Oracle. I am familiar with the Underground PHP + Oracle guide and that there is information scattered around the net. While OCI8 seems to work in most cases, there is noticeably a lack of support for PDO. The...

INSERT INTO TARGET_TABLE SELECT * FROM SOURCE_TABLE;

I would like to do an INSERT / SELECT, this means INSERT in the TARGET_TABLE the records of the SOURCE_TABLE, with this assumption: The SOURCE and the TARGET table have only a SUBSET of common columns, this means in example: ==> The SOURCE TABLE has ALPHA, BETA and GAMMA columns; ==> The TARGET TABLE has BETA, GAMMA and DELTA columns. ...

Worth the overhead to use a temporary table for copying a row?

When faced with the task of copying a record in a database and modifying just a handful of values, I tend to use a temporary table to avoid writing out all of the unchanged columns. Does anyone know how this would affect performance on a large scale system? A quick example (which also shows why I prefer the temporary table method): Le...

Pick another RDBMS

Other then Oracle, MySQL, and PostgreSQL, what is out there? Is there anything else used in a production environment? By production I mean it's used to support an active project or application and not an unstable system. I'm curious about other database systems (aside from NoSQL) that are applicable for use. Looking at the feature set ...

oracle error in windows-7 64bit

hi I installed windows-7 64 bit. When I try to run my program (that works with Oracle 11g) I get this error: Attempt to load Oracle client libraries threw BadImageFormatException this problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed What can be the problem ? Where I can download 64 ...

What's the best way to take a "snapshot" of an Oracle database that is constantly being updated?

I want to take a consistent snapshot of an Oracle database that is constantly being updated by a TIBCO DB Adaptor. Typcially TIBCO updates a bunch of tables at once, and then COMMITs. If I traverse through all the tables, taking a snapshot once a day, then I could grab data from table A before the commit, and from table B after the comm...

Is it "safe" to develop for the JDK7 platform?

We have a project which (assumed) would be finished in 1-2 years. By then, the JDK7 (and hopefully the Java7 JCP spec) should be ready. But, I wonder, how probable is the "danger" that Oracle will make a "stupid" decision, which would make the JDK7 a less "attractive" platform then the existing JDK6? More specific, I'm afraid of scenar...

problem in using methodology...

Dear friends I develop a software with Oracle form builder for my final thesis. I want to prepare some of software development document for my final thesis report. as you know oracle forms blow ver 8.0 is procedural base... I use oracle form 6... I need to prepare Software Requirement Specification (SRS) and Software design document (...

How can i call pl/sql stored procedure (function, returning number value)?

Hi, I'm using oracle sql developer, or oracle sqlplus. Thank, Mattan ...

Oracle Query Join issue

Hello, I have an Oracle table as shown below Orders --------- ORDERID DESCRIPTION TOTALVALUE ORDERSTATUS I have the below mentioned query select ORDERID,ORDERSTATUS FROM ORDERS WHERE ORDERID IN( 1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1020, 1030,104,1040,1090,789) Some orderIDs mentioned above are ...

Evaluating the mean absolute deviation of a set of numbers in Oracle

I'm trying to implement a procedure to evaluate the median absolute deviation of a set of numbers (usually obtained via a GROUP BY clause). An example of a query where I'd like to use this is: select id, mad(values) from mytable group by id; I'm going by the aggregate function example but am a little confused since the function need...