Sponsored Links

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

Page 14 of 176

« First

114

Last »

Threads in Forum : comp.databases.oracle.misc

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
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 07:09 AM Vladimir M. Zakharychev	4	73
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 05:13 AM Laurenz Albe	16	206
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 08:52 AM D-Squared	12	118
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 03:59 PM Maxim Demenko	32	284
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 10:10 AM Laurenz Albe	16	188
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 04:07 AM aarandryke@gmail.com	0	50
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 04:47 PM sybrandb@hccnet.nl	16	139
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 01:19 PM Frank van Bortel	8	64
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 07:02 PM joel garry	20	136
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 03:21 PM DA Morgan	12	176
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 12:34 PM Aya the Vampire Slayer	8	54
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 12:17 PM Janwillem Borleffs	4	91
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 05:06 AM Viktor Wiens	8	50
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 08:46 PM DA Morgan	60	607
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 06:41 PM Spin	12	109
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 02:03 PM joel garry	32	327
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 07:21 AM sybrandb	4	175
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 04:54 PM Spin	16	105
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 01:25 PM DA Morgan	8	79
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 01:19 PM joel garry	12	108
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 10:42 AM Laurenz Albe	20	155
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 04:18 AM Laurenz Albe	4	82
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 09:40 AM carlos.ohiggins@yahoo.com	0	154
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 10:37 AM William Robertson	16	235
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 06:03 PM Amistad	8	85
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 03:23 PM joel garry	36	165
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 12:28 PM Martin	0	56
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 03:23 PM Randall	0	138
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 09:10 AM ddf	12	120
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 11:40 PM Michel Cadot	16	76
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 09:12 AM ddf	4	35
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 03:20 AM sbrkic@yahoo.com	0	52
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 03:28 PM joel garry	36	396
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 03:18 AM mh@pixar.com	12	98
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 03:14 AM Carlos	32	262
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 09:00 PM Peter Nilsson	8	148
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 06:46 AM Frank van Bortel	8	147
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 10:57 AM DA Morgan	24	152
oracle oracle 10g topics http://seeallsoftwarebooks.blogspot.com/2008/10/oracle-10g-topics.html Oracle9i... kalpana	10-24-2008 12:20 PM kalpana	0	180
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 12:06 PM Michel Cadot	20	200
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 09:43 AM Shakespeare	8	45
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 08:46 AM ddf	12	204
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 06:22 PM joel garry	20	128
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 12:51 PM Aya the Vampire Slayer	8	62
oracle Oracle9i: New Features for Administrators http://seeallsoftwarebooks.blogspot.com/2008/10/oracle9i-new-features-for.html ooracle... sarithainnew@gmail.com	10-23-2008 12:20 PM sarithainnew@gmail.com	0	47
date format not recognized 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 01:10 AM muhammaddzulkarnain@gmail.com	0	57
ORA-01460 error ( 1 2 3 4 5 ) I'm trying to load images into an Oracle table using this... blindsey	10-23-2008 12:02 AM Vladimir M. Zakharychev	44	525
Oracle Forum ( 1 2 3 ) Yes I know that there are dozens of Oracle Forums out there and this group is as good a place as any, yet I would just like to invite everyone to... Sadik	10-22-2008 08:48 PM DA Morgan	20	321
Executing pkb withing an IF ..Then statment: PLS-00103 Encounteredthe symbol Please help, I am trying to create a script for patching the database. The script works with INSERT or SELECT, but when i try to execute a package... NGrybov@gmail.com	10-22-2008 05:46 AM NGrybov@gmail.com	0	174
how to get the date range ( 1 2 ) Hello Everyone I have a problem to define the date range. Firstly, this is my sql statement: define date_start = '20080801'; define date_end =... muhammaddzulkarnain@gmail.com	10-21-2008 02:00 PM Ed Prochak	16	71

Page 14 of 176

« First

114

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