Search Results

Search found 14428 results on 578 pages for 'oracle clinical'.

Page 185/578 | < Previous Page | 181 182 183 184 185 186 187 188 189 190 191 192  | Next Page >

• Correct way to give users access to additional schemas in Oracle

  - by Jacob

  I have two users Bob and Alice in Oracle, both created by running the following commands as sysdba from sqlplus: create user $blah identified by $password; grant resource, connect, create view to $blah; I want Bob to have complete access to Alice's schema (that is, all tables), but I'm not sure what grant to run, and whether to run it as…

  Read the article

• Oracle sequence but then in MS SQL Server

  - by Raymond

  In Oracle there is a mechanism to generate sequence numbers e.g.; CREATE SEQUENCE supplier_seq MINVALUE 1 MAXVALUE 999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20; And then execute the statement supplier_seq.nextval to retrieve the next sequence number. How would you create the same functionality in MS…

  Read the article

• Create Variable In Oracle

  - by GigaPr

  Hi What is the equivalent of DECLARE @Variable INT SET @Varialbe = 1 in Oracle? Thanks

  Read the article

• Excel Spreadsheet - Best way to perform an Oracle Query on a cell

  - by Jamie

  Hi there, I have an Excel Spreadsheeet. There is a cell containing a concatenated name and surname (don't ask why), for example: Cell A2 BLOGGSJOE On this cell, I would like to run the following SQL and output it to cell A3, A4 and A5 SELECT i.id, i.forename, i.surname FROM individual i WHERE UPPER(REPLACE('" & A2 & "', ' ', '')) = …

  Read the article

• How to use DML on Oracle temporary table without generating much undo log

  - by Sambath

  Hi, Using an Oracle temporary table does not generate much redo log as a normal table. However, the undo log is still generated. Thus, how can I write insert, update, or delete statement on a temporary table but Oracle will not generate undo log or generate as little as possible? Moreover, using /+append/ in the insert statement will generate…

  Read the article

• copying oracle to sqlserver 2005 jdbc

  - by kbb

  Is there any way of copying a database from oracle to sqlserver 2005? Thanks

  Read the article

• IIS 8 - PHP Manager - Enabling php_oci8.dll for Oracle Connection

  - by Jemru

  I would need to connect to Oracle DB in my PHP codes. I'm using Windows Server 2012, IIS 8 with PHP Manager. I opened IIS PHP Manager, then go to PHP Extensions, then I enabled "php_oci8.dll" extension. However when I tried to connect to Oracle DB I'm getting the following PHP error: PHP Fatal error: Call to undefined function oci_connect()…

  Read the article

• SQL Compare-Like tool for Oracle?

  - by Hitchhiker

  We're a .NET team which uses the Oracle DB for a lot of reasons that I won't get into. But deployment has been a bitch. We are manually keeping track of all the changes to the schema in each version, by keeping a record of all the scripts that we run during development. Now, if a developer forgets to check-in his script to the source control…

  Read the article

• JPA EclipseLink Auditing for Oracle issue with SessionCustomizer...

  - by enrique

  I was trying to use the SessionCustomizer for auditing with v$session.program for oracle and it works with JDBC but i need it working with JPA, so i read a bit more the documentation for SESSION_CUSTOMIZER in this site:…

  Read the article

• How to synchronize two DataBase Schemas Oracle 10G?

  - by gnash-85

  Hi Masters, Good Day, I am new and very naive to Oracle DB. I am using Oracle 10G. Let me explain to you. I have one source database named ( DB1) and Target Database named (DB2). I have 2 schema's named dbs1 and…

  Read the article

• Can you use Microsoft Entity Framework with Oracle?

  - by Xerx

  Is it possible to use Microsoft Entity Framework with Oracle database?

  Read the article

• Is there anyway to make Oracle faster?

  - by Husky110

  Hey people! I guess you people know more about this, than the ServerFault-Peps - If I'm wrong please correct me! Maybe you experienced it with the Oracle-Databasesystem too that it could use a hell of…

  Read the article

• SQL Server and Oracle Extended/External Procedures Compatibility

  - by BeginnerAmongBeginners

  Is a extended/external stored procedure written in C and currently working under SQL Server viable to work under Oracle as well?

  Read the article

• How do I get the NextVal from an oracle Sequence thru NHibernate

  - by trainer

  I am working on c# .net 4.0 and using NHibernate to talk with an Oracle DB. You would think something as simple as this is already addressed somewhere but sadly its not. I need the NextVal from an…

  Read the article

• 2 DataBase Schema's syncronization in Oracle 10G

  - by gnash-85

  Hi Masters, Good Day, I am new very naive to oracle DB. I am using Oracle 10G. Let me explain to you. I have one source database named ( DB1) and Target Database named (DB2). I have 2…

  Read the article

• Subsonic 3.0 Settings ttinclude for Oracle ?

  - by Hoqwert

  Is there any subsonic settings.ttinclude template file for oracle db.

  Read the article

• Passing an array of structures to an Oracle stored procedure (CFMX)

  - by Patti

  I'm looking to write a Oracle stored procedure where I would pass in (from ColdFusion) an array of structures and loop over each iteration to insert the bits and pieces within the…

  Read the article

• How can I connect PHP 5.1 to Oracle 7?

  - by Travis Beale

  I have been able to query newer Oracle databases using the PHP oci8 extension with the Oracle 10.2 Instant Client. Unfortunately, the Oracle Instant Client seems to be unable to…

  Read the article

• Oracle ORA-01795 error in Rails

  - by Cyborgo

  Hi, I am using Oracle as database for my Rails applications and have got some pretty intense tables. I'm trying to find the particular entries using a query like this …

  Read the article

• Oracle checking existence before deletion in a trigger

  I have analyzed a hibernate generated oracle database and discovered that a delete of a row from a single table will spawn the firing of 1200+ triggers in order to…

  Read the article

• Improving performance for WRITE operation on Oracle DB in Java

  - by Lucky

  I've a typical scenario & need to understand best possible way to handle this, so here it goes - I'm developing a solution that will retrieve data from a…

  Read the article

• oracle datetime field indexing

  - by Milee

  Hi, How do we perform indexing on a datetime field in oracle. We should be able to search for a specific year Thanks

  Read the article

• Oracle: get list of all tables?

  - by vitule

  How do I query an Oracle database to display the names of all tables in it?

  Read the article

• Oracle: Difference in execution plans between databases

  - by Will

  Hello, I am comparing queries my development and production database. They are both Oracle 9i, but almost every single query has a completely different…

  Read the article

• Oracle UCM Integration with WebCenter

  - by john.brunswick

  Portal deployments always contain some level of content that requires management. Like peanut butter and jelly, the ying and yang, they are inseparable.…

  Read the article

< Previous Page | 181 182 183 184 185 186 187 188 189 190 191 192  | Next Page >