Problem starting a Job against Aix 4.3 from OEM 9.2
errror message :
VNI-4002 : Unknown gateway exception VxxdCryptoSessionException: SESSION_UNAVAILABLE
Any idea
Hi all
I am trying to make a standby database using Data Guard Manager, but unsuccessfully. Here is the environment. In the Enterprise Management Console I've discovered both nodes /AIX 4.3/ One of them /primary/ have a database installed /Oracle 9.2/ the other one has no database and no...
Well ok.. let me explain first what it is
something happens at certain point of time
there are several types each has a period
lets say types are a, b, c, d ...
type occur end
---------------------
a 11:00 12:00
a 12:10 12:15
b 12:20 12:30
a 12:40 12:41
c 12:45...
When I run a discover nodes with Enterprise Manager Console
it finds the node but it can not find the listener nor the database, but it finds other databases.
Both Enterprise Manager Console and Databse are 0racle 9.2.0.1.0 on Windows
Any ideas
yes I tried it but if same period type appears in certain hour lets say
a from 11:00 - 11:10
b from 11:15 - 11:30
a from 11:45 - 11:50
your query will return two rows
a 11:00 11:50
b 11:15 11:30
but the correct query in this case should return 3 trows
there will never be case of overlapping
but what Dima wrote works in the case I used to explain but
a type "a" could appear in a certain hour many times
Look at my exam and pretend there is one more row /one more period/:
a 14:36 14:50
no
in that case it only returns 3 rows
it should return 4 rows (a - twice)
look for every type i need its periods
but in that case "a" has two periods so I need two rows for it...
I have a table with this data
varchar2(1)| date | date
-----------|--------|--------
a 12:10 12:11
a 12:12 12:12
a 12:14 12:15
b 13:10 13:11
b 13:12 13:12
b 13:14 13:15
a 14:10 14:11
a...
No you seem not to uderstand me
I need besides O.obligation_id, O.total
more two colums one sum(P.payment_summe) for all columns that that have if_paid =1
and onother one for if_paid=2
so I must have 4 colums as a result
and (srishan I need null values if we have no rows in Payments)
Hi all I can not figure out a query. Any help would be appreciated.
So I have two tables Obligations and Payments
In Payments we have several or no rows pointing a single row in Obligations they look like this
Obligations Payments
----------- --------------
obligation_id...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.