Search results for query: *

Can I launch an Oracle Forms app within a Windows Terminal Server session from my client ??

I have the same problem. Has anybody solve it...

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 PROBLEM .. was what I meant

You can do something else save the xls file to csv file and then you have problem iserting it via SQL Loader

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...

Find it.. <cfset res = StructDelete(session,&quot;CURRENT_USER_ID&quot;)>

How to kill a session variable

It should be dynimacly created over a database query results

thanx but I figured it out trunc(sysdate,'dd') Lazar

Hi folks I need to get todays date in PL/SQL but sysdate returns date & time so I think I must truncate it somehow. Can you show me the way to do this

ok but I need Line chart maybe some other approach(not using excel com object) any idea???