Hi Experts,
I need to add alias column for the below Oracle statement. i.e.
For the first query:
Record in First but not in Second
For the second query:
Record in Second but not in F...
Hello experts,
Why do I get the following error when calling a function that returns a type defined in a package?
ERROR ORA-00902: invalid datatype
In the package definition below,...
I am looking for a script to produce all users in the Oracle database and all their roles and system privileges. Anyone who has it handy please send it over to me.
Thanks
Hello,
My table has these fields:
select to_char(xdate,'dd/mm/yyyy'), xhours, xmins, xsecs, xAMPM
from myTable
- Fields xhours, xmins, xsecs are char format
- Values of xhours are f...
I am running this simple piece of code but keep recieving the following error;
ORA-00905: missing keyword
I am sure this is simple :)
Thanks
The external table created successfully but
I am getting error when executing
select count(*) from xtern_sap_tb
RA-29913 : Error in executing ODCIEXTTABLEOPEN call out
ORA-29400 : data...
Hi, I have the following query, that for now displays the same time twice with milliseconds. I want the second column to be the first columns time, plus 25 milliseconds. desired output below.....
<script language="JavaScript1.2">
/***********************************************
* Flexi Slideshow- © Dynamic Drive (www.dynamicdrive.com)
* This notice must stay intact for use
* Visi...
I like the following to return aN instead of a. Basically, I like the rtrim only remove None only. I am open to another function or another way. Thanks.
1* select rtrim('aNNone', 'None...
Uncommenting out the below "substr"
line causes a "ORA-01796: this operator
cannot be used with lists" ERROR.
How can I fix ?
----------------------------------
select fmr.FMCODE
FRO...
Can someone help explain this? (This i shomework so I am just looking for an explanation) I can't figure out what is wrong with the fk and why SQL+ keeps throwing an error.
Error is ORA-009...
I was forwarded some SQL that pulls from our Warehouse -I suspect it was generated by the PeopleSoft Query Builder. Note: I use SQL Server 2005. Our Warehouse is Oracle 9. ...anyhow, rather th...
Good Afternoon. I have a dilhemma that I'm hoping someone can help me with. I have a Coldfusion page and it connects to an Oracle DSN. In that Oracle table, I have some fileds containing dates...
Need a script to Refresh Oracle Schema on windows
I want to modify the code below that it gets only the personel_id's where yetenek_id's belong to personel_id's have the values 1 and 2 and 3 all (not 1 or 2 or 3). For example,
The table i...
Please suppose you have a table with two columns of type VARCHAR2 and NUMBER respectively: the column CODE, and the column WEIGHT.
How can you split this table in a certain number of sub-ta...
Hello,
it is possible to generate a Grid Control report in order to know which process consumes the most CPU between 00:00 am and 04:00 am ?
Thanks
Regards
Bibi
We are running a product that creates DDL on the fly based on design-time decisions. I need a means of capturing the DDL and preventing it from executing. I dont want to turn off the permissio...
this is a partitioned table with global indexes.
sql>truncate table joe.catalog;
table truncate
sql>select count(*) from joe.catalog;
0 rows
sql>analyze table joe.catalog compute sta...
What command deletes all tables, views, constraints, etc ?
Basically I want to keep the "HR" schema, but drop everything that is in it ?
How to tune this query.if i remove "L.MASTERID = '12345' OR" from above query then its fetches fast otherwise its taking 4 minutes.
i think because of OR condition its taking lot of tim...
I have this function
CREATE OR REPLACE FUNCTION new_func( SelectStatement IN STRING )
RETURN string
AS
result string(32767);
aux string(32767);
TYPE EmpCurTyp IS REF CURSOR;...
I have a Hyperlink linked to an Excel spread sheet on the Intranet. I can access the spread sheet but when I try to save it displays READ Only. The attributes are not set for Read Only on the ...
I want a region to be conditionally displayed, in an ApEx application. But something didn't work.
The way I tried to make it is shown in the picture I attached. I want a region will be dis...
I have a loop to cycle through some dates by converting the dates to number. But the day hits an invalid day ie:32 while iterating through the loop. How can I stop this from happening?
