Search Results

Search found 15044 results on 602 pages for 'oracle crm'.

Page 297/602 | < Previous Page | 293 294 295 296 297 298 299 300 301 302 303 304  | Next Page >

• How to Spool UTF-8 format data in Oracle database into text file

  - by Rocky

  How to Spool UTF-8 format data in Oracle database into text file with all UTF-8 Chars comming porperly. UTF-8 Characters example Chinese characters. I am trying to spool data from oracle data base which is UTF-8 enabled and trying to spool the same data into txt or cvs.Instead of the chinese charcters i am getting ????.

  Read the article

• Are products like MSSQL Server and Oracle are "ORDBMS"?

  - by n10i

  According to wikipedia! http://en.wikipedia.org/wiki/ORDBMS IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!

  Read the article

• How can I keep Oracle SQL Developer from closing the DB connection?

  - by Kevin Babcock

  Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes during a long-running query SQL Dev will just close the connection, leaving my query running on the server but me with no results. If I RDP into the server and run SQL Dev locally it never seems to have this problem.

  Read the article

• What Date Format Should I Send When Using Oracle.DataAcess.

  - by discwiz

  Converting from usind Micorsofts Syste.Data.OracleClient to what I believe is called Oracles ODT (Oracle.DataAccess 10.2.0.100). When I try and send a date I get this error "ORA-1858: a non-numeric character was found where a numeric was expected". This code worked great using System.Data.OracleClient. cmd.Parameters.Add(New OracleParameter("I_FIRST_LOSS_EVENT_DATE", OracleDbType.Date)).Value = .LossEventsMessages(0).LossEventTime Thanks, Dave

  Read the article

• Why is an oracle sequence named hibernate_sequence being created with JPA using Hibernate with the O

  - by JavaRocky

  All my entities use this type of @Id @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "MYENTITY_SEQ") @SequenceGenerator(name = "MYENTITY_SEQ", sequenceName = "MYENTITY_SEQ") @Column(name = "MYENTITY", nullable = false) private Long id; Or @Id @Column(name = "MYENTITY") I find that an oracle sequence named hibernate_sequence is always created. Why is this so? And how can i avoid this? I am using JPA1 with Hibernate 3 and the Oracle 10g dialect.

  Read the article

• Can't get UpdateAttributeRequest to work

  - by dsabater

  I am trying to use the Metadata Web Service of Dynamics CRM to update the order of some picklist options using the UpdateAttributeRequest message. Though I get to change the attribute's DisplayName using the MergeLabels = false option, the picklist option values themselves seem immutable.

  Read the article

• What is the limit on number of columns in Oracle 10G and Derby Databases.

  - by Fazal

  Until recently I thought limit on number of columns in Oracle DB was 255. But turns out the limit is 1000. Can someone confirm this? Also I was trying to find if there is any similar limit on number of columns in Derby DB, particularly embedded derby java DB

  Read the article

• Tools to generate an database diagram/ER diagram from existing Oracle database?

  - by Kb

  Looking for tools on a windows platform to genereate ER diagram (or similar) from an existing Oracle database. Any good tools out there that are free to use or low cost?

  Read the article

• Display query results like \G in MySQL when using Oracle / sqlplus?

  - by jed79

  In MySQL, you can use \G to run a query: select * from mytable\G And your results will be displayed in an inverted table, kinda like this: *************************** 1. row *************************** column1: 12345 another_colum: another value yet_another: ABCD *************************** 2. row *************************** column1: 238479 another_colum: another value again yet_another: WXYZ Is there any way to get a similar format using Oracle / sqlplus?

  Read the article

• What's the difference between OracleServiceORAL service(on Window XP) and Oracle instance?

  - by Yousui

  Hi guys, I want to know what's the difference between OracleServiceORAL service(on Window XP) and Oracle instance. Great thanks.

  Read the article

• devArt's dotConnect for Oracle vs. ODP.net/OCI performanc.

  - by Sieg

  Does anybody have any experience going from ODP.net to devArt's dotConnect for Oracle? Some initial testing is showing Direct Connect in 64bit dotConnect running 30% slower at times than our original ODP.net/OCI 32 bit solution. Trying to determine if that's normal or if something may be wrong in my testing approach. Thanks!

  Read the article

• How to identify what locked PL/SQL package (Oracle 10.0.4.2)?

  - by Roman Kagan

  I was trying to recompile PL/SQL package and no avail. because something obtained the lock and that wasn't released for long time. As soon as I kill all sessions I was able to recompile but encounter the same behavior (i.e. locked package) and I wonder what tools are avail to identify what could of obtain it and never release it? This happen on (Oracle 10.0.4.2). Greatly appreciate for your help.

  Read the article

• Are products like SQL Server and Oracle are "ORDBMS"?

  - by n10i

  According to wikipedia! http://en.wikipedia.org/wiki/ORDBMS IBM's DB2, Oracle database, and Microsoft SQL Server, make claims to support this technology and do so with varying degrees of success So, are these products true "ORDBMS" like PostgreSQL? or they are they are long way from it? can someone plz! point me to any link where i can read about the features still to be implemented by these RDBMS to become true ORDBMS!

  Read the article

• Is there an SQL Server equivalent to Oracle's RETURNING statement?

  - by Thomas Bratt

  Is there an SQL Server equivalent to Oracle's RETURNING statement? I'm wondering if the OUTPUT clause would help.

  Read the article

• Using Oracle Sequence in SQL Loader?

  - by Sujee

  Hi, I am using SEQUENCE keyword in SQL Loader control file to generate primary keys. But for a special scenario I would like to use Oracle sequence in the control file. The Oracle documentation for SQL Loader doesn't mentioned anything about it. does SQL Loader support it?

  Read the article

• Is is possible/a good idea to edit workflows in Visual Studio?

  - by Greg McGuffey

  I've been doing a lot of editing in MS Dynamics CRM 4.0 using the web designer. I'm wondering if there is a more efficient way to edit workflows and wondering if VS 2008 could be used (and if it is more efficient). If so how? Thanks!

  Read the article

• Oracle Secure Enterprise Search(SES) Intranet crawling problem.

  - by vipin k.

  I am using oracle Oracle Secure Enterprise Search(SES), and using the crawler to crawl the Intranet site. but i am getting the error. EQG-30008: http://site-name/: Not found I have added the Log on password and user name and also added the proxy settings. Any body who worked on SES crawling,please look in.

  Read the article

• How can I sum number of rows of a table in SQL ORACLE?

  - by Christian Magro

  Dear community I have the follow instruction on SQL ORACLE: SELECT COUNT(FE_DAY) FROM TI_DATE WHERE (FE_MO = 02 AND FE_YEAR in ('2011', '2012')) GROUP BY FE_DAY In this instruction effectively obtain like SQL Answer a list of number that they sum=10 .But How can I don't show rows .I need only show the row's sum=10 I tried to apply the follow SQL instruction also: SELECT SUM(COUNT(FE_DAY)) FROM TI_DATE WHERE (FE_MO = 02 AND FE_YEAR in ('2011', '2012')) GROUP BY FE_DAY But the answer was 57, different of the number of rows, that I need.

  Read the article

• how do I execute a function from TOAD for Oracle and bind the result to a data grid

  - by neesh

  I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle?

  Read the article

• CR Oracle ODBC driver

  - by Avg

  Hi, I have Crystal report 10 and need to connect to oracle db. Am looking for CR Oracle ODBC driver. Where can i get it from.Please help.

  Read the article

• How can we create menu in oracle report 10 g.

  - by saadkundi

  I want to create a menu in oracle report 10g. Tell me how i can do it. thanks

  Read the article

• how do I call a function from TOAD for Oracle and bind the result to a data grid

  - by neesh

  I have a function that takes as one of it's arguments a VARRAY of pl/sql Objects. How do I execute this stored procedure and bind the resultset that it returns to a data grid in TOAD for Oracle?

  Read the article

• Why doesn't Oracle SQL allow us to use column aliases in GROUP BY clauses?

  - by Mehper C. Palavuzlar

  This is a situation I'm generally facing while writing SQL queries. I think that writing the whole column (e.g. long case expressions, sum functions with long parameters) instead of aliases in GROUP BY expressions makes the query longer and less readable. Why doesn't Oracle SQL allow us to use the column aliases in GROUP BY clause? There must be an important reason behind it.

  Read the article

• Is there any less or more convenient iDoc Script editor for Oracle 10g UCM?

  - by Artic

  Is there any less or more convenient iDoc Script editor for Oracle 10g UCM? Please help. Open to any suggestions. Avoid suggesting notepad and so on.

  Read the article

• How can I replicate an Oracle 11g database(data+structure) on my local machine for development?

  - by bron

  I am working on a test server with an Oracle 11g installed. I was wondering if there is anyway I can replicate the database(environment + data) on my local Linux machine. I am using a CentOS 5.3 on Windows XP with SUN Virtual Box. On Windows I am using sqldeveloper client to connect to the 11g database.

  Read the article

< Previous Page | 293 294 295 296 297 298 299 300 301 302 303 304  | Next Page >