Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Managing error handling while running sqlplus from shell scripts

#!/bin/sh echo "Please enter evaluate database username" read eval_user echo "Please enter evaluate database password" read eval_pass …

oracle shell sqlplus aix
Oracle - Select where field has lowercase characters

I have a table, users, in an Oracle 9.2.0.6 database. Two of the fields are varchar - last_name and first_…

sql oracle select indexing case-sensitive
Deploying and Configuring ODP.NET to work without installation with Entity Framework

How do you deploy and configure ODP.NET to work without installation with Entity Framework? A. How to deploy and …

oracle entity-framework app-config odp.net dataprovider
Delete all contents in a schema in Oracle

Is possible to delete all contents in scheme in Oracle? I found this script: Begin for c in (select table_…

sql oracle plsql
Connect SQLplus in oracle

I want to connect user sys in sqlplus of oracle but after I connect, I type like this: sqlplus sys …

oracle sqlplus
Oracle trim whitespace on the inside of a string

I am storing phone numbers as VARCHAR2 in my system to allow for users to input '+' characters infront …

sql oracle whitespace removing-whitespace
C#: Oracle Data Type Equivalence with OracleDbType

Situation: I am creating an app in C# that uses Oracle.DataAccess.Client (11g) to do certain operations on a …

c# oracle plsql types type-equivalence
Custom Order in Oracle SQL

I need to order transaction based on the currency. However I need to implement a custom order by, which makes …

sql oracle sql-order-by
ROWID (oracle) - any use for it?

My understanding is that the ROWID is a unique value for each row in the result returned by a query. …

database oracle rowid