I am building an information service that manages Suppliers. The suppliers are used by our billing system, tender system and sales system. Though 60% of the attributes of supplier are unique to each system, there are still 40% attributes of Supplier that are shared across the systems. My objective is to build a flexible system, so tha...
So we have some developers who went a little view happy. So now we have views that reference views that reference views, ad nauseum. So what I want, in order to assist me in Tuning, is to expand these views. I want a function that takes a string and returns a string. The input string is the query, the output string is the same query w...
This table is rather backwards from a normal schema, and I'm not sure how to get the data I need from it. Here is some sample data, Value (column) Info (column) --------------------------------------------- Supplier_1 'Some supplier' Supplier_1_email '[email protected]' Supplier_1_rating '5' Supplier_1_st...
In one local financial institution I was rebuked by their programmers for expressing them my opinion that (their programmers' obsession with) (b)locking issues in their MS SQL Server 2005 OLAP (SSAS) database(s) did not make much sense to me. (The OLTP databases are SQL Server, Oracle and non-RDBMS ERP). What are locking issues in OL...
Hi, How to query rows in a table where the created_date column value in the table falls on a weekend date ONLY, i.e. Saturday/Sunday using Oracle SQL.. Thanks ...
What is the benefit of using Oracle Database forms VS using C#(VB) or like this for programming? from academic view ...
I have one package that has different procedures, and one main procedure through which I am calling other procedures. Through the front end, I am passing the procedure name into main(). Is there any way by which the procedure can be called just writing the parameter name containing('Procedure Name that is need to be called')? CREATE O...
We have implemented client server socket based application to process multiple shopping cart requests. Daily we receive thousands of shopping cart requests. For this we implemented multi threaded architecture to process requests concurrently. We are using Oracle Connection Pool for data base operations and we set optimal value for conn...
Hello! Sometimes I want to generate INSERT statements from the contents of a database table. With SQLite, I can do: SELECT 'INSERT INTO foo (col1, col2) VALUES (' || quote(col1) || ',' || quote(col2) || ');' FROM bar; With Oracle, I have to do : SELECT 'INSERT INTO foo (col1, col2) VALUES (''' || replace(col1, '''', '''''') || ''...
Can we update primary key values of a table? ...
Hi Please can anyone suggest.We are trying to estimate how manay managed server instances are required in a weblogic domain and how many servers would we need as well. Our estimate is that on there will be 10,000 concurrent users(doesn't include logged in users) for the application and about 400 transactions per second and each http se...
Hi, I have a problem using JPA with Oracle and grouping by hour. Here's the scenario: I have an entiry named EventData. This entity has a java.util.Date field named startOfPeriod. This field maps in a table field of datatype DATE. The query I'm using is something like: select min(ed.startOfPeriod) as eventDate, (...) from Event e inner ...
Hi guys i'm having trouble running the below code on an Oracle DB not too sure why - getting ORA-905 error - missing keyword This works fine on MSSQL and MYSQL. Any indication as to how to fix will be much appreciated. Cheers. SELECT product.productId, product.version FROM product INNER JOIN (SELECT productId, MA...
Hi all, Is it possible to trace back the exact create table statement that was used to create a table ? Thanks, Trinity. ...
I have a legacy DB dump file which starts off something like this: ^C^@&D EXPORT:V07.03.04 DHISTO RTABLES 8192 0 ^@ Mon Jan 11 09:02:31 2010 TABLE "ABCD" CREATE TABLE "ABCD" ("TIME" DATE, "ELEMENT" CHAR(16), .... From the "EXPORT:V07.03.04", and from the data I do have, I am assuming this is an Oracle DB dump (v7). Which tools do I...
What is the more easy way to INSERT a row if it doesn't exist, in PL/SQL (oracle)? I want something like: IF NOT EXISTS (SELECT * FROM table WHERE name = 'jonny') THEN INSERT INTO table VALUES ("jonny", null); END IF; But it's not working. Note: this table has 2 fields, say, name and age. But only name is PK. ...
I have an Oracle database with all the "data", and a Solr index where all this data is indexed. Ideally, I want to be able to run queries like this: select * from data_table where id in ([solr query results for 'search string']); However, one key issue arises: Oracle WILL NOT allow more than 1000 items in the array of items in the "in...
A colleague and I are new to Oracle and are analyzing indexes on a table. This is a legacy and indexes currently exist on the table Mytable * ID (primary key) * partId (Id column in part) * partNum (partNum column in part...partNum can have more than one partId) * description (description of partNum...can be different for each pa...
Hello, I am having some strange behavior with the using the Java with the "ojdbc.jar" as the client. I have a simple program that tries to just inserts 500 rows using one query. (an INSERT ALL FROM dual). This program takes 25 seconds to complete in Java. This is the time the statement.execute() method takes to complete. Wen I run ...
Is there any way to merge two strings returned in a query like this: I have one string '<6 spaces>XYZ' and other string '<3 spaces>ABC<3 spaces>'. Basically each string is divided in 3 parts and two of any parts will be blank. I want to merge these two strings to produce the output: '<3 spaces> ABCXYZ'. Another example can be 'ABC<6 sp...