Hello!
I have a table which contains about 8 varchar2(4000) and a CLOB...
Now I want to add a int column which will have primary key like column... It should have ID of rows so I'll have c...
I have a webpage that allows a user to search by date. They can put in a date range.
Ex: Return All Records: Start Date: 3/3/2000 End Date: 8/14/2007
I need to return all th...
Can anyone please explain me how does Oracle BITAND and BITOR works by suitale example. like BITAND of 01101010 and 10011.
Please explain in detail.
Hi,
I need to extract some records from a large View on a large table, which is joined with other views, using a date range.
When i execute the following:
SELECT *
FROM view_name
wher...
Morning All:
We're running into a random error that Oracle support (through some researching, not directly) indicated that we needed to increase the cursor_sharing, cached_cursor sizes and ...
Upgraded Forms 6i to Forms 10g (10.1.2.0.2)
I recently upgraded my application server to the 10g environment and recompiled all my forms, reports, libraries, menus, etc...The only problem ...
Hi, I'm checking the listener status in Oracle 10g and it' saying no listener is running
$ srvctl status nodeapps -n addtrw
VIP is not running on node: addtrw
GSD is not running on node: ...
I'm having some trouble with my the sql below and how I'm using the GROUP BY clause. I would like to only group by coop_id then contact_user_id but I'm getting the ORA-00979: not a GROUP BY e...
Hi,
My server is getting the following core dump.
ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object] [0x14] [] []
System info: Oracle Da...
oracle 10g SLOW SLOW SLOW - URGENT ****
Everything on my oracle 10g
Windows 2003 server
3gb RAM
Opening the EM console for a database takes a long time and tyring to view a table runs a...
Oracle 10x
I have a table that I want to insert a row into; but, only if that row does not already exist in the table. I tried the following code in my PL/SQL block. I didnt get an error...
pl/sql oracle Date Format and Calculation
Question:
I'm new in pl/sql and the date functions in pl/sql are very confusing to me. Can you please give me some quidelines on how to do that ...
There are many answered questions about how to calculate the size of an oracle database once it has been created and populated but I have been asked to estimate the size of a schema in order t...
Hello,
I have installed Oracle 10g on RHEL 4 succesfully. After installing the database starts normally.
But the problem I am having is I get the following error when I try to execute ...
I have two tables A and B. B has a foreign key constraint using a column of A. I want to write a query to delete all child records of B when a parent row from A is deleted.
I can not change...
I am investigating the possible use of OBIEE in delivering a BI reporting solution. I have a query hitting a star schema, which I would like to execute to give me a report.
I want to pass ...
I want to create a random number between 1 to n and return any number within the range using sql. Our database is oracle 10g.
How to spool the output of an sql query into a CSV file?
select * from table1 group by column1;
And the select statement should not print anything to the System Out. How to do that?
Have just moved from an 8i db with rule based optimzer to a Oracle 10g database, having some issues with performance and conflicting results, some people say let oracle manage the memory by ju...
I have got two applications in MS Access2003, which use Oracle ODBC Driver 8.1.7 (files: bin/ sqlora32.dll, sqloras32.dll sqresus32.dll from 11th May 2000 for Win2k) for the connection to Orac...
Im having problems writing an asp.net c# update command for an oracle database..... Im having the problem with my parameters and so Im looking for some help from any oracle experts
Im using...
SQL> select * from test1;
STATE ID NAME PARAM count1
---------- ---------- -------------------- ---------- ----------
AK 1234 testname...
Dear Gurus,
My requirement is to send a mail with attachment in the form of PDF or HTML format. The report (which will generate PDF or HTML format) has been developed using Oracle Reports 10...
Experts,
I get the following error while trying to work on one of my databases,
"Error: PLS-00920: parameter plsql_native_library_dir is not set", i checked on google and i see the following...
I have received an Oracle dmp (38Gb dmp -> 55Gb DB) and need to import it into a 10g database. I've tied using the Oracle 10g imp, only to find that it typically hangs part way through the pro...
