Search Results

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

Page 188/827 | < Previous Page | 184 185 186 187 188 189 190 191 192 193 194 195  | Next Page >

• Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

  - by WENzER

  How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle?

  Read the article

• Oracle vocabulary, what is the mysql/SQL Server equivalent of a database

  - by jeph perro

  Hi, I need some help with vocabulary, I don't use Oracle that often but I am familiar with MySQL and SQL Server. I have an application I need to upgrade and migrate, and part of the procedure to do that involves exporting to an XML file, allowing the installer to create new database tables, then import to the new database tables from the XML…

  Read the article

• Oracle vocabulary, what is the mysql/mssql equivalent of a database

  - by jeph perro

  Hi, I need some help with vocabulary, I don't use Oracle that often but I am familiar with MySQL and MSSQL. I have an application I need to upgrade and migrate, and part of the procedure to do that involves exporting to an XML, create new database tables, then populate the new database tables from the XML export. In Oracle, my database…

  Read the article

• Oracle: set timezone for column

  - by dbf

  Hi, I need to do migration date-timestamp with timezone similar to described here: http://stackoverflow.com/questions/1664627/migrating-oracle-date-columns-to-timestamp-with-timezone. But I need to make additional convertion (needed to work correctly with legacy apps): for all dates we need to change timezone to UTC and set time to 12:00…

  Read the article

• Microsoft T-SQL to Oracle PL/SQL translation

  - by Michael Prewecki

  I've worked with T-SQL for years but i've just moved to an organisation that is going to require writing some Oracle stuff, probably just simple CRUD operations at least until I find my feet. I'm not going to be migrating databases from one to the other simply interacting with existing Oracle databases from an Application Development…

  Read the article

• how to use different oracle character sets in one application

  - by Peter Shower

  Hi Guys, i'm developing a 32bit Client-Application with Delphi. From this application I need to connect to databases on two different servers. First databse character set ist WE8MSWIN1252, the other server decodes with WE8PC850. Setting the client NLS_LANG parameter to the correct value solves correct sql-query results. …

  Read the article

• how to change the delimiter in sqlplus in oracle 11g

  - by Nubkadiya

  i want to change the delimiter can someone help me to change the delimiter in sqlplus in Oracle 11g

  Read the article

• oracle replace comma with period and period with comma

  - by Atul

  How to change comma with period and period with comma e.g. 1,50,000.25 to 1.50.000,25 in oracle

  Read the article

• open source alternatives to oracle coherence?

  - by Blankman

  Are there any open source alternatives to oracle coherence? (btw, how much does coherence cost anyways?)

  Read the article

• Oracle AQ dequeue order

  - by yawn

  A trigger in an Oracle 10g generates upsert and delete messages for a subset of rows in a regular table. These messages consist out of two fields: A unique row id. A non-unique id. When consuming these message I want to impose an order on the deque process that respects the following constraints: Messages must be…

  Read the article

• C# Drawing Oracle Spatial Geometries

  - by Keeper

  I need to create a simple app which can display geometries from Oracle Spatial in C#. These geometries are exported from AutoCAD Map 3D 2010 to Oracle Spatial. I need to pan, zoom, manage layers of these objects, events (like right click to popup a contextual menu, potentially different for every object),…

  Read the article

• Is there a Oracle equivalent of mysqldump

  - by Rakhitha

  Is there a way to dump the content of a oracle table in to a file formated as INSERT statements. I can't use oradump as it is on GPL. I will be running it from a perl CGI script. I am looking for something to dump data directly from oracle server using a single command. Running a select and creating insert…

  Read the article

• Oracle on Mac OS X Snow Leopard

  - by Steve

  Hi, I am trying to install oracle on snow leopard using these guidelines. http://blog.rayapps.com/2009/09/14/how-to-install-oracle-database-10g-on-mac-os-x-snow-leopard/ There is a step in the installation, where I have to change netca and dbca such that it runs in 32 bit mode. Can someone please tell me…

  Read the article

• Types of Index in oracle?

  - by P Sharma

  What are the type of indexes in oracle? How to identify the index need to create?

  Read the article

• Oracle: '= ANY()' vs. 'IN ()'

  - by eidylon

  Hi all, I just stumbled upon something in ORACLE SQL (not sure if it's in others), that I am curious about. I am asking here as a wiki, since it's hard to try to search symbols in google... I just found that when checking a value against a set of values you can do WHERE x = ANY (a, b, c) As opposed…

  Read the article

• In Oracle 10g, how do I see tables in schemes other than system

  - by Yasir Arsanukaev

  In the hr schema there's a table emloyees, I can query data from it specifying it implicitly SELECT count(*) FROM hr.employees while logged in as system, but when I navigate to Home-Object Browser in the browser I can't see the table employees and other tables in other schemas. Can I manage tables in…

  Read the article

• Help Auditing in Oracle

  - by enrique

  Hello everybody I need some help in auditing in Oracle. We have a database with many tables and we want to be able to audit every change made to any table in any field. So the things we want to have in this audit are: user who modified time of change occurred old value and new value so…

  Read the article

• the MVCC effect on migration from oracle to db2

  - by Ryan Fernandes

  I have a simple (actually simplified :) ) scenario that is possibly the cause for the headache I've been having for the last few days... My current application (that serves 100's of users) currently uses Oracle as the database. I have no stored procs (I wish actually). Now, I've been asked if the…

  Read the article

• Execute Oracle RAC cluster commands via Solaris RBAC?

  - by David Citron

  Executing Oracle RAC cluster management commands such as $ORA_CRS_HOME/bin/crs_start requires root permissions. Using Solaris RBAC (Role-Based Access Control), one can give a non-root user permissions to execute those commands, but the commands still fail internally. Example: $pfexec…

  Read the article

• oracle function like days360 in excel

  - by Jasim

  Is there any oracle functions which will return the number of days between two dates like days360 function in excel?

  Read the article

• Oracle table fragmentation

  - by Manish Mathai

  How do I fragment a table so that it is distributed over multiple oracle 9i servers.

  Read the article

• Major performance difference between two Oracle database instances

  - by jrdioko

  I am working with two instances of an Oracle database, call them one and two. two is running on better hardware (hard disk, memory, CPU) than one, and two is one minor version behind one in terms of Oracle version (both are 11g). Both have the exact same table table_name with exactly…

  Read the article

• quering an external oracle db in rails application

  - by railscoder

  I have a website which useses a mysql database for its whole operation . But for a new requirement i need to query a external oracle database( used by other component) and compile a list of items and display in a page in the website. How is it possible to connect to a external…

  Read the article

• OJB / Oracle XE sql debug-display problem

  - by Jay

  Hello, I have a Java application, and use OJB as my ORM technology. I have an Oracle XE installation locally to develop against. The problem is when I need to debug a problem, I like looking at the SQL output. Here is an example of SQL I can view through the "Top SQL"…

  Read the article

• Migrate a Django project from MySQL to Oracle

  - by pablo

  Hi, I have a Django1.1 project that works with a legacy MySQL db. I'm trying to migrate this project to Oracle (xe and 11g). We have two options for the migration: - Use SQL developer to create a migration sql script. - Use Django fixtures. The schema created with the…

  Read the article

< Previous Page | 184 185 186 187 188 189 190 191 192 193 194 195  | Next Page >