How to copy the data from Excel to oracle?
64308
I am looking for a free tool to load Excel data sheet into an Oracle database. I tried the Oracle SQL developer, but it keeps throwing a NullPointerException. Any ideas?
85743
I am working on a project that uses a CSV file supplied by the client to populate a database. The client is to create the spreadsheet, then save it as a CSV to be uploaded, which is then parsed into a database.  The problem is, whenever the client saves the excel spreadsheet as an MS-DOS .csv file, many of the special characters get converted to question marks "?" (symbols such as ' " / ). However, if we then open the CSV file and manually replace each ? with the right character it works fine.  The problem is that the data file is HUGE, and we can't reasonably do this, so I was hoping there was a way to save it. We have tried exporting as Unicode and ASCII to no avail. We have also tried uploading to google docs, and re-saving, however, it also breaks those characters.
80314
I am executing copy command from a function  execute 'copy (select * from tableName) to ''/tmp/result.txt'''   It works fine. But, tableName is dynamic and will be having more tables (iterating in a loop). result.txt is having only the last iteration (table) data.   I could do, if I had to, via the command line with \o or &gt;&gt; by appending to a file. But, I have to use the function.  I read .  It suggests a solution using temporary tables. Can I do something similar, but without temp tables? (I must avoid archive logs).  Will creating a temp table create archive logs?  Is there any way to do appending with copy command in a function?
51436
Please provide me with the guidance to install oracle 11gr2 on Ubuntu 14.04.
90667
[root@pdbosl02 daily]# ls -lrth total 12G -rw-r----- 1 oracle dba 3.8G Dec  7 20:43 BKPOSLPRD_jcns9p1f.F_bkp -rw-r----- 1 oracle dba 4.2G Dec  7 20:46 BKPOSLPRD_jdns9p1f.F_bkp -rw-r----- 1 oracle dba 3.0G Dec  7 20:51 BKPOSLPRD_jbns9p1f.F_bkp -rw-r----- 1 oracle dba 140M Dec  7 20:52 ALG_OSLPRD_jgns9rfr.alg -rw-r----- 1 oracle dba 189M Dec  7 20:52 ALG_OSLPRD_jfns9rfr.alg -rw-r----- 1 oracle dba 202M Dec  7 20:52 ALG_OSLPRD_jens9rfr.alg -rw-r----- 1 oracle dba  42M Dec  7 20:52 c-4249173797-20121207-00 -rw-r----- 1 oracle dba  41M Dec  7 20:52 ctrl_071223   I want to know about h in ls -lrth command.
97951
First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to restore Oracle 11.1.0.7. multi HDD cluster production on single hdd locally on amazon ec2.  Restore is done from full back-up copy I downloaded from ftp location (I have no access to production,export and etc.) just have access to the files, i.e. I am not able to change anyhow export procedure.  So here are my steps in brief (I guess that problem might be in some of them):  rman target / set DBID ... startup nomount RESTORE CONTROLFILE FROM 'file destination' shutdown; startup mount;   Catalog the backup files to rman, for all AL and BK files:   catalog backuppiece 'C:/BKUP/AL_2851492942_20151016_893271615_PGQJSFHV_1_1';   Rename all redo files to match my local directory structure  rman:crosscheck backup; Run{ SET UNTIL SEQUENCE 50511;       RESTORE DATABASE; SWITCH DATAFILE ALL; RECOVER DATABASE;  }   sqlplus sys/sys as sysdba  shutdown immediate; startup mount; alter database noarchivelog;   Drop the no longer used log files. Drop these in state UNUSED left Active and Inactive. Drop all temp files(they point to other drive letter):  ALTER DATABASE OPEN; ALTER TABLESPACE mytempspace  ADD TEMPFILE 'c:\oracle............dbf' SIZE 1G REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;   My problem is that on my second query (get) to db through my app I receive:  ORA-01578: ORACLE data block corrupted (file # 64, block # 2559928) ORA-01110: data file 64: 'C:\ORACLE\ORADATA\mydb\mydbLOBDATA2_1.DBF' ORA-26040: Data block was loaded using the NOLOGGING option ORA-06512: at "mydbUSER.POBJECTSTATE", line 78 ORA-06512: at line 1   What I was able to find with validation and it is LOBSEGMENT - Lob_ObjectState and it logically corrupted.  I tried DBMS_REPAIR and with rman advise failure (which suggest to restore my copy from backup - nothing useful).  Since backup are refreshed every week I try with new ones from the next week, again the same problem.  Is there a possibility that the problem starts from export (how can I check this - I do not have access but i may ask db admin to check anything)?
45411
Is it possible to export data from excel to exisiting sharepoint list i do not want to create new one ,copy paste datasheetview is not working as expected and taking time do we have any options?
121040
I expect the column to be a VARCHAR2, in my Oracle Database.  US Zips are 9.  Canadian is 7.  I am thinking 32 characters would be reasonable upper limit  What am I missing?  [EDIT] TIL: 12 is a reasonable answer to the question Thanks to everyone who contributed.
49139
Is there a way to generate an arbitrary number of rows that can be used in a JOIN similar to the Oracle syntax:  SELECT LEVEL FROM DUAL CONNECT BY LEVEL&lt;=10
3484
I have data that looks like this:  Id | Loc1 | Loc2 | Loc3 | Loc4 ---+------+------+------+----- 1  | NY   | CA   | TX   | IL 2  | WA   | OR   | NH   | RI   And I want to convert it to this:  Id | LocNum | Loc ---+--------+---- 1  |   1    | NY 1  |   2    | CA 1  |   3    | TX 1  |   4    | IL 2  |   1    | WA 2  |   2    | OR 2  |   3    | NH 2  |   4    | RI   What's the easiest way to do this in Excel 2007?
54419
File1: Excel file (.xls)  UN          ID    St      M1    M2       SE    DOF  PV        PA            FC 17127159    0   -5.9    297.3   765.7   0.22    4   0.003   0.00389231  2.57536 17127163    2   -3.87   189.914 492.307 0.3548  4   0.0179  0.01795     2.59226 17127167    4   -3.8908 339.136 855.276 0.3429  4   0.0176  0.017       2.52192 17127171    6   -3.922  390.44  986.365 0.340   4   0.0172179   0.01721 2.52627 17127175    8   -4.715  536.072 1210.65 0.2492  4   0.00920158  0.00920 2.258   File2: Text file (.txt)  UNIT_ID   UN      TID        X       E       GG7     J     O 0      17127159 16657436 353.568 335.295 221.717 815.654 684.85 1      17127161 16657436 11.0842 7.01459 7.33511 11.2121 12.6268 2      17127163 16657450 221.647 226.774 136.274 431.32  392.533 3      17127165 16657452 5.02182 3.41172 4.12834 6.90306 4.91183   If 1st column of 1st file matches with 2nd column of 2nd file extract the matched rows of 2nd file from column 3 to column 9 and save them in the first file.  Can anyone help me ?  Output should be saved in a new file  output:  UN        ID   St  M1    M2    SE   DOF PV    PA    FC    TID     X  E  GG7  J O 17127159  0   -5.9  297.3   765.7   0.22    4   0.003   0.00389231  2.57536  16657436 353.568 335.295 221.717 815.654 684.85
102713
A client sent us an Oracle database we need to test against. We don't use Oracle or have any in-house Oracle expertise.  We need to setup the database so we can connect to it and debug a problem.  I did a fresh install of Oracle 9 (the version the client is running) and the management tools.  For the life of me, I cannot get it to import the data. It should not be this complicated. I must be getting something wrong.  I've tried:  imp 'sys/password AS SYSDBA' file=c:\database.dmp full=yes log=implog.txt   and got:  Connected to: Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production  Export file created by EXPORT:V09.02.00 via conventional path  Warning: the objects were exported by SYSTEM, not by you  import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set . importing SYSTEM's objects into SYS . importing ABCDE's objects into ABCDE IMP-00003: ORACLE error 1435 encountered ORA-01435: user does not exist Import terminated successfully with warnings.   But nothing shows up in the manager as far as tables in any schema and I'm at my wits end.
118263
Suppose I have a file:  File1:   PAPER  TEAM  MANISH NISHA GARIMA JYOUTI ........etc    File2 I want:  PAPER     TEAM MANISH NISHA GARIMA     JYOUTI   Rows to column conversion of File1.
63425
I am switching from old CRM and looking for easy to use tools to import my data
92306
I have the following format in Excel and I am trying to extract the data between the characters:  First Last &lt;flastname@xxxx.com&gt;   I need to extract the email address between &lt; and > into its own cell  Thanks!
81561
how to convert multiple duplicate columns as single row with appreciated values see the image my actually table and expected result.
112625
How can you show the SQL that is currently executing on an oracle db?  Extra information that would be useful would include user, session id etc.