Advertisement

250 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 
jmcg

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top Oracle 10.x Solutions: 76 - 100 of 275
 
oracle, database 10, 10, exporting table content into xml format-DBMS_XMLGEN.GETXML
folks i have the following which displays the data in xml format Select DBMS_XMLGEN.GETXML (       'select WORKORDER.wonum,ASSET.ASSETNUM,WORKORDER.DESCRIPTION,       (SELECT LOCATIONS...
ORA-00923 (FROM keyword not found where expected) on a larger sql statement
Hi, I could need some help on this sql statement i got. I'm not that familar with case so I suspect a simple syntax error here. Any ideas? Thank you. Tolomir
Trying to use LPAD, TO_CHAR to format a number to a specific format.
Hello Gurus, I need to create a fixed width trailer record.  My current code is shown below.  My issue is that the 'count' value displays correctly but the total data value does not. No matte...
Change Oracle Enterprise Manager default DB
Hi, Does anyone know how to change the default DB \ SID that Oracle 10g for Linux uses? We access the management console by accessing <IP>:5500/em. regards Ryan
using sql loader in oracle 10g ???
Hi, I am tryin to load some data into my oracle table using sql loader and I am running into some problem. I have attached the control file and the data file for your ref. When I load the data...
need to download oracle sql developer for vista
I need to download oracel sql developer for vista where can i get this.
SQL Plus
How do I do a query on a date range based on the system date. I need to have the date(s) fall between 120 - 180 days of the system date. I also need page breaks for each new mfg and the tota...
System Tablespace shows 99.8% used in Enterprise Manager
Information:  (question at the bottom)- Oracle 10g R2 (10.2.0.3) Standard Edition Windows 2003 SP2 The system datafile is set to auto extend and the system tablespace has Extent Managemen...
Error 06550 oracle.
System.Data.OracleClient.OracleException was caught   Message="ORA-06550: line 1, column 7:\nPLS-00201: identifier 'INSERT_PRICE_LIST_HDR' must be declared\nORA-06550: line 1, column 7:\nPL/S...
Does the Oracle wrap utility actually "encrypt" the existing oracle schema structure?
Hi,       I need to secure our Oracle db from unauthorized changes to the schema. The db is not in a development\production environment. It is strickly holding non-sensitive data, however,...
Urgent - SUM 1 ROW Column1+Column2+....
hi experts ... i need SQL TO MAKE FOR ME SUM OF Columns i want to get sum of Column1+Column2+Column3 .. how i can do that ? in Oracle SQL AND THIS IS MY Filed i want sum for 1 ...
SQL query with join between 2 tables not working
I have a sysytem with J2EE application running with an Oracle back end. I have a query screen which takes a transacion code #TXN_CODE#, description as #TC_DESCR# and so forth.  What is happe...
How can I change my computer name without breaking Oracle?
Hi,      I have Oracle 10g Express Edition installed on a Windows XP professional machine.  Everything works fine until I change the computer name, and then Oracle does not function.  When ...
trying to remove non standard characters from a string
I need to strip the non-standard characters from this string TAYLOR'S AUTO PRODUCTS,INCýý59 Preferably, replacing them with spaces... TAYLOR'S AUTO PRODUCTS,INC  59 so select regexp...
Do I need to increase streams_pool_size when I do data pump full export?
When I did data pump full export, I got the following error message. ORA-06512: at "SYS.DBMS_SYS_ERROR", line 111 ORA-06512: at "SYS.KUPC$QUE_INT", line 444 ORA-06512: at "SYS.DBMS_DATAPUM...
How to get info of DML timestamp from Oracle dictionary table
I want to know if there is a sys table or view record the information like last DML apply to a particular table in Oracle 10g. Thanks.
oracle, 10g, Trying to rebuild index:  SQL*Plus in not responding state
In SQL*Plus running on windows, I issued an ALTER INDEX index_name REBUILD ONLINE statement.  This was about 8 hours ago; the table the index is on is very large. Right now, my SQL*PLUS win...
Installing Oracle Express 10.2.0 on Vista PC's / Laptop
I've done some testing, so hopefully the next few lines will asssit in the solution. I'm trying to install Oracle Express Edition 1og onto a vista laptop.  I have attemted to install this o...
How do I add (duration) for start Date and Time in Oracle 10G?
I have a table on Oracle 10g, with three columns ( Duration, start_date, start_time) as show below, I want to add two other columns contain stop_date and stop_time (by adding the duration to s...
oracle, 10, database, query to get records for previous week
folks how do i obtain data from the previous week only? i.e sysdate(current week)-1 all help will do r
Import flat file(fixed field it is not delimited )  into a oracle table  using Toad
I have a flat file which is not delimited and it a fixed field file. I need to load this to oracle table using toad. I went to database menuitem---->Import source files  and then I can add fil...
opeinging the enterprise manager console...??
Hi, I am running an oracle 10g database on a linux machine. I have 2 databases running on the server, sales and mydb. Now when I start the database control the sales database on port 1158 open...
Oracle 10g server and client
what is the difference between oracle 10g server and oracle 10g client?
How do I handle special characters in Oracle 10g (External Tables)
Hi Guys, I have a few External Tables that read data directly from flat files, we use these to do Migration. The data source is from an old Mainframe system :) We have been testing the m...
Oracle 10g Date question - Related Issue
Original Question: I am inserting this sql statement into an Oracle 10g database: INSERT INTO ActivityLog(ID, date) values(41, to_date ('02-27-2007 09:17:55 PM', 'MM-DD-YYYY HH:MI:SS AM'))...