Hi all, I have a .net application which runs in the region of 20 to 30 SQL queries and processes the results 1 at a time. I have been trying to increase performance by doing some work in parallel. 2 of the queries take 75% of the time, purely because of the amount of data they return. My initial experiments have been to try to split th...
I have the below sql script. When there is no record found by the select query there are no records inserted by the insert statement. If no records found by select query i want to have a record inserted with the new sequence numbers and other fields with null values. how can i do it. insert into testing.test_ref_details(SEQNUM, TEST_T...
How can we define output parameter size in stored procedure? ...
Here is the code (with server/passwords etc removed) public int SetUploadedInESIDatabase(string ID) { using (var oOracleConn = new OracleConnection()) { oOracleConn.ConnectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip>)(PORT=152...
does anyone know whats wrong with this nested select stament? It complains about missing )'s but i can't unerstand why it doesn't work (i've left off the other bits of the statment) Select (CASE WHEN REQUESTS.grade_id = 1 THEN (CASE WHEN ((date_completed-date_submitted)*24*60)<=30 THEN 'Yes' ELSE 'No' END) ELSE ...
I need to count number of email addresses in a db that have 3 or less characters before the @ sign, for example [email protected]. The parsename function isn't present in Oracle and I'm not sure how to write a regexp for this. Any help would be greatly appreciated! ...
I'm working on an application to do some batch processing, and want to store the input and output data as files in BLOB fields in an Oracle database. The Oracle version is 10g r2. Using the PreparedStatement.setBinaryStream() method as below will insert a small text file into the database, but I'm not having any luck with a larger image...
I am using Oracle ADF for one of my project and i am using Query component of ADF. For given tables the query component creates view objects and maps the relations. ADF uses its own custom model class for this component and it should understand the DB tables. But for my project i have no access to database. All i can do pass a string or ...
I have a GridView with an Update button. I want to update a field in the database but I think the '@' in the code below is causing the problem in my ASP .NET page. What can be done within the grid or in the update (UpdateCommand) statement? Note, I get an Ora 00936 error. <asp:SqlDataSource ID="dsBooks" runat="server" Provid...
Looking for the following forms functionality with INFORMIX 4GL?, ISQL with ESQL/C?, PROGRESS-4GL?, ORACLE? etc? I have a CRUD form which displays a customer[master] with all of their asociated transactions in record arrays[detail] on the same screen: [id ] [fullname ] [address1 ] [address2 ...
Hi - I have a query that works on MySQL but doesn't work on Oracle, and I'm trying to convert. This is my table: unique_row_id http_session_id page_name page_hit_timestamp ---------------------------------------------------------------- 0 123456789 index.html 2010-01-20 15:00:00 1 123456789 i...
I need to check the current user's java grants, something similar to what has been set by: dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect'); Can this be done without system privs from the current account? If I need to do it with system privs, where should I look? 10gR2, if that makes a difference. ...
I create tables with using TOAD Create Table GUI. I want to create autoincrement key. I don't want to write sql of it. Is there any way to do this on GUI screen? ...
I want to create an sql script that can recreate a DB that I already have. I want to recreate the DB without data inside. So is there anyway with sqlplus of exporting a DB of a user? ...
let say i do select score from table1. this will return result score ---- 0 20 40 how to use case, to change the output to if 0->strongly not agree 20->agree 40->very agreed ...
Referring to a previous question, i was wondering if its always possible to replace DECODE by CASE and which one is better for performance? ...
I have a fact table containing 8 Million rows with 1 Million rows increase per month. The table already contains indexes on it. The table is used by IBM Cognos environment to generate reports. Currently I am looking for way to optimize the table SELECT statements. As first try, I partitioned the table (each partition has equal distribu...
I need some help with the eclipse. I have a project which need to connect to oracle databases so i have the ojdbc jar file and a simple project. try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@"+this.host+":"+this.port+":"+this.db,this.user,this.pa...
SQL Developer : 2.1.1.64 When I generate DB doc on my tables my file system fills up with files like _Flashback.html. How can I prevent this? Who on earth might be interested in this data as part of a database documentation? IMHO this should not be included in 'DB Doc' This data is displayed : Operation VERSIONS_XID VERSION...
Hi, How does oracle treats dml statements executed by multiple users on the same data object?. Suppose, If there is a empty table named EMP(empname varchar2(30)) and user 'A' makes an entry into it using, insert into emp values('A'); but hasn't committed it yet. If another user 'B' logged into the same database commits, would he/sh...