Hi DBAs
I am an oracle DBA and want to learn SQL SERVER 2005.
but i don't know how to start which MICROSOFT BOOKS should i read???

Hi, I've a problem with default value of integer data type: my
software work fine with oracle version 8, but fail with 11g version.
The problem is on sql insert command because are often omitted some
columns for use the default value. If the column omitted has a integer

I am working on 11.1.0.6.0, Oracle SQL Developer 1.0.0.15.
Yesterday I tried creating a new view through the Developer by (right
click on Views, Create View). This was not possible because the SQL
Parse returned "Unexpected tokens" though the query worked fine when

I'm a beginner Oracle DBA who is facing a performance issues on a 9i
instance running on Solaris. The db
instance hosts a number of web applications including in-house apps
and oracle apps such as Discoverer.

I know that jdbc can call a pl/sql package or procedure,but if i
want to call a pl/sql anonymous block, how can i do it? no procedure
name or package name will be offered.
  Can u give me a sample code? thanks very much

(DB10.2.0.3.0, AIX5L)
I am reading by a SQL select statement from a parallel table.
I get "ORA-12801 ORA-32696 HTI NO FREE SLOT" and Metalink note says
288808.1

Please help me to write query like this
WITH table_not_empty AS
(
  if (SELECT * FROM Table1) is not empty return it_self

Hopefully, I frame this problem/question correctly.
I have some code written/updated in visual studio 2003. This code when
setup on other machines where I have installed the Oracle 9i client,
and the Oracle 9.? odbc drivers will connect to my oracle database

Solve your problem regarding Database Administration at http://www.admin.net.in

I didn't find anything on metalink but maybe was distracted?
Curious as to when oracle may or will start shipping a patchset for
11g database especially on 64 bit linux.
Thanks in advance.

Hi Dear All,
Hope you are doing great. This mail is about Oracle BI Analytics
(Siebel Analytics training) we provide. We have all setup and experts
faculties to provide these kind of training.

currently I am testing to parse the oracle alert log for all ora-<any
number> errors. I just want to check if my monitoring rules for the
alert log are working as expected.
For this need I have an empty oracle database. The challenge is, I am

We are trying to see what the optimal size of our redo logs should be
and how many we should have.
We are running 10g, and we know that there is the MTTR_ parameter.
But for now, we want to the the log_checkpoint......