Hi all,
novice is back with stupid questions
:)
I have started working with a tool called Kalido. I
have touched it for only past few days. Seems interesting. www.kalido.com
My question is
I heard someone claiming that what ever is possible
with kalido is easily possible with OLAP
Hi all,
I noticed something strange. Logically it
makes sense but nevertheless strange.
I don't know how to pur it in words.
So seniors please help
===
SQL conn
hlledw/hlledw@orcl9iConnected.SQL
grant select on edw_week_lvl to scott;
But the interesting point is that scott never granted the privileges on the
object to test1
Coz
I am a NoviceDBA
Oracle Certifiable DBBS
An obstacle is something you see when you take your eyes off the goal --
Anonymous
- Original Message -
To: Multiple recipients of list ORACLE-L
Hi,
I have downloaded it to my office PC and it works fine. So I do not
think the problem is with the installable
coz I am a
NoviceDBA
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 02, 2002 6:20 PM
unfortunately yes
Thanks to jared's example i have a clearer idea now :)
coz I am a
NoviceDBA
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 28, 2001 3:00 PM
Which myth did you have in mind ?
I
select hiredate,add_months(hiredate,-1) from emp;
coz I am a
NoviceDBA
Oracle Certifiable DBBS
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 9:30 PM
I am trying to find coding examples of date functions. I need
Hi everyone,
One of my developers wanted to
know if it is possible to write a trigger only if a particular column is
changed, essentially making it a column level trigger.I gathered from the
article below that it is possible in SQL server. Just wanted to know if this is possible in
oracle.
Hi,
I did not receive a mail for two days,
I started smelling rat and sent a test mail to the list. I was told I am not a
member. Is it some revamping happening or I was thrown out because did people
start receiving viruses from my id ???
list administrator please help
jared
bruce
hi everyone,
wanted to know about key mapping in
developer 2000. I know that hot key mapping can be changed by modifying .res
file.
but it has its own limitations (I was told
this)
1)Combinations are restricted.
2) if any other product made in D2k is installed
then its shortcuts will
hi everyone,
In case you haven't noticed 9i for AIX
is available for download on technet.
When will 9i for NT come :(
cozI am anoviceOracle Certifiable
DBBS
mail me at [EMAIL PROTECTED]
I will try and help you
cozI am anoviceOracle Certifiable DBBS
- Original Message -
From:
Robertson Lee -
lerobe
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 18, 2001 5:00
PM
Subject: Certification
Oh dear,
://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from
Hi,
I wanted to know if there are any Oracle
User Groups in India. I visited http://www.eoug.com/usergroup-list.htmwhich
lists all the user groups, the two links provided for India don't seem to be the
proper ones. One is UKOUG and the other link does not work.
I am in Bangalore, India
Hi,
was reading CorrelatedSubqueries.pdf
from oriolecorp.
In fact it's good programming
practice to use aliases in every situation where more than one table is referred
to in a statement, since it saves time when parsing.
Can some one please explain how it
helps?
cozI am anoviceOracle
: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services
hi all,
this is an excerpt from Steve Adams
site
http://www.ixora.com.au/newsletter/2000_12.htm
First you need to determine the largest disk sort that is performed
by the batch process. This can be done by setting event 10032 at level 1 in the
session and then examining the process trace
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list
hi all,
this is an excerpt from Steve Adams
site
http://www.ixora.com.au/newsletter/2000_12.htm
First you need to determine the largest disk sort that is performed
by the batch process. This can be done by setting event 10032 at level 1 in the
session and then examining the process trace
Hello
one of my developers has a weird(!)
requirement
In one of the applications the block level
propertyquery all records has been set to yes and the users want it that
way, butthey also want to have a dialogue popping up which would allow
them to abort the query ifthey wish to.
The
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
SELECT
STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2)
VALUEFROM TEST;
STATION EMISSION_FREQ
RECEPTION_FREQ
VALUE--
-
--
-STAT1
192.5
193.5
385STAT2
192.5
you could achieve this using decode
cozI am anoviceOracle Certifiable DBBS
- Original Message -
From:
ALEMU Abiy
To: Multiple recipients of list ORACLE-L
Sent: Monday, July 02, 2001 1:00 PM
Subject: Simple SQL Query Question
I've a table with
the following
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--
-
--STAT1
192.5
193.5STAT2
192.5STAT2194
STAT1
193.5
194.5
STAT2195
I
would like to have a value for STAT1 which is equal to 2*2=4 and for
STAT2 equal to 3*1=3
-Message d'origine-De: novicedba
[mailto:[EMAIL PROTECTED]]Envoyé: lundi 2 juillet
:
No Sender Info found
in the address Book
On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode explained
If this is true then I may
[EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 4:03 PM
On Jun 26, 2001 at 01:05:59AM, novicedba wrote:
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode explained
If this is true then I may be a victim of a disease
to
participate, giving their own interpretations. Marlene and I designed that
presentation as an all day workshop, and it was meant first and foremost
to
be educational AND entertaining.
The paper will be on the NYOUG website in a few days.
Rachel
From: novicedba [EMAIL PROTECTED]
Reply-To: [EMAIL
/entry/Infinite-Monkey-Theorem
.html
Cheers
Greg
-Original Message-
Sent: Thursday, 28 June 2001 14:21
To: Multiple recipients of list ORACLE-L
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
LISTS
Hi everyone,
I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton
I was shocked to read Hot backup mode
explained
If this is true then I may be a victim of a disease called
'Common Oracle RDBMS
Misconceptions' . Somebody help me!! (Jim carrey-MASK style)
Please help me. If
myself. Is it possible that rather
than
visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited
www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't
be
checking).
If it does exist I'm sure that switching logs means something entirely
different
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
Hi,
install.pdf reads
Operating System:
Oracle9i is certified on SuSe 7.1, Kernel 2.4.4 and the
operating system library GNU Lib C
2.2.
I have Redhat 7.0 with kernel
2.2.16--22
I think I need to upgrade my kernel to 2.4.4 but
don't know how to, redhat site doesn't give great info nor did
LIST
Hi,
We run our databases on NT and we face this problem once in a while. For the
benefit of our consultants working on the client side I had prepared a
document.
This has worked perfectly for me as well as for our consultants on the
client side.
I am aware that the present problem is removing one
Hi,
yes I have tried working with
isqlplus.
It gets installed fine and works fine too. There is
a proper installation doc following which it could be installed.
It is buggy as you can expect it to
be.
everyone who used it at our place liked it (though
I had the headache of killing the
Hi,
Database
8.1.5
OS - NT
On my test database I deleted certain tablespaces
and then shutdown the databases, deleted the datafiles (still in recycle bin)
and restarted the database . The database started fine no errors.
When I check the alert log I found the
string
ksrchdelete7
Hi,
I have a Solaris test system on Intel. This is
first time I installed Solaris. I am trying to findout in i can install the
oracle 9i on this system.
Can someone enlighten me.
I don't mind installing any version as it is for
test purposes, but 9i will be a great thing to do
novice
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
hi,
This may sound funny. I want to know
how to corrupt a block. I want to test the different methods of identifying
block corruption, but I don't have sample data blocks.
Please help me
novice
unfortunately i am on NT
I can not use BBED because i don't know the password
is there any other way
- Original Message -
To: 'novicedba' [EMAIL PROTECTED]
Sent: Thursday, May 31, 2001 11:40 PM
I do not recommend this, but since you are bent on doing this:
(Hope you are on Unix
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: novicedba
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
43 matches
Mail list logo