I would like to show in one field, all of the values of a group.
For example:
Table Name: Pets
Fields: Type, Name
Type Name
Dog Boomer
Dog ...
Hi,
I want to configure oracle to disconnect inactive sessions after a certain period of time. What parameters do i have to change?
We a preparing to upgrade from Oracle 10g R1 (10.1.0.5) to R2 (10.2.0.1 then 10.2.0.2) and when performing a simulated upgrade I can't find the Oracle Enterprise Manager Database Control 10.2....
Hi All,
I have the SQL Server Plugin Configured for the OEM Agent. I have added a SQL Server database and was working fine. There are 2 SQL Server databases which needs to be configured u...
Hi,
I am getting a strage error while creating a materialized view on Oracle database.
We were able to create or refresh view earlier to this and there were no problems at all.
But now w...
I want to insert HTML code in excess of 4000 characters into an Oracle CLOB field, but am experiencing errors when updating the code
Think I have two problems, the first is I think html val...
I upgrade my database to 10g. My statspack stop working! I did delete the perstat user all its objects to I can start clean statspack config. so I rin @?\RDBMS\ADMIN\SPCREATE.SQL and prom...
Using Pro *C/C++ in unix environment. How do you display and print and interpret this structure?
Am I querying this correctly to find any duplicate dates in the table?
select distinct count(date)from table1l;
I get 62656
select count(*)from table1;
I get 100687
Does that mean that ...
Dear Sir,
I am having a confusion between init.ora file and pfile.I know whenever we give the command Startup and Shutdown to start and down the database the database read the init.ora file a...
How I can checking a field name is exist or not in a database by SQL Plus or JBuilder ?
On another meaning I want to find field name available in database and determine which table contain ...
I'm trying to export large flat files out of Oracle into a .dat format. Does anyone have a nice generic script for doing so?
Hello,
How can I perform a Data Pump export that ONLY has the triggers for a schema (NO DATA)?
This is very time critical thus the points.
Thanks,
Michael4606
folks
how ,i have a column that shows hours and minutes like so
TO_CHAR(24 * FLOOR(actfinish - actstart) + TO_NUMBER(TO_CHAR(TRUNC(SYSDATE) + (actfinish - actstart), 'hh24'))) || ':' ...
I have got ASP.NET application and deploy it on my machine/IIS. On my machine I had Oracle 10.2.0.2. This ASP.NET application said that I had different version of Oracle client that the one r...
I am trying to convert a view from SQL SERVER 2005 to Oracle 10g:
CREATE VIEW DIM_CAT100K AS SELECT CAST(0 AS NUMBER) AS CAT100K, 'Not Catastrophic Member above $100,000' AS CAT100K_DESC
U...
Hi,
I am trying to use oracle from my jave program, i got following exception
Exception in thread "main" java.sql.SQLException: Io exception: The Network Adapter could not establish the ...
Hi,
I am very new to this, but I'm trying to connect with C++ (VS2003) to an Oracle 10g db. I think I'm having some problems with including the occi.h and the libraries. Does someone have...
Hello. We have a client/server setup to run our application. Our Application runs on an HPUX Itanium server dedicated soley to run the application. And, we have a database specific only ser...
I get quite tired of getting tns wrongly set up. Every time I see the following message I knew it is tns error
Enter password: ...
How to run .pkb extension file using sqlplus in ORacle 10G
the above code takes 45 mins to 75 mins to execute and needs to be tuned.
any advice will be appreciated
i have a problem with my web application in aspx .NET with a oracle 10g xe database. i can create my users from web application to the database but i cant logged in the web application. the u...
Hello,
What is the meaning of below. How to interpret it and convert in MB/GB.
SQL> show sga;
Total System Global Area 1.0855E+10 bytes
Fixed Size 2089216 bytes
Var...
If I create a view by Sql Plus How I can see the create view statement again ?
For example
CREATE VIEW Emp_v AS
SELECT Empno, Ename, Deptno
FROM Emp_tab;
How I can show again this ...
