I have a view. one of the view's column contains NVL function (like nvl(col1,col2) colA). and if i made query on this i will display some records Ex: select calA from view1; and if i use the same query as inline view and i use rownum in where clause it displays nothing Ex: Select * from (select calA from view1) where rownum <10; I a...
How can I find out what, if any, indexes are set up on the oracle data dictionary tables themselves (eg on the columns of all_tables or all_source)? ...
Somebody can advise an equivalent for Enterprise Management Console? I found this Oracle Enterprise Manager 10g Grid Control Management Agent. But i cant launch it. There is two jar file. I try to run it, but it doesn't work. dhcp-176:~ kukodajanos$ java -jar /Users/kukodajanos/Downloads/macosx_10_1_0_3_agent_download/macosx/agent/stag...
I've got a query which has a WITH statement for a subquery at the top, and I'm then running a couple of CONNECT BYs on the subquery. The subquery can contain tens of thousands of rows, and there's no limit to the depth of the CONNECT BY hierarchy. Currently, this query takes upwards of 30 seconds; is it possible to specify indexes to put...
Hello I got a little Probelem: Im tring, with a SP, to read datas from Table SYSADM.aaTest and put it into MYSCHEMA.aaTest now my Problem is this Table has the Type Long in it. desc aaTest Name Null Typ ------------------------------ -------- ---------------- ID_TEST NOT NULL NUMBER...
Given the following Java which is loaded into the database using loadjava: package grassie.example; public class Example { public static String test(){ return "Hello World!"; } } And given the following Oracle Stored Function: CREATE OR REPLACE FUNCTION TEST_FUNCTION RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'grassie.ex...
We have a table which has a DATE column d. I'd like to get all the rows where the d column is greater / lower than some value, regardless of the date. For example | d | ------------------- |2009/11/1 15:55:23| -------------------- |2009/11/2 15:55:23| -------------------- |2009/11/3 15:55:23| -------------------- |2009/...
Hi folks, I have a Date type column in Oracle DB and it contains date and time for sure. But when I'm trying to get data in java application it will return date with bunch of zeros instead of real time. In code it'll be like: SQLQuery sqlQuery = session.createSQLQuery("SELECT table.id, table.date FROM table"); List<Object[]> resultArra...
Here: http://download.oracle.com/docs/html/A95907_01/diff_uni.htm#1077398 I found that on Windows Oracle is thread based, while on Unix this is process based. Why it is like that? What's more, there are many Oracle processes http://www.adp-gmbh.ch/ora/concepts/processes/index.html regardless the system. Why log writer and db writer are...
I am using the Oracle system tables to get some metadata about the Packages in our database. Here is one of my queries: select AP.PROCEDURE_NAME from ALL_PROCEDURES ap where ap.object_name = :object_name and ap.owner=:owner and ap.procedure_name is not NULL and ap.procedure_name like :procedure_name I also want to find o...
I am trying to create a report that has a summary for each group. For example: ID NAME COUNT TOTAL TYPE ------------------------------------------------------------- 1 Test 1 10 A 2 Test 2 8 A ...
I have last_update_date column defined as DATE field I want to get time in milliseconds. Currently I have: TO_CHAR(last_update_date,'YYYY-DD-MM hh:mi:ss am') But I want to get milliseconds as well. I googled a bit and think DATE fields will not have milliseconds. only TIMESTAMP fields will. Is there any way to get milliseconds?...
Possible Duplicate: Beginners book for PL/SQL programming? I wanna buy an Oracle PL/SQL book. I am new to Oracle. Which book do you recommend for novices who are learning Oracle PL/SQL? Thanks. ...
I have two PC. In one pc(PC1) i have installed oracle express edition 10g (10.2.0.0 as far as i know). And in another(PC2) i have installed visual studio 2008 sp1. In PC2 the ASP.Net application is running. But i can not connect to the oracle database to PC1. PC1 and PC2 are connected by LAN(TCP/IP {Actually they are ...
I have a query that always returns one row, with many columns. I would like to turn this into 2 columns and many rows. Original results: Col1, Col2, Col3, Col4 ---------------------- val1, val2, val3, val4 What I want: ColName, Value -------------- Col1, val1 Col2, val2 Col3, val3 Col4, val4 Is this possible? EDIT ...
This is a follow up question to http://stackoverflow.com/questions/2344403/transpose-one-row-into-many-rows-oracle I want to be able to unpivot an arbitrary query result. To unpivot a table manually, I would do: select value_type, value from ( ( -- query to be unpivoted -- EG: select col1, col2, col3, col4, col5 from table ) ...
While running dbms command execute dbms_utility.analyze_schema('MCC','ESTIMATE',30); I got ORA-00900: invalid SQL statement error. Can anyone tell me what could be the reason? ...
I want to use DBMS_OUTPUT.PUT_LINE, but the number of rows exceeds just 1. There is nothing in the table which increments sequentially, so I can't use a loop. Is there some way to print out each row in the table? ...
Hi all, I need to integrate my application using OSB (Oracle Service Bus). My application has two major job as a gateway: retrieve&send message to other application using JMS receive&send message to .NET platform using webservice. Any suggestions how to jumpstart migrating my application? The documentation provided by oracle is s...
Just stumbled across the new ClientId (aka client_identifier) variable that is available in Oracle 10g onwards, and would love to incorporate that into an app to assist with audit trails. The app is using a generated Enterprise Library DAAB based layer (netTiers) that is wired to use the ODP.NET drivers with EntLibContrib, so CRUD funct...