Oracle Import/export

How do you load a CSV file into Oracle?

HOW TO LOAD .CSV FILE INTO ORACLE

convert excel to oracle 9i?

how can i convert data excel to oracle 9i?

Oracle Form: export to Microsoft Excel

I have an oracle form,i need the code of a function that exports a given SQL query into Excel sheet on a button click action.

Importing dmp file

What is the procedure for importing a dmp file?

How to create procedure in Oracle

I WANT TO CREATE A PROCEDURE FOR DOING FOLLOWING 4 ACTIONS 1) That will first delete all data from xa and then load data from xls file (TOWN.XLS on d drive)with columns USER_ID, CLUSTER_CODE,TOWN, TOWN_CATEGORY, TOWN_TYPE, TYPE, STATUS INto the table XA TABLE XA ( USER_ID ...

Convert Oracle code to Microsoft SQL code

I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

How can we migrate Oracle database to Microsoft Access?

oracle to ms access

Oracle Reports 6i - Convert data in Microsoft Excel

HOW TO CONVERT ORACLE REPORTS 6i DATA INTO MICROSOFT EXCEL THROUGH CODING ON BUTTON?

Oracle: How to import schema to replace identical schema but retain unique identifier?

I have spatial (SDO) data that I would like to import from one schema into another identical schema. My problem is that I only want to replace the spatial data that have the exact same UID_1 (Unique Identifier). Is there a way to do this and if so how?

How to call Microsoft Excel from Oracle Reports/Forms 6i

how to call excel from oracle report/forms 6i plz tell me the step by step process how can we do it my e-mailid is lightmobeen@yahoo.com if any one know the process plz send me mail sonsist of code,me very thankful to u for this

ORA-00600

What is the solution to this ORA-00600:internal error code, arguements: [kksfbc_reparse_infinite_loop],[],[],[],[],[],[],[]

Updating Microsoft SQL Server tables from Oracle generates error

i am not able to update table in ms sql2000 from oracle . can u sugegstyour views on this . the error i got is ORA-00904: "NAME": invalid identifier.

How to save the exported Excel files from Oracle Forms 6

Hi, I am using oracle forms 6.0. I generate multiple excel files from oracle forms and am using ole2 to export the data into excel. But i dont know how to save those files into the local machine. please someone help me. Thanks in advance

Transfer Oracle database

hi,i wanna transfer my oracle database like tables from one server to another server using export and import command.

Multiple Tables to Bulk Import .sql script

I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select...

backup and recovery

details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

Error when translating execute immediate from Oracle to SQL

SSMA warning messages: * O2SS0356: Conversion from NUMBER datatype can cause data loss. BEGIN FETCH emp INTO @emps$emp_name, @emps$emp_id IF @@FETCH_STATUS = -1 BREAK IF @emps$emp_name = 'Avi' /* ...

Items in Pending Transactions of Inventory Module

Hi, We have items in Pending transactions of Inventory Module, they cannot be progressed because The Sales order is already cancelled. The problem is our item reservable is decreased because some of the items were stuck in pending transactions. I tried to use this but it did not work : i2471362.sql

Oracle to SQL Server Migration - CURSOR type conversion

When I migrated a small database from Oracle to SQL Server using Microsoft SSMA, it converted CURSOR types to varchar(8000) **SSMA Warning** O2SS0259:CURSOR type was converted to varchar(8000) ** Do we just leave this as is or does it require attention. Thanks.

Oracle to SQL Server Migration - User Defined data types

Oracle database has two user defined types as the following: CREATE OR REPLACE type arrayType1 is table of int CREATE OR REPLACE type arrayType2 is table of varchar2(255) How do we represent these in SQL Server 2005?!! (Note: Microsoft SSMA fails to migrate these) Thanks