Is there a quick and easy way of getting the number of segments used by a particular table?
Its in one tablespace and with an owner of "sqluser"
So far I have
SELECT segment_name, extent_i...
http://www.experts-exchange.com/Database/Oracle/Q_23332862.html
Zones:
OracleDate Answered: 04/17/2008 Grade: A Views: 0
I'm trying to compare data from 2 remote tables.
I have Toad for Oracle Version 9.6.1.1 and can connect to these remote servers fine. I am trying to create a datbase link but i'm recieving the f...
http://www.experts-exchange.com/Database/Oracle/Q_23510017.html
Zones:
OracleDate Answered: 07/03/2008 Grade: A Views: 62
I am copying data from one db to another accross a network using oracle links.
e.g.:
insert into tablename
(field1, field2, etc.)
(
select field1, field2, etc.
from tablename@lin...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23555010.html
I have a specified column value like " moe_2002_acso_link" . form this i need to find the table name and column name where the data presents ??
im nor sure is it possible or not !! but still ny...
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23755837.html
I have a report that pulls the number of picks by a customer ID. Is there a way to pull the total picks of 1 customer ID as a subtotal and keep the original results intact?
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23804725.html
This works ok but the resulting rows get duplicated to hundreds. Why stop at 439 I mean if its going to go that far why not just go on forever lol Anyone explain both why this happens within SQL ...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_23004960.html
Zones:
Oracle 9.xDate Answered: 12/06/2007 Grade: A Views: 0
Hello Experts:
I am doing this simple PL sql read and write into a tab delimited flat file. Boss wants column name in every report. I am using following code to get the data, but have no idea ...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_23064045.html
How should I write a query if I want the current example result:
column1 column2
------------------------------------
A 12
B 22
C 303
To ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23122663.html
Zones:
SQL SyntaxDate Answered: 01/30/2008 Grade: A Views: 0
Hi,
I need an Oracle stored procedure to return a data set.
Please advice.
http://www.experts-exchange.com/Database/Oracle/PL_SQL/Q_23398855.html
I am unable to connect to Oracle Server 9.2 under HP-UX from windows XP oracle 9i client.
it is giving error ORA-12154 and also in my system/PC there are three oracle client softwares i.e oracle...
http://www.experts-exchange.com/Database/Oracle/Q_23491037.html
