Search Results

Search found 41452 results on 1659 pages for 'oracle database appliance'.

Page 282/1659 | < Previous Page | 278 279 280 281 282 283 284 285 286 287 288 289  | 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

• How to represent a Many-To-Many relationship in XML or other simple file format?

  - by CSharperWithJava

  I have a list management appliaction that stores its data in a many-to-many relationship database. I.E. A note can be in any number of lists, and a list can have any number of notes. I also can export this data to and XML file and import it in another instance of my app for sharing lists between users. However, this is based on a legacy system where the list to note relationship was one-to-many (ideal for XML). Now a note that is in multiple lists is esentially split into two identical rows in the DB and all relation between them is lost. Question: How can I represent this many-to-many relationship in a simple, standard file format? (Preferably XML to maintain backwards compatibility)

  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

• Unique constraint on more than 10 columns

  - by tk

  I have a time-series simulation model which has more than 10 input variables. The number of distinct simulation instances would be more than 1 million, and each simulation instance generates a few output rows every day. To save the simulation result in a relational database, i designed tables like this. Table SimulationModel { simul_id : integer (primary key), input0 : string or numeric, input1 : string or numeric, ...} Table SimulationOutput { dt : DateTime (primary key), simul_id : integer (primary key), output0 : numeric, ...} My question is, is it fine to put an unique constraint on all of the input columns of SimulationModel table? If it is not a good idea, then what kind of other options do i have to make sure each model is unique?

  Read the article

• Best datastructure for this relationship...

  - by Travis

  I have a question about database 'style'. I need a method of storing user accounts. Some users "own" other user accounts (sub-accounts). However not all user accounts are owned, just some. Is it best to represent this using a table structure like so... TABLE accounts ( ID ownerID -> ID name ) ...even though there will be some NULL values in the ownerID column for accounts that do not have an owner. Or would it be stylistically preferable to have two tables, like so. TABLE accounts ( ID name ) TABLE ownedAccounts ( accountID -> accounts(ID) ownerID -> accounts(ID) ) Thanks for the advice.

  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

• 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

• 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

• 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

• Inserting asyncronously into Oracle, any benefits?

  - by Karl Trumstedt

  I am using ODP.NET for loading data into Oracle. I am bulking inserts into groups of a 1000 rows each call. Is there any performance benefits in calling my load method asynchronously? So say I want to insert 10000 rows, instead of making 10 calls synchronously I make 10 calls asynchronously. My database is using ASSM right now but otherwise plenty of freelists are used of course. The database server has several cores as well. My initial tests seem to point to a performance increase, but maybe there is something I cannot see? Potential deadlock or contention issues? Of course, there is added complexity in handling transactions and such doing my load this way.

  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 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

• 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 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

• 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

• 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

• Should I Split Tables Relevant to X Module Into Different DB? Mysql

  - by Michael Robinson

  I've inherited a rather large and somewhat messy codebase, and have been tasked with making it faster, less noodly and generally better. Currently we use one big database to hold all data for all aspects of the site. As we need to plan for significant growth in the future, I'm considering splitting tables relevant to specific sections of the site into different databases, so if/when one gets too large for one server I can more easily migrate some user data to different mysql servers while retaining overall integrity. I would still need to use joins on some tables across the new databases. Is this a normal thing to do? Would I incur a performance hit because of this?

  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

• 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 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

• How should I build a simple database package for my python application?

  - by Carson Myers

  I'm building a database library for my application using sqlite3 as the base. I want to structure it like so: db/ __init__.py users.py blah.py etc.py So I would do this in Python: import db db.users.create('username', 'password') I'm suffering analysis paralysis (oh no!) about how to handle the database connection. I don't really want to use classes in these modules, it doesn't really seem appropriate to be able to create a bunch of "users" objects that can all manipulate the same database in the same ways -- so inheriting a connection is a no-go. Should I have one global connection to the database that all the modules use, and then put this in each module: #users.py from db_stuff import connection Or should I create a new connection for each module and keep that alive? Or should I create a new connection for every transaction? How are these database connections supposed to be used? The same goes for cursor objects: Do I create a new cursor for each transaction? Create just one for each database connection?

  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

< Previous Page | 278 279 280 281 282 283 284 285 286 287 288 289  | Next Page >