Question : We have a table as below CREATE TABLE “ABC”( “ID” NUMBER (18, 0) NOT NULL, “ID2” VARCHAR2(15 char) […]
Category: Oracle
How to use Oracle Installation Prerequisites on Redhat Linux 6.5?
Question : Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this […]
Unable to start Oracle (11g1) due to bad memory configuration (ORA-00837)
Question : I decided to reduce the memory allocation of a local developer instance, and was told that the following […]
Simple CASE Usage
Question : Given: TABLE test x y a 1 b 2 TABLE test3 x y a 1 b 3 I […]
A trigger that show the user that has made an insertion
Question : I have the following code create table o_c( op_id NUMBER(10,0) PRIMARY KEY NOT NULL, n_c VARCHAR2(50) NOT NULL, […]
SQLPlus: Cmd vs PowerShell
Question : From cmd.exe, when I run: C:oracleclientBINsqlplus.exe username@server then type my password, I get in. However, if I run […]
Insert in child table prevents lock on parent table
Question : I’m a software developer, and although I’ve written a query or two, I’m not DBA, so please bear […]
How to speed up a query with a lot of subqueries
Question : I have a query which uses a series of functions to return the status of each document for […]
Is there something to rescue from an Oracle Data Modeler design just with the ‘logical’ folder?
Question : First of all, I even don’t know how naive is the question, we start studying this not long […]
Oracle 11g: Part Copy of Production data to Development Environment
Question : I have a Production database with the current size involving two principale schemas: SQL> SELECT SUM(bytes)/1024/1024/1025 “Size in […]