Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.
I just installed an acutal XAMPP on my win7 (x64) PC to write some PHP scripts to connect to an …
php oracle apache oracle11g oracleclientI have installed sqlplus based on instruction given here sqlplus 'username/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521))(CONNECT_DATA=(…
oracle sqlplusIn our project I create some global temp table that will be like these: CREATE GLOBAL TEMPORARY TABLE v2dtemp ( …
oracle plsql ddl temp-tablesI recently installed OBIEE 11.1.1.6.0. I imported the repository I had from 11.1.1.5 which was working fine till now. In the administration …
oracle oracle11g business-intelligence obieeI am looking for clarification on this. I am writing two queries below: We have a table of employee name …
sql oracle aggregate-functionsOracle's instructions specify setting LD_LIBRARY_PATH. This makes my application dependent on random users' configuration and is very troublesome …
linux oracle unix instantclientI want to create a job that would drop a database object at a given date. The job created all …
oracle oracle10g dbms-schedulerI have a view and I want to query my view like that to hint some index from a base …
oracle optimization indexing sql-execution-plan hintsI have the following code: case when (a.je_source='Revaluation') then 'No_Location' when d.user_name like ('SCHE%…
oracle case-when