Search Results

Search found 17224 results on 689 pages for 'oracle cloud'.

Page 419/689 | < Previous Page | 415 416 417 418 419 420 421 422 423 424 425 426  | Next Page >

• ????????????????WebLogic Server??????????????--CTC??WebLoDOCK???WebLogic?????????

  - by ???02

  ?WebLogic Server??????????????????????????????????WebLogic Server??????????????????????--??????????????????????????????(CTC)???????????WebLogic?????? WebLoDOCK????????????WebLogic???????????WebLogic Server?????????????????????????????????????????????????????????????????????????? ??????????? Web?????????????????????????(???) …

  Read the article

• What is the difference between "ORA-12571: TNS packet writer failure" and "ORA-03135: connection los

  - by Philippe

  I am working in an environment where we get production issues from time to time related to Oracle connections. We use ODP.NET from ASP.NET applications, and we suspect the firewall closes connections that have been in the connection pool too long. Sometimes we get an "ORA-12571: TNS packet writer failure" error, and…

  Read the article

• How to resolve "TNS-12520 TNS:listener could not find available handler for requested type"?

  - by Roman Kagan

  I have brand new MacBook Pro (Mac OS 10.6.3) and installed Oracle's SQLDeveloper. After doing so, I set the connection and was connecting just fine. But after an hour or so I got "TNS-12520 TNS:listener could not find available handler for requested type". I wonder how can I fix it?

  Read the article

• convert clob to varchar2

  - by Shamik

  I have a Oracle table whose column is a CLOB datatype. I want to read the content of this table as a text. I tried select dbms_lob.substr( sqltext, 4000, 1 ) from test but this one selects only the first 4000 bytes. How to read the entire content ? there are more than 4000 characters in the sqltext column. Please…

  Read the article

• How to extent activrerecord,just make id to id.to_i

  - by qichunren

  module ActiveRecord module Mixin alias old_id id def id old_id.to_i end def hello "hellooooooooooooo" end end end ActiveRecord::Base.send :include, ActiveRecord::Mixin I make is because: id column in oracle is number type,not number(10), @user.id return 123.0,not 123,so I would like to do it by extend…

  Read the article

• How do I add the Java Api Documentation to Eclipse?

  - by Kurru

  Hi I have downloaded Java API documentation from http://www.oracle.com/technetwork/java/javase/downloads/index.html#docs and have supposedly attached it to Eclipse using the Window-Preferences-Java-Installed JREs-Edit-"Select rt.jar"-Javadoc Location AND the location has been accepted and "Validates"…

  Read the article

• Anyone know how to open new page in another window using OAF other then LOV

  - by Imran Petiwala

  Anyone know how to open new page in another window using OAF - Oracle application framework other then LOV. I tried with JavaScript but due to security reasons i can not use it. just wondering if there is a way in OAF to achieve this. Thanks Imran

  Read the article

• oci_connect Blank Page in PHP

  - by Bryan

  UPDATE (3/8/2010) I installed Xdebug and have it tracing my code. This is the output I am getting: TRACE START [2010-03-08 17:53:05] 0.2090 327864 -> {main}() /data/aims3/http/octest.php:0 0.2091 327988 -> ini_set(string(14), string(1)) /data/aims3/http/octest.php:3 0.2093 …

  Read the article

• Can I return values to PHP from an anonymous PL/SQL block?

  - by RenderIn

  I'm using PHP and OCI8 to execute anonymous Oracle PL/SQL blocks of code. Is there any way for me to bind a variable and get its output upon completion of the block, just as I can when I call stored procedures in a similar way? $SQL = "declare something varchar2 := 'I want this returned'; begin --How can…

  Read the article

• how to display databases in oracle11g using sqlplus

  - by Nubkadiya

  in mysql its show databases; but how to show the available databases in oracle. can someone help

  Read the article

• How to export data with sql developer?

  - by Adomas

  Hi, How to export oracle DB data with sql developer? I need all data, tables, constrains, structure and so on. Thanks

  Read the article

• Database performance benchmark

  - by pablo

  Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance? I'd like to know things like: INSERT performance SELECT performance Scalability under heavy load Based on some real examples in order to gain a better understanding about the different RDBMS.

  Read the article

• "ResolveAssemblyReference" task fails and System.BadImageFormatException, but assembly isn't used an

  - by bdwakefield

  I am getting an error about the assembly "C:\Ora10g\bin\Zip.exe". The trouble is this solution does NOT use anything in Oracle at all. I could not find a single reference to 10g anywhere in the project. I inherited this from another person who left our group. He never had this issue. Another member of my…

  Read the article

• SQL - fetch the row which has the Max value for a column

  - by Umang

  Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each UserId that has the latest date. Is there a way to do this simply in SQL? (Preferably Oracle) Thank in advance! [Update:] Apologies for any ambiguity: I need to get ALL the…

  Read the article

• ORA-12899 error in CHAR(1) field, but I'm sending only a 'C'

  - by Keyo

  My Oracle database returns the error: ORA-12899 - Value too large for column TIT.ESTADO_CIVIL (actual: 2, maximum: 1) But I'm very sure that the sended value is an unique char 'C'. Anyone knows why this is happening? (I'm using C# with ODP.NET)

  Read the article

• Proxy Service & Business Service

  - by hakish

  Can i use a proxy service without a business service while configuring message flows in Oracle service bus? If so is what scenarios would we use it?

  Read the article

• Notification in case of data changes in SQL and Oralce

  - by user171523

  I am in the process of building a system where i need to notify a Window Service a .net based application in case of any change in the DB table (Insert , Update , Delete). I know this can be done with the ADO.NET Events in SQL. Is there any common solution for Oracle and SQL which can provide this…

  Read the article

• HQL : LEFT OUTER JOIN

  - by Parama

  Hi all, I have two tables and respective classes in java.The mapping in the HBM.xml is as follows : The query in the HBM.xml is as follows : from Reports as rep left join rep.parts as parts I am getting the following exception while executing the code : May 19,…

  Read the article

• How can I convert data encoded in WE8MSWIN1252 to utf8 for use in Python scripts?

  - by James Dean

  This data comes from an Oracle database and is extracted to flatfiles in encoding 'WE8MSWIN1252'. I want to parse the data and do some analysis. I want to see the text fields but do not need to publish the results to any other system so if some characters do not get converted perfectly I do not…

  Read the article

• Should we put our Reporting data warehouse on our Transaction database Server.

  - by DrFloyd5

  We are about to add a Reporting Data Warehouse to our system. Currently we are using Oracle 10g for our transaction database. Should we put the Reporting Warehouse on physically different hardware? or can we "go cheap" and share the Transaction Server?

  Read the article

• Recursive SQL giving ORA-01790

  - by PenFold

  Using Oracle 11g release 2, the following query gives an ORA-01790: expression must have same datatype as corresponding expression: with intervals(time_interval) AS (select trunc(systimestamp) from dual union all select (time_interval + numtodsinterval(10, 'Minute')) from intervals…

  Read the article

• The entity framework and database agnostic programming, possibilities?

  - by Theo

  We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too. It should be easy to switch the db vendor by some setting in a config file. Is this possible? I prefer real life examples! What kind of providers did…

  Read the article

• Group functions of outer query inside inner query

  - by superdario

  Hello, I'm using Oracle. I'm trying to compose something like this: SELECT trans_type, (SELECT parameter_value FROM transaction_details WHERE id = MAX(t.trans_id)) FROM (SELECT trans_id, trans_type FROM transactions) t GROUP BY trans_type So, I am trying to use a result of grouping inside…

  Read the article

• Convert a value based on range

  - by Chris

  I need to convert a number to another value based on a range: ie: 7 = "A" 106 = "I" I have a range like this: from to return-val 1 17 A 17 35 B 35 38 C 38 56 D 56 72 E 72 88 F 88 98 G 98 104 H 104 115 I 115 120 J 120 123 …

  Read the article

• The order of a SQL Select statement without Order By clause

  - by Yousui

  As I know, from the relational database theory, a select statement without an order by clause should be considered has not particular order. But actually in SQL Server and Oracle (I've tested on those 2 platforms), if I query from a table without an order by clause multiple times, I always…

  Read the article

< Previous Page | 415 416 417 418 419 420 421 422 423 424 425 426  | Next Page >