Search Results

Search found 20675 results on 827 pages for 'oracle blogs'.

Page 204/827 | < Previous Page | 200 201 202 203 204 205 206 207 208 209 210 211  | Next Page >

• Java - creating an oracle date field

  - by llm

  I have an Oracle Date type to which I need to insert the current date. I am using Java to generate this date but everything I've tried so far yeilds the following error: java.sql.SQLException: ORA-01843: not a valid month Can anyone suggest java code to generate a proper date?

  Read the article

• SQL use DISTINCT with ORDER BY (Oracle)

  - by ArneRie

  Hi, i have an strange problem. I want to select "timestamps" from an DB Table with Distinct and orderded by timestamp. ID TimeStamp -- --------- 1 123456789 2 123456789 3 333333333 4 334345643 In my PHP Script: $sql = "SELECT DISTINCT TIMESTAMP FROM TIMESTAMPS ORDER BY TIMESTAMP" When i use order by, the values…

  Read the article

• Oracle Rows into Columns

  - by user2904845

  Can someone help me design the query to get below o/p. Data I have: Table X: Count Name Amount Days 5 ABC 500 Day1 10 ABC 1000 Day2 3 BCD 100 Day1 4 BDC 200 Day2 Result I need: Name Count AmountDay1 Count AmountDay2 ABC 5 500 10 1000 BCD 3 100 4 200 etc Is this Possible? I…

  Read the article

• Oracle Fusion Middleware 11g (11.1.1.3.0) ?????????

  - by Hiroyuki Yoshino

  ????Media Pack??????????????????????1, 2???????????????? ??????????????????????Oracle Fusion Middleware 11g (11.1.1.3.0)??????????????????????????FAQ????????????????????????????????? (?????????????????????????????) ????FAQ????????? Q. Oracle Fusion Middleware?????·????????????????? A.…

  Read the article

• this is for oracle apps project module information

  - by nil

  hi to all i m taking about oracle apps project module in project module there was project status inquiry inside that percent complete functionality i want require information what is this functionality and it's update automatically or require run any requites or other please give me information what…

  Read the article

• Oracle 10g express edition import

  - by Jasim

  How can i import a DMP file into my oracle 10g expression edition database? I tried with imp but its showing an error: IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully How can i solve this?

  Read the article

• calender in oracle forms

  - by Mousarules

  Hi guys :) i want to integrate a ready made CALENDER on my oracle forms application whethear it's a java applet or other available option ; i want the end user to be able to invoke this CALENDER whenever he pressed the date button so that he can chose a specific date to be entered in a display item .

  Read the article

• How to optimize an update SQL that runs on a Oracle table with 700M rows

  - by Bruno Rothgiesser

  UPDATE [TABLE] SET [FIELD]=0 WHERE [FIELD] IS NULL [TABLE] is an Oracle database table with more than 700 million rows. I cancelled the SQL execution after it had been running for 6 hours. Is there any SQL hint that could improve performance? Or any other solution to speed that up?

  Read the article

• Oracle equaivalent of java System.currentTimeMillis()?

  - by Gaurav

  Hi, I want to be able to store the current time in millis in an oracle number field. How do I do this via a query? select systimestamp from dual; returns the actual timestamp. Is there anyway that I can convert this into milliseconds the same way java's System.currentTimeMillis() does?

  Read the article

• update multiple rows in oracle

  - by devang

  hi can you tell me how to update multiple rows in oracle as when i fired the update statment it gave me the following error ORA-01427: single-row subquery returns more than one row Thanks in advance

  Read the article

• Characters spilled over multiple columns in Oracle 11g?

  - by vicky21

  This is related to question: How to store unlimited characters in Oracle 11g? If maximum I need is 8000 characters, can I just add 3 more varchar2 columns so that I will have 4 columns with 2000 char each to get 8000 chars. So when the first column is full, values would be spilled over to the next…

  Read the article

• How to get array using Oracle sql query

  - by Yashwant Chavan

  I want to display Years between From date - To date using oracle SQL on dual table e.g. if pass - From date as 1/1/1900 and To Date as 1/1/2000 then it shoold display 1900 1901 - till 2000

  Read the article

• JDBC Code Change From SQL Server to Oracle

  - by BeginnerAmongBeginners

  In the JDBC code, I have the following that is working with SQL Server: CallableStatement stmt = connection.prepareCall("{ call getName() }"); ResultSet rs = stmt.executeQuery(); if(rs != null) { while(rs.next()) { //do something with rs.getString("name") } } Multiple rows are returned…

  Read the article

• Oracle : select maximum value from different comulms of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 The…

  Read the article

• Autoincrement Primary key in Oracle database

  - by GigaPr

  Hi i would like to achieve something like CREATE TABLE RollingStock ( Id NUMBER IDENTITY(1,1), Name Varchar2(80) NOT NULL ); in Oracle how do i do it ? Thanks in advance

  Read the article

• ora-00972 identifier is too long oracle 10g

  - by Frank

  I am getting the error mentioned in the title. I am using a 36 charecter ID. This error is only thrown In my sqldatasource in my asp.net webform. It is not a problem when I perform updates in Oracle sql developer. How can I fix this?

  Read the article

• Oracle Business Intelligence Customers: Have Your Voice Heard in the "2011Wisdom of the Crowds Business Intelligence Market Survey"

  - by tobin.gilman(at)oracle.com

  Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 …

  Read the article

• Date type in oracle does not include time values

  - by Matt

  I have a PHP application using an Oracle XE database. Whenever I add a date the hours minutes, and seconds seem to get left out. Is there some special format, or type I should use to be able to store this? I have tried using to_date, and specifying the format I am using. Many thanks for…

  Read the article

• Lifting the Length Limit of Oracle's Column Identifier to Beyond 30 Characters

  - by BeginnerAmongBeginners

  Can the length limit of Oracle's column identifier be lifted to beyond 30 characters? If so, how do I accomplish that? If not, is there any other workaround that allows me to use a column identifier that has more than 30 characters? Thanks in advance.

  Read the article

• TLS 1.1 with Oracle HTTP Server ?

  - by bazily

  Is there a way to enable TLS 1.1 on Oracle HTTP Server (which I believe is a custom version of Apache)? Right now I'm getting a SSLv3 response and need to use TLS 1.1

  Read the article

• How to create a temporary table in Oracle

  - by GigaPr

  Hi I would like to create a temporary table in a Oracle database something like Declare table @table (int id) In SQL server And than populate it with a select statement Is it possible? Thanks

  Read the article

• Import fixed width file to oracle

  - by Alex Blokha

  Is there an ability to import fixed width file to oracle? Preferably through .net(c#) for catching errors during import and showing them to user. P.S. File has 5 types of rows. For example 1 row has 5 columns, 2-nd has 50 columns.

  Read the article

• Oracle : select maximum value from different columns of the same row

  - by gregseth

  The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name max A 4 B 6 C 5 …

  Read the article

• how to return some default value in oracle cursor when nothing is found

  - by john

  I have following statement in one of the oracle SP: OPEN CUR_NUM FOR SELECT RTRIM(LTRIM(num)) as num FROM USER WHERE USER_ID = v_user_id; When the above does not return anything the SP result just has no column name in it. But I'd like the cursor to still have num column with…

  Read the article

• Oracle on Linux with ASP.NET Windows Authentication Impersonation

  - by user118190

  Can someone please direct me on how to do this type of setup, i.e. I have a Windows Server with ASP.NET pages and would like to pass those credentials using Integrated Windows Authentication to a Linux-based Oracle DB.

  Read the article

< Previous Page | 200 201 202 203 204 205 206 207 208 209 210 211  | Next Page >