Search Results

Search found 14590 results on 584 pages for 'oracle etl'.

Page 330/584 | < Previous Page | 326 327 328 329 330 331 332 333 334 335 336 337  | Next Page >

• How to select from tableA sum of grouped numbers from tableB above their sums average in Oracle?

  - by Nazgulled

  I have data like this: tableA.ID --------- 1 2 3 tableB.ID tableB.NUM -------------------- 1 10 1 15 2 18 3 12 2 15 3 13 1 12 I need to select tableA IDs where the sum of their NUMs in tableB is above the average of all tableA IDs sums. In other words: SUM ID=1 -> 10+15+12 = 37 SUM…

  Read the article

• ORACLE Connect by clause equivalent in SQL Server

  - by zapping

  Is there a equivalent clause to CONNECT BY of Oracle in SQL Server. The requirement to build a category tree using a parentId field.

  Read the article

• Oracle 10g Express Edition backup options and migration tools

  - by RPK

  I want to migrate a MySQL database to Oracle 10g Express. Is there any FREE tool? Secondly, is there any option for automatic backups in 10g Express Edition?

  Read the article

• Oracle HTTP Server access_log - GET /error/404.html HTTP/1.0 200 7001 entries

  - by Pavan

  access_log shows the following entries repeatedly, seems like it is polling some thing. There were so many entries keep on adding to the log, making it difficult to debug for actual error message. aaa.bbb.ccc.ddd - - [07/Nov/2012:00:02:48 -0800] "HEAD /index.html HTTP/1.1" 200 - abc.bcd.cda.dab - - [07/Nov/2012:00:02:50 -0800] "GET…

  Read the article

• How To Call a .Net Web Service with Kerberos (or NTML) authentication from Oracle PL/SQL

  - by Niklas

  Hi all, We are calling a .Net webservice from our oracle database using the sys.utl_http package and we have also tested with the sys.utl_dbws package, this works fine when there is no security on the .Net webservice. However, we would like to use sys.utl_http or sys.utl_dbws to call a .Net webservice with Kerberos- or NTLM…

  Read the article

• How to loop through columns in an oracle pl/sql cursor.

  - by Lloyd

  I am creating a dynamic cursor and I would like to loop over the columns that exist in the cursor. How would I do that? For example: create or replace procedure dynamic_cursor(empid in varchar2, RC IN OUT sys_refcursor) as stmt varchar2(100); begin stmt := 'select * from employees where id = ' || empid; …

  Read the article

• How to call a .NET web service with Kerberos (or NTLM) authentication from Oracle PL/SQL

  - by Niklas

  We are calling a .NET web service from our oracle database using the sys.utl_http package. We have also tested with the sys.utl_dbws package. This works fine when there is no security on the .NET web service. However, we would like to use sys.utl_http or sys.utl_dbws to call a .NET web service with Kerberos or NTLM…

  Read the article

• ORA-06502: PL/SQL: numeric or value error: character string buffer too small with Oracle aggregate f

  - by Tunde

  Good day gurus, I have a script that populates tables on a regular basis that crashed and gave the above error. The strange thing is that it has been running for close to 3 months on the production system with no problems and suddenly crashed last week. There has not been any changes on the tables as far as I know.…

  Read the article

• 3 tier with ASP.NET, C# and Oracle 11g

  - by ephraim

  Hi I am new to .NET, want to follow N-tier approach using Visual Studio 2010(ASP.NET MVC + C#),IIS and Oracle 11g(installed on the remote linux machine). I need to have Presentation, Business Logic, Data Access and Data Tiers. Can anyone give me site/example application with the following fuctionality: insert,…

  Read the article

• Make cloudera-vm work on Oracle VM VirtualBox

  - by ????? ????????

  I downloaded this and the instructions say: Important: You must enable the I/O APIC in order to use 64-bit mode. (See http://www.virtualbox.org/manual/ch03.html.) On newer versions of VirtualBox, it may default to using SATA as the disk interface. This can cause a kernel panic in the VM. Switching to the…

  Read the article

• Oracle Apex:Why is this dynamic action not getting triggered/fired ?

  - by Sathya

  I'm using Application Express 4.0.0.00.25 ( Apex 4.0 EA2 ). I've created a tabular form, with few fields. Each of the field are not direct entry, but rather a LOV picker is attached to these, and on selecting the LOV value, the id gets stored in the field. I have a dynamic action associated to the field, (…

  Read the article

• Oracle SQLPlus: How to display the output of a sqlplus command without having to first issue the spo

  - by ziggy

  Is there a way to display the output of a sqlplus command without having to first issue the spool off command? I am spooling the results of a sqlplus session to a file while at the same time tailing the file. The reason for this is that for table with very long rows the format is easier to look at from a…

  Read the article

• Late Binding with LinFu & Oracle.DataAccess

  - by Alexander Stuckenholz

  Hello everybody, is there a good example of the late binding features of the LinFu framework? I developed a framework which is hard linked against a certain version of an Oracle client. Now I would like to be able to configure the version of the client without the need to rebuild the app. How can I do…

  Read the article

• Oracle java 6 on ubuntu

  - by Shanee

  The java library I need (jpcap) only works on java 6, it won't work with java 7 (and I have tried :( ), is it still possible to install java 6 on ubuntu? Only according to https://help.ubuntu.com/community/Java#Choosing_the_default_Java_to_use, 'Oracle (Sun) Java 6 is no longer available to be…

  Read the article

• How to prevent column b containing the same value as any column a in Oracle?

  - by Janek Bogucki

  What is a good way to prevent a table with 2 columns, a and b, from having any record where column b is equal to any value in column a? This would be used for a table of corrections like this, MR -> Mr Prf. -> Prof. MRs -> Mrs I can see how it could be done with a trigger and a…

  Read the article

• Problem with crawling oracle portal with SharePoint Server 2007 Search

  - by John Hansen

  We got "No Index Attribute" error when we try to indexing Oracle Portal from SharePoint Server 2007 Search crawler. The content source is added sucessfully. The error messages appeare in the crawler log.

  Read the article

• Oracle Merge Rejection Row Count

  - by Andrew

  Given an Oracle Merge statement with a rejection limit, is there a shorthand way to identify how many rows were rejected, without being forced to query the rejection destination? The rejection destination has records pre-merge, so would currently have to be counted twice and the difference…

  Read the article

• how to delete all the data from the table in sqlplus oracle

  - by Nubkadiya

  i want to delete all the data rows in the table. but without dropping the table. delete statement has a where clause so i have to give one by one for each row. is there any other way of deleting the whole data rows in the table. this is Oracle and using sqlplus

  Read the article

• Oracle: Insertion on an indexed table, avoiding duplicates. Looking for tips and advice.

  - by Tom

  Hi everyone, Im looking for the best solution (performance wise) to achieve this. I have to insert records into a table, avoiding duplicates. For example, take table A Insert into A ( Select DISTINCT [FIELDS] from B,C,D.. WHERE (JOIN CONDITIONS ON B,C,D..) AND NOT EXISTS ( …

  Read the article

• Variable declared with variable keyword in sql plus(oracle 9i)?

  - by Vineet

  I am trying to declare g_num ,number data type with size it gives an error but in case of varchar2,char it does not. variable g_name varchar2(5);//correct accept size for varchar 2 variable g_num number(23);//Gives an error " VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR…

  Read the article

• How good is Oracle Universal Connection Pool (UCP)

  - by Andrey Ashikhmin

  Does anybody have experience with using Oracle UCP under real production load? Does it handle database reconnects well? Are there any multi-threading issues? Has anybody compared it with C3P0 or Apache DBCP?

  Read the article

• Oracle Application Server 10.1.3.5 Security issue.

  - by Marius Bogdan IONESCU

  Hello! we are tying to port a J2EE app from OAS 9.0.4 (working perfectly) on OAS 10.1.3.5 the reson we do that is because we need the app compiled with java 1.5 and OAS 10.1.3.5 would be the single major version supporting that binaries which has oc4j/orion kernel. The issue is that…

  Read the article

• Get handle from "Oracle Developer Forums Runtime" appications...

  - by emdadgar2

  Dear all... I want to get textbox handle from "Oracle Developer Forums Runtime" appications to read it's text with VB.NET or C# But cannot!!!! Please help...

  Read the article

• Oracle DUMP procedure returns question marks for Chinese characters

  - by PeteDaMeat

  I am using Oracle 10g and am performing the following query: SELECT DUMP('????', 1017) FROM DUAL; This outputs: Typ=96 Len=4 CharacterSet=AL32UTF8: ?,?,?,? Why have the Chinese characters been replaced with question marks? How do I get it to return the correct characters?

  Read the article

• Oracle Schema designer

  - by mehmetserif

  I don't know the real name of that application but what i want to do is so simple, i have an oracle database with more than 50 tables. I want to get their names also their field names, so i thought that it would be nice to use a designer or something like mssql has. Then i can get the…

  Read the article

< Previous Page | 326 327 328 329 330 331 332 333 334 335 336 337  | Next Page >