In the bank I work all client workstations have .Net 2 installed it is outside my control to influence or get a newer version of the framework installed at the client end. On the server end I have more control and can write a .Net 3.5 WCF service if I choose. I've an existing fat client that I'd like to refactor and shift it's data acc...
how set sort_area_size in oracle 10g and what size should be as i have more than 2.2m rows in single table. and please tell me the suggested size of SORT_AREA_RETAINED_SIZE as my queries are too much slow they takes more than 1 hours to complete. (mostly) please suggest me the way by which i can optimize my queries and tune the database...
I have a oracle table called: create table InsertHere( generate_id varchar2(10), name varchar2(100) ); I have to insert data in this table from a web from. In the web form there are two elements: type and name . I have to generate 'generate_id' from the type user has selected. Task : Before insert into the Insert...
I'm trying to convert the permanent tables used in a stored procedure to global temp tables. I've looked at the stats on these permanent tables and some have tens of millions of rows of data and are on the order if gigabytes in size (up to 10 GB). So, CREATE TABLE my_table ( column1 NUMBER, column2 NUMBER, etc... ) TABLESPAC...
how do i connect excel to an oracle DB? ...
I have SQL UNION where second part of that statement is the row that represents TOTALS. How can I ORDER BY where TOTALS will ALWAYS will show up as the last row? ...
Suppose I have a BOOLEAN variable within a PL/SQL block in an Oracle Form: DECLARE is_viewable BOOLEAN; BEGIN is_viewable := ...; IF NOT is_viewable THEN raise_my_error(); // pseudo-code END IF; END; After stepping through this code several times with a debugger, I have determined that raise_my_error() never gets called. ...
I have the following batch script: sqlplus ms/ms@orcl < drop.sql sqlplus ms/ms@orcl < create.1.0.sql This works fine when I double click on the bat file in Windows Explorer and run it. But when I type the command name from the DOS prompt I get an error: C:\>create.bat C:\>sqlplus ms/ms@orcl 0<drop.sql The handle is invalid. C:\...
I have a table with a field called [SEQUENCE] and another called [REFERENCE] I can define the field in SQLLDR as SEQUENCE NULLIF ( SEQUENCE=" ") It complains that SEQUENCE is A SQLLDR reserved word. I have tried "SEQUENCE" [SEQUENCE] \"SEQUENCE\" None seem to work Would prefer not to call SQL, because that would preclude direct...
what are the queries to do the following in Oracle? get names of all views which are present ? (Similar to select * from view, but i want to get views not tables) See source of a particular view. ...
view v1 a1 a2 --------- 1 a 1 b 1 c 2 d 3 e 3 f view v2 b1 b2 -------- 1 a;b;c 2 d 3 e;f how to using sql change the v1 to v2 using a1 group to connect a2 ...
I have a table with a potential of up to 5.000.000 rows. One of the columns in this table is used alone in queries, but there is only 5 possible values of this column, and currently I got 10.000 rows and according to the explain plan it makes no sense to use my index on that column. Will it ever, or shouldn't I bother with an index Edi...
Hi, How do I see what pending changes have been made to an SPFILE, before I bounce the database. I know I can see changes in alert log, but it may have been a few months when the change had been made?. for example alter system set sga_max_size=1024M scope=spfile This doesnt become active until the next bounce. Thanks in advance. ...
i want to write procedure which accents name of 2 tables as arguments and then compare the number or rows of the 2. Also i want to each field of the 2 columns.The row which has a missmatch shold be moved to another error table. Can anyone give a PL/SQL procedure for doing this. I want to achive this in oracle 9 ...
The purpose is to send extra information to triggers like current user id from a web application. Since a connection pool is used, and same user id is used for all connections how do I pass the original web user id to trigger? This I need to implement without touching application code. It is a java based application. John ...
in SQL Server is possible to make a select without reference to a table. something like Select 1.2 +3, 'my dummy string' As Oracle does not allow a SELECT without a FROM, I use the dual table for this type of operations, ie something like Select 1,2+3, 'my dummy string' FROM DUAL There is a better way of doing this type of querys? ...
What are the effects of defining a column with VARCHAR2(1000) instead of VARCHAR2(10) in Oracle, when the values are not longer than 10 Byte? Does the column only take the space really necessary to store the values, or would that have any negative impacts on the size/performance of tablespaces/indexes? ...
I have quite a few lines of PL/SQL code in Oracle 10g, and we are going to move to 11g. I expect my code to work there too, but: Are there any pitfalls to expect, any problems you encountered? What new features are you using? ...
We have a large XML file with lots of data relationships and lots of data. Is there a way to generate a DB schema based on the relationships and then load the data into the schema? ...
I have some code that generates XML from some tables. The tables that I'm querying were generated from an XSD file the describes the XML I am supposed to be generating. The problem is that the names of the tables and fields follow a different naming convention than those in the schema - for example, an element named "personID" in the sch...