Search Results

Search found 23653 results on 947 pages for 'oracle workforce management'.

Page 233/947 | < Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >

• Good way to deal with comma seperated values in oracle

  - by dmitry

  I am getting passed comma seperated values to a stored procedure in oracle. I want to treat these values as a table so that I can use them in a query like: select * from tabl_a where column_b in (<csv values passed in>) What is the best way to do this in 11g? Right now we are looping through these one by one and inserting them into a gtt which I think is ineffecient. Any pointers?

  Read the article

• SQL Database Management Survey

  Win one of two $50 Amazon vouchers by entering our database management survey. We’re finding out more about how SQL database professionals are doing backup and recovery, using cloud services and more. Answer the short survey for a chance to win. Learn Agile Database Development Best PracticesAgile database development experts Sebastian Meine and Dennis Lloyd are running day-long classes designed to complement Red Gate’s SQL in the City US tour. Classes will be held in San Francisco, Chicago, Boston and Seattle. Register Now.

  Read the article

• Exporting database on oracle

  - by Adomas

  Hi, I have a DB on oracle on Windows Server 2003. How do I export it with all the data and put it into other Windows server?

  Read the article

• Oracle Age calculation from Date of birth and Today

  - by Jasim

  I want to calculate present Age from Date of Birth in my oracle function. for that i am using (Today-Dob)/30/12. But this is not accurate as some months will have 31 days. I want to get the correct date with maximum precision How ca i do that??

  Read the article

• The report you requested requires further information (Oracle database)

  - by Migdalia Santiago

  Hi, I have a simple application in C# (Visual Studio 2005) that display a Crystal Reports report (Crystal Reports X1 R2). When I compiled the application it appears the following message: The report you requested requires further information. I want to set the connection info in the code so the application doesn't ask the user for the database password. It's a Oracle database.

  Read the article

• java mapping for oracle number type

  - by aauser

  I have database with oracle number type. Could there any possible issues with using java Double when updating table with numeric column. Should i switch BigDecimal or Double is approriate type. As I fas as I know, BigDecimal is used when arbitrary precision required, when deal with prices for example. Consider simple API updatePrice(Double d) Should i persist double as is or BigDecimal.valueOf(d) is preferable ?

  Read the article

• Oracle JPublisher

  - by Debuger

  Hi! I want to know why we need to use JPublisher? And maybe someone can give good tutorials using Oracle JPublisher for beginners? Best regards!

  Read the article

• EAIESB is pleased to announce the release of book “Oracle Service Bus (OSB) in 21 days: A hands on guide for OSB”.

  - by JuergenKress

  It is available for order and signed copies are available through our website. For more information, Visit the below links. http://www.eaiesb.com/OSBin21daysbook.html http://eaiesb.com/OSBin21days.html For more information, visit the below links. http://www.eaiesb.com/OSBin21daysbook.html & http://eaiesb.com/OSBin21days.html. SOA & BPM Partner Community For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit  www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center. Blog Twitter LinkedIn Mix Forum Technorati Tags: OSB,EAIESB,OSB 21 days,SOA Community,Oracle SOA,Oracle BPM,Community,OPN,Jürgen Kress

  Read the article

• 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

• Exporting many tables on Oracle

  - by Adomas

  Hi, I would like to know, how to export many tables from oracle DB. I use exp.exe, create file expdat.dmp and so on. I choose to export only tables and there I must write which ones. Is there any chance of getting all of them? thanks

  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 are returned twice? Without order by the result is correct.. but not sorted. We are using Oracle 10g Any ideaS?

  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 tried something with the below query, but not getting the desired o/p select * from X pivot (sum(amount) for days in ('Day1', 'Day2')) Please help I'm using Oracle 11 G

  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

• 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. ??·??????????????????????·?????Oracle??????????????SOA Suite 11g R1 (11.1.1.2.0)???·??????? ?????????????????Oracle??????????????????????????????????SOA Suite 11g R1 (11.1.1.3.0)?SOA Suite 11g R1 (11.1.1.2.0)????????????????????????????? ??Oracle Technology Network???????·??????·???????????????????????????????? Q. ??????????????????????????????? A. ?????????????????????????????? Product Version Required Product WebLogic Server Repository Creation Utility JDeveloper 11.1.1.2 10.3.2 11.1.1.2.1 11.1.1.2.0 11.1.1.3 10.3.3 11.1.1.3.0 11.1.1.3.0 ????? ??????????????????????????

  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 this function do thanks nil

  Read the article

• Combining a content management system with ASP.NET

  - by Ek0nomik

  I am going to be creating a site that seems like it requires a blend of a content management system (CMS) and some custom web development (which is done in ASP.NET MVC). I have plenty of web development experience to understand the ASP.NET MVC side of the fence, but, I don't have a lot of CMS knowledge aside from getting one stood up. Right now my biggest question is around integrating security from ASP.NET with the CMS. I currently have an ASP.NET MVC site that handles the authentication for multiple production sites and creates an authentication cookie under our domain (*.example.com). The page acts like a single sign on page since the cookie is a wildcard and can be used in any other applications of the same domain. I'd really like to avoid having users put in their credentials twice. Is there a CMS that will play well with the ASP.NET Forms Authentication given how I have these existing applications structured? As an aside, right now I am leaning towards Drupal, but, that isn't finalized.

  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

• CMSs & ERPs for hospital management system

  - by Akshey

  Hi, What are the best free CMSs or CMS plugins or ERPs or any other free tools available for developing a hospital management system? I want to develop it for a children's hospital run by my father. The hospital is small with two doctors. Currently, everything is done manually on paper. The main entities who will be using the system are: Receptionist, the two doctors, chemist and the medical laboratorist. They will use it majorly for keeping the records of the patient. The patients would not be interacting with the system directly. The system needs to be user friendly and should be easy to learn. I was thinking to develop such a system using a CMS or an ERP or any other free tool. I have used wordpress/drupal in past but never used an ERP. Can you please guide me to make such a system using free, and preferably open source, tools? Thanks, Akshey

  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

• 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

• 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

• 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 column and so on. Will this design have any bad side effects? Please suggest.

  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 query must be compatible oracle 8i. Thanks.

  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 for the above situation. I understand that the use of a cursor is required to loop through the table in Oracle, but is there any way to keep the above code the same and accomplish the same thing? Thanks in advance.

  Read the article

< Previous Page | 229 230 231 232 233 234 235 236 237 238 239 240  | Next Page >