Sponsored Links

comp.databases.oracle.misc comp.databases.oracle.misc

Page 11 of 173

« First

111

Last »

Threads in Forum : comp.databases.oracle.misc

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Tool for CSV dump? ( 1 2 3 ) Hi experts, are there tools to make a fast dump of complete databases to CSV? Without needing any additional licenses from Oracle...? TIA Tellie Tellie	11-27-2008 05:10 AM steph	28	90
JOINs against a subquery ( 1 2 ) I have a pretty complicate query that produces a sales summary, something similar to this: customer_id sales_amount =========== ============ 1 ... Álvaro G. Vicario	11-27-2008 03:08 AM Álvaro G. Vicario	16	56
usage of a calculated index Hello, I've created the following table and view: _____ CREATE TABLE X_EF ( ID_EF INTEGER NOT NULL, A_VALUE VARCHAR2(1) NOT NULL, A_NUMBER... Norbert Winkler	11-25-2008 09:45 AM Norbert Winkler	0	142
Performance: SDO_RELATE vs. Stored Procedure ( 1 2 3 ) Hi, I'm relatively new to Oracle and as I am experiencing some inexplicable results I ask for your help. In Oracle 10g XE I created a datatype for... schaef2k@googlemail.com	11-23-2008 10:12 AM Shakespeare	28	199
Re: Migrating from Win2k3 to linux "Jan Lühr" <usenet (AT) stephan (DOT) homeunix.net> wrote export from the original and then do a full import in the target. (pre-create the... gym dot scuba dot kennedy at gmail	11-23-2008 09:53 AM Vladimir M. Zakharychev	4	127
Regarding "how can i trap the empty explicit cursor value" ( 1 2 3 ) Hi, i write a explicit cursor but for the some condition data not available for that cursor. at that time how can i trap the NULL value for the... Prady The fire	11-22-2008 11:24 AM Robert Klemme	20	203
Using Oracle Searches Hi, We have an application on our web site where users can enter a product code into a search box. The box works similar to Yahoo's financial page... amerar@iwc.net	11-21-2008 06:09 AM Vladimir M. Zakharychev	4	38
oracle instance_name vs. service_name ( 1 2 ) If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secret1 (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the... JÅns MÁrtin SchlÁttÅr	11-20-2008 04:13 AM Laurenz Albe	16	171
Schema Inter-dependencies ( 1 2 ) I am at a new position where they host multiple applications in Oracle (9.2.07, just migrated to 10gR2) that are all hosted on the same database. ... D-Squared	11-17-2008 07:52 AM D-Squared	12	54
Date range view ( 1 2 3 4 ) I am currently using Oracle 9i and have created a table: CREATE TABLE FSR_TECH ( ID VARCHAR2(20), TECHNICIAN VARCHAR2(20), FROM_DATE... dleland3@gmail.com	11-14-2008 02:59 PM Maxim Demenko	32	164
preferred method to sleep()? ( 1 2 ) At http://www.psoug.org/reference/sleep.html I see four methods to sleep: * dbms_backup_restore * dbms_drs * dbms_lock * user_lock Are any of them... mh@pixar.com	11-13-2008 09:10 AM Laurenz Albe	16	152
exporting datas from an Oracle db embedded in an office automationsoftware Hi everyone, if the subject is a little bit cryptic, I will try to explain it better. A client of mine manages his business using a software based... aarandryke@gmail.com	11-13-2008 03:07 AM aarandryke@gmail.com	0	32
upsert strategies? ( 1 2 ) So far, I've figured out 4 possible ways to perform upsert-like functionality: 1. try insert, on exception update 2. try update, on exception... mh@pixar.com	11-12-2008 03:47 PM sybrandb@hccnet.nl	16	68
terminology q. regarding FK I'm doing some FK analysis of our tables by making a directed graph representing FK dependencies and then traversing the graph. In my code, I name... mh@pixar.com	11-12-2008 12:19 PM Frank van Bortel	8	30
table with subtypes, inserting problem ( 1 2 3 ) create or replace type IndirizzoTY as object (via varchar(30), comune varchar(20), provincia char(2)); create or replace type PersonaTY as... Shearer	11-10-2008 06:02 PM joel garry	20	78
how to generate the following output in sql ? ( 1 2 ) I am really really new to sql,please forgive my ignorence. here is my problem I have this table named mis_outtrack desc... skywalker	11-10-2008 02:21 PM DA Morgan	12	145
owa_cookie and owa_custom interaction DB: 10.2.0.1.0 App Server: 10.1.3.1.0 OS (both): Windows 2003 Architecture: The App Server publishes stored procedures in the DB as webpages to... Aya the Vampire Slayer	11-10-2008 11:34 AM Aya the Vampire Slayer	8	38
XMLTYPE schema validation Hi, I know that for the SYS.XMLTYPE you can choose between partial or full, but what I would like is to have no schema validation at all. How can I... Janwillem Borleffs	11-10-2008 11:17 AM Janwillem Borleffs	4	56
simple query with types problem create or replace type IndirizzoTY as object (via varchar(30), comune varchar(20), provincia char(2)); create or replace type PersonaTY as... Shearer	11-09-2008 04:06 AM Viktor Wiens	8	27
What's a quick simple way to test Oracle connectivity between client and database server? ( 1 2 3 4 5 ... Last Page) Gurus, Just learning Oracle. With help from a guru, installed 10g database on one server and 10g client on another. What's a quick simple way to... Spin	11-07-2008 07:46 PM DA Morgan	60	469
What's the default database administrator username in the Orcale 10g world? ( 1 2 ) Gurus, What's the default database administrator username in the Oracle 10g world? For MS SQL Server it is "SA". But someone told me for Oracle it... Spin	11-07-2008 05:41 PM Spin	12	57
Insert Statement ( 1 2 3 4 ) Can you use a CASE statement in an INSERT clause with Boolean expressions? Something like DECLARE b boolean := TRUE; BEGIN INSERT INTO a VALUES... artmerar@gmail.com	11-07-2008 01:03 PM joel garry	32	208
OCI.dll error, Invalid access to memory location Hi Friends, I have Windows XP SP2 machine, & have developed an application (Qt application, compiling with mingw libraries) using OCIPlus to connect... avi01	11-07-2008 06:21 AM sybrandb	4	147
Cannot reach remote Oracle instance using tnsping (newbie post) ( 1 2 ) Gurus, I'm an Oracle newbie. I installed 10g database on one Windows server and 10g client on another Windows server. I have TCP/IP and Windows... Spin	11-06-2008 03:54 PM Spin	16	70
Oracle on z/OS Would this be the best place to ask questions about accessing Oracle databases from z/OS? Or is there a "mainframe Oracle" list... Frank Swarbrick	11-06-2008 12:25 PM DA Morgan	8	42
ORA-14109: partition-extended object names may only be used withtables ( 1 2 ) I'm a beginner in using partition in oracle tables. Below query returns ORA-14109. (I skipped on WHERE clause in below query because either way, it... Narokman	11-04-2008 12:19 PM joel garry	12	79
Oracle Client 10g vs. Instant Client 10.2 (Windows XP) ( 1 2 3 ) We have received a Windows application that we are told requires "Oracle Client 10g" to run. We tried downloading Oracle's Instant Client... AMM	11-04-2008 09:42 AM Laurenz Albe	20	87
Oracle pro*c compiler error using REGEXP_LIKE Good afternoon, I have a c/c++ api into some oracle database tables. I'm trying to perform a bulk cursor select using the REGEXP_LIKE function, but... Brian StJohn	11-04-2008 03:18 AM Laurenz Albe	4	45
regexp_like Hi, I want to run a distinct query against a text field."something, something else, etc, etc," I have got this far: SELECT distinct (Summary),... carlos.ohiggins@yahoo.com	11-03-2008 08:40 AM carlos.ohiggins@yahoo.com	0	135
using EXECUTE IMMEDIATE to run DBMS_STATS.GATHER_SCHEMA_STATS ( 1 2 ) When I run the block below, in oracle 10.2.0.3.0, I get the error shown after. Is this a problem with my coding or is it just not possible to run... Kevin S	11-02-2008 09:37 AM William Robertson	16	136
Oracle XE sql apply standby Hi all! I'm trying to configure sql apply standby database with XE ! As i can see all needed is there, except data guard automatism of redo log... Amistad	10-31-2008 05:03 PM Amistad	8	47
comparing a DATE column with "one minute ago", type warning? ( 1 2 3 4 ) How should I be comparing a DATE column with "one minute ago"? I do this: select sysdate, sysdate- interval '1' minute from dual; and get just what... mh@pixar.com	10-30-2008 02:23 PM joel garry	36	109
advice sought: letting application know a table has been changed Hi, I was just wondering if anyone had any alternatives to this situation I have in my oracle app. My application is given tasks to perform which... Martin	10-30-2008 11:28 AM Martin	0	33
Moving File after using it in external table load Using Oracle 9.2.0.8 on Windows XP. I am loading a file into an external table then dropping the table and trying to move the file used to create... Randall	10-29-2008 02:23 PM Randall	0	117
Streams Replication from 10g DB to 9i DB ( 1 2 ) Does Oracle 10g support streams replication from a source database (version 10g) to an Oracle 9i destination database ? Thanks in Advance Ora_DBA	10-29-2008 08:10 AM ddf	12	63
return the correct WW value ( 1 2 ) Hi all, I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. It seems... jjjackjill89@gmail.com	10-28-2008 10:40 PM Michel Cadot	16	41
Two tables are quite the same, but size of theirs ORA datafiles aredifferent! 've got two tables in Oracle 10.1g, Windows 2003. TableA 16,594,824 records CREATE TABLE TableA ( NUMDLE NCHAR(8) NOT NULL, DIGVER NCHAR(1) NOT... Big George	10-28-2008 08:12 AM ddf	4	23
Performance text index Hi, We have a a materialized view containing about 7 million records at the moment with song artist and album information. We hava a column in the... sbrkic@yahoo.com	10-28-2008 02:20 AM sbrkic@yahoo.com	0	23
order by question ( 1 2 3 4 ) Hi, I wonder if following result set would be sorted according to x.z. Or is it possible that the optimizer for some reason, based on the... sbrkic@yahoo.com	10-27-2008 02:28 PM joel garry	36	293
question on using merge to upsert ( 1 2 ) I would like to use MERGE to upsert some simple values. Here's what I've got, which works fine with all my tests, but MERGE is pretty complicated and... mh@pixar.com	10-27-2008 02:18 AM mh@pixar.com	12	66
pl/sql alternatives for server side programming? ( 1 2 3 4 ) If you look at postgresql, they have the idea of pluggable scripting languages, so you can write server side code in tcl, python, etc. Is there an... mh@pixar.com	10-27-2008 02:14 AM Carlos	32	187
Function Query Hi, I have a complex query which uses a regular expression. Is it possible to somehow create an index or something to speed up the queries? We're... artmerar@gmail.com	10-26-2008 08:00 PM Peter Nilsson	8	133
Oracle 9i replication I need help with Oracle 9i replication. I have some experience with basic replication with read only snapshots in Oracle 8i. I have 2 master... Ora_DBA	10-26-2008 05:46 AM Frank van Bortel	8	118
PL/SQL: cursors and loops, hang issue ( 1 2 3 ) I apologize in advance for being excessively wordy. :/ DB: Oracle Database 10.2.0.1.0, Enterprise Edition OS: MS Windows Server 2003, Enterprise... Aya the Vampire Slayer	10-25-2008 09:57 AM DA Morgan	24	85
oracle oracle 10g topics http://seeallsoftwarebooks.blogspot.com/2008/10/oracle-10g-topics.html Oracle9i... kalpana	10-24-2008 11:20 AM kalpana	0	135
trunc year ( 1 2 3 ) Below is to get date range between a month SQL> select sysdate, 2 trunc(add_months(sysdate,-1),'month') start_date, 3 ... muhammaddzulkarnain@gmail.com	10-24-2008 11:06 AM Michel Cadot	20	96
Delete date hello everyone, Can someone help me how to create sql statements to delete the table records and retain only 3 months of data. Concept should be... muhammaddzulkarnain@gmail.com	10-24-2008 08:43 AM Shakespeare	8	26
ORA-00900: invalid SQL statement ( 1 2 ) Hi , I've created the following stored procedure: CREATE OR REPLACE PROCEDURE METReportsCreateDBState AS BEGIN EXECUTE IMMEDIATE 'ALTER TABLE... Nikola Stjelja	10-24-2008 07:46 AM ddf	12	172
date format not recognized ( 1 2 3 ) hello everyone, i just got a problem. This is my statement: select hostname, to_char(to_date(&date_start , 'YYYYMMDD' \|\| to_date(&date_end,... muhammaddzulkarnain@gmail.com	10-23-2008 05:22 PM joel garry	20	86
Use default value when no rows returns. Hi All, I need a help. I have a query inside one shell script and i'm wondering how to return any default value when no rows return from my... Beto	10-23-2008 11:51 AM Aya the Vampire Slayer	8	44

Page 11 of 173

« First

111

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off