I think the best way to ask this question is: How do I specify a default namespace for the root element in the output? Doing this: <xsl:template match="/"> <r xmlns:s"http://www.mycompany.com/s/schema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.mycompany.com/default/schema" > .... .... Gives me an ...
I'm trying to make an extremely minor change to a view on an oracle database, but what's confusing me is that the base table/view for the view I want to change doesn't seem to exist. First I did this: select text from all_views where view_name='(view name)'; and got the view text, which of course was something like this: SELEC...
I have a view where if I select like this: select * from view where date = '17-sep-10' it returns in seconds. If I use a dynamic date: select * from view where date = to_date((select current_business_date from v_business_day), 'mm/dd/yyyy') it returns in 20 mins. Why would har...
I want to know the difference between these two statements. Is one 'better' than the other ? DECLARE myvar varchar2(50); BEGIN SELECT fieldone into myvar FROM tbl_one WHERE id = 1; END; AND DECLARE CURSOR L1 IS SELECT fieldone FROM tbl_one WHERE id = 1; BEGIN OPEN L1; FETCH L1 INTO myvar; CLOSE L1; END; ...
Suppose you have a table: CREATE TABLE Customer ( batch_id NUMBER, customer_name VARCHAR2(20), customer_address VARCHAR2(100) ) And suppose you have a control file to populate this table: LOAD DATA INFILE 'customers.dat' REPLACE INTO TABLE Customer ( batch_id ??????, customer_name POSITION(001:020), ...
I have a table like this: UserID Customer ID status 1 1 1 1 2 1 1 3 1 1 4 2 1 5 1 1 6 3 1 7 2 2 8 1 2 9 2 ........ ...
The oracle .net client is a big pain to install and manage. So what experience have people got with alternatives? (Telling the customer that you only support Sql Server is not always an option) ...
Hi, We have an Oracle 8i database on which I have only read access. We use ODBC and MS Access to read data from that database since we don't have Oracle Client software. This works fine. I am using ADO.NET with ASP.NET. Now I want to display a list of all the tables that I see in MS Access via ODBC. I have tried this with ODBC connectio...
Hi, I am having trouble testing this simple stored procedure in Oracle Sql Developer. The stored procedure does a simple select and returns a cursor. create or replace PROCEDURE GET_PROJECT_DRF_HISTORY ( projectId IN NUMBER, resultset_out OUT sys_refcursor ) AS BEGIN OPEN resultset_out for SELECT * from GLIDE_HISTORY where G...
I want a specific order for the Completion_Status column as in: Completed, Passed, Incomplete & Failed How do I do I order this? I want to define the order above. I tried CASE but it give me an error as in Expecting NUM not CHAR. select DISTINCT u.first_name || ' ' || u.last_name "Employee_Name", rco.title "Course_Name", deco...
I want to move my SQL Server 2005 database to Oracle. How can I do that? What are the step I want to follow? Are there any tools for this? ...
What is oracledbconsoleorcl? It seems like it is the source of a lot of CPU thrashing on my system and when I disable it, the thrashing goes away. I know that it is probably required, but I'm curious. That other site is the only place I've seen an answer, and they want me to pay for that. ...
Maybe someone can explain this to me, but when querying a data table from Oracle, where multiple records exist for a key (say a customer ID), the record that appears first for that customer can vary if there is no implicit "order by" statement enforcing the order by say an alternate field such as a transaction type. So running the same ...
The following code snippet works fine with SQL Server 2008 (SP1) but with Oracle 11g the call to session.BeginTransaction() throws an exception with the message ‘Connection is already part of a local or a distributed transaction’ (stack trace shown below). Using the '"NHibernate.Driver.OracleDataClientDriver". Has anyone else run into ...
How can I get the equivalent of an "on commit" trigger after inserting some rows into a table? After inserting several rows into a table, I would like to send a message to an external process that there are rows ready to process. Using a statement-level trigger causes one message per insert, and I would like to send just one message sa...
In WebSphere 6.1 I have created a datasource to an Oracle 11g instance using the thin JDBC client. In Oracle I have two users, one existing and another newly created. My websphere datasource is OK if I use the component-managed authentication alias of the existing user, but fails with "invalid user/password" message if I use the alias ...
Using the JDBC driver oracle.jdbc.xa.client.OracleXADataSource, what is the correct format of the JDBC URL? The thin format of jdbc:oracle:thin:@host:port:sid does not work. WebSphere is reporting that the given url (which is otherwise correct) is invalid. The test connection operation failed for data source Oracle MyDB (XA) on se...
Hi, I am Kanagaraj. In our stored procedure, we are logging messages at 500 places and logs are stored in a table where we are having some performance issues. We need to split these messages into Debug, Info and Error messages. Based on the level, only limited messages should be logged. If necessary, we will be enabling the next level a...
What is Couch DB? How is that different from conventional oracle DB? What is the process of search & retrieval of data from Couch DB? ...
Hi there, i want a working example for using oracle built in 'utl_match.jaro_winkler_similarity' method which compare two strings based on how much they are matched, i want the example such that it restrict the results of criteria to only which value of (X) match with given text, i tried some kind of statements but it seem to be not wor...