Please send me free OCP questions…

Dear Friends, Planning to appear for Oracle DB 10g: Administration I exam, Would be very grateful if you send across braindumps/questions/tips related to that. Pl mail to this id : ***@yahoo.com Many Thanks, *** When I appeared to my first multiple choice question exam by Prometrics back in 1997, there were no brain dumps, no […]

alter database add logfile size 1e7;

I am in the processing in adding logfiles to a 10gR2 database. SQL> alter database add logfile group 10 size 1e7; Database altered. $ ls -l -rw-r—– 1 oracle 10000896 Nov 1 15:00 o1_mf_10_3lmq05ld_.log The file size is 10,000,896 bytes. What about this : SQL> alter database drop logfile group 10; Database altered. SQL> alter […]

next patchset for Oracle 10gR2

10.2.0.4 should be available this year on Linux x86. Check Metalink Certification for different plateforms. Certify – Additional Info Oracle Database – Enterprise Edition Version 10gR2 On Linux (x86) Operating System: Linux (x86) Version SLES-10 Oracle Database – Enterprise Edition Version 10gR2 N/A Version N/A Status: Certified Product Version Note: None available for this product. […]

ContentDB installation

Yesterday I installed ContentDB. The installation is fairly straightforward. Download and install Oracle Identity Management OID 10.1.4.0.1 Install the Infrastructure, with the Identity Management and Repository, including Internet Directory, Single Sign-on, Delegated Administration Services and Directory provisioning This will create a 10.1.0.5 database. The default parameters are too low for contentDB. alter system set processes=250 […]

What is bigger than infinity?

Nan select BINARY_DOUBLE_INFINITY INF, BINARY_DOUBLE_NAN NAN, greatest(BINARY_DOUBLE_INFINITY, BINARY_DOUBLE_NAN) GRE from t; INF NAN GRE — — — Inf Nan Nan Nan means not a number. It could be square root of -1, log of -1, 0/0, acos(1000), Inf-Inf, etc… select SQRT(-1d), LN(-1d), 0/0d, acos(1000d), BINARY_DOUBLE_INFINITY-BINARY_DOUBLE_INFINITY from t; SQR LN- 00D ACO BIN — — — […]

On associativity, transitivity and reflexivity

Addition is supposed to be associative. a+(b+c)=(a+b)+c This may be wrong in Oracle when dealing with months and days with t as (select interval ‘1’ month a, date ‘2007-09-26’ b, interval ‘7’ day c from dual) select a+(b+c),(a+b)+c from t; A+(B+C) (A+B)+C ———– ———– 03-NOV-2007 02-NOV-2007 The equality is supposed to be transitive if (a=b […]

installing OID 10.1.4.2 Preview 1

Download oracle-oid-10.1.4.2.0-1.0.i386.rpm Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm Install the rpm # rpm -i oracle-*.i386.rpm In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh # ln -s /usr/bin/cut /bin/cut Run the configure script as root # /etc/init.d/oracle-oid configure That’s all folks! It created an Oracle XE 10gR2 database, […]

Oracle Database 11g: The Top Features for DBAs and Developers

I am always delighted to read the top features by Arup Nanda. He started his 11g series : Oracle Database 11g: The Top Features for DBAs and Developers There are many partitioning enhancements. The most exciting feature for me is the INTERVAL partitioning. A huge cause of downtime and waste of storage is the range […]

select*from”EMP”where’SCOTT’=”ENAME”…

What is wrong with this query? select*from”EMP”where’SCOTT’=”ENAME”and”DEPTNO”=20; EMPNO ENAME JOB MGR HIREDATE ———- ———- ——— ———- ——— 7788 SCOTT ANALYST 7566 13-JUL-87 It is a zero-space query 😎 You could write it as select * from “EMP” where ‘SCOTT’=”ENAME” and “DEPTNO”=20; personnaly, I would write it as select * from emp where ename=’SCOTT’ and deptno=20; […]

positive infinity

I have read a long long time ago the following note on positive infinity http://www.ixora.com.au/notes/infinity.htm Today I finally succeeded in inserting positive infinity in a number field create table t as select STATS_F_TEST(cust_gender, 1, ‘STATISTIC’,’F’) f from ( select ‘M’ cust_gender from dual union all select ‘M’ from dual union all select ‘F’ from dual […]

the password is not longer displayed in dba_users.password in 11g

By reading Pete Finnigan’s Oracle security weblog today, I discovered that the password is no longer displayed in DBA_USERS in 11g. select username,password from dba_users where username=’SCOTT’; USERNAME PASSWORD ——– —————————— SCOTT select name,password from sys.user$ where name=’SCOTT’; NAME PASSWORD —– —————————— SCOTT F894844C34402B67 on the one hand, it is good for the security. On […]

keep dense_rank with multiple column

create table t( deptno number, firstname varchar2(10), lastname varchar2(10), hiredate date); insert into t values ( 10,’Jo’,’Smith’,date ‘2001-01-01′); insert into t values ( 10,’Jack’,’River’,date ‘2002-02-02’); to get the latest hiredate per department select deptno, max(hiredate) hiredate from t group by deptno; DEPTNO HIREDATE ———- ——— 10 02-FEB-02 if you want to get the name of […]

get Nth column of a table

I answered this question twice, once on otn forums and once on developpez.net Here is the latest to get the third column of emp select column_name as name, extractvalue(column_value,’/ROW/’||column_name) as value from table(xmlsequence(cursor(select * from emp))), user_tab_columns where COLUMN_ID=3 and table_name=’EMP’ ; NAME VALUE —- ———- JOB CLERK JOB SALESMAN JOB SALESMAN JOB MANAGER JOB […]