Hi, I was hoping someone could help me. I am trying to display the time part of a datetime datatype in my query (in this isntance the column...

PWalker

06-22-2005 05:18 AM
PWalker

i would like some help with exception handling for my backup script. when i issue the command: alter system archive log all; i sometimes get the...

Edwinah63

06-22-2005 03:42 AM
Rauf Sarwar

hi ppl, i'm new to the grp..going thru a major crisis in my professional life..ve done MCA worked as S\W engr in my 1st job which was mainly...

pooja

06-22-2005 12:18 AM
pooja

I'm using Oracle 8i and am trying to keep a backup database current with our Production database. We do a daily full EXP of Production and then...

David_T (MO)

06-21-2005 07:05 PM
joel-garry@home.com

A customer has 11i Purchasing and is unsure how to configure it for sending a fax. After they reserve the funds, there are 2 radio buttons; Print...

Slider

06-21-2005 03:11 PM
joel-garry@home.com

Hi, <Oracle 9.2i> I got 2 questions: Is there a package (or something else) where I can get a GUID from the oracle system? (something like SELECT...

Andreas Mosmann

06-21-2005 12:48 PM
Frank van Bortel

Hello all, I've got a perplexing problem, and am stumped. I've got 2 databases...both are same version of 9.2.0.6. Same patch level. One is a dev....

chilecayenne@gmail.com

06-21-2005 08:32 AM
chilecayenne@gmail.com

I'm coding a function a document to a server using POST method. ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error Can someone...

humoib@gmail.com

06-21-2005 07:58 AM
Billy

Hi NewsGroup, <Oracle 9.2i> for debugging we wrote down a logging that stores some information to file and to database. It would be easier to...

Andreas Mosmann

06-21-2005 05:37 AM
Billy

Hello Experts I am new in Sql triggers and i would like some help I have a Table called ITEM and another callded...

ajay.sonawane@gmail.com

06-20-2005 08:23 AM
DA Morgan

hi ppl, i'm new to the grp..going thru a major crisis in my professional life..ve done MCA worked as S\W engr in my 1st job which was mainly...

pooja

06-20-2005 07:17 AM
pooja

Hi! I'm trying to use the instantclient for odbc. I've installed everything, base in c:\oracle\instantclient10_1, odbc addon as well, did the .bat...

Volker Hetzer

06-20-2005 07:08 AM
Volker Hetzer

Hello Everyone, I am learning SqlPlus and I wonder if there's a way to append the some of my SQL practice into the same file? I mean, I would like to...

Generic Account 1209

06-18-2005 05:10 AM
William Robertson

hi... im using visual basic 6.0 and oracle 9i to develop a software.and for reports im using crystal report 9... the problem is when i add the report...

contactronak@gmail.com

06-18-2005 02:42 AM
contactronak@gmail.com

It seems I've searched for years on this one, on and off, but haven't ever found an acceptable answer. I have a table x with a single composite...

Rich

06-17-2005 05:03 PM
DA Morgan

Hello, I am doing an import from a dump file that includes comments, like so: ALTER TABLE "MYTABLE" MODIFY ("MYCOLUMN" DEFAULT 'N' -- this is a...

Andrew Clark

06-17-2005 03:20 PM
Anurag Varma

OracleStore (Canada English) has a reference to Oracle Application Server Standard Edition One. Visible on the 'User Minimums' pages, accessed...

HansF

06-17-2005 09:36 AM
HansF

Hi, I have a Oracle9-Database with internal UTF-8 encoding. Is it possible to get ISO-8859-1 output using sqlplus? Thanks! Christoph

Christoph Krempe

06-17-2005 08:13 AM
Christoph Krempe

I cannot guarantee a stable connection of my application to the database over a long time (a week or longer). I'm told to implement a test to...

Torsten Mueller

06-17-2005 05:10 AM
sybrandb@yahoo.com

I have oracle 9.2.0.1 In T.O.A.D i wrote complex query and with option export to flat file (no delimeter) i generate spec file and i exported data...

Tomislav Kokoska

06-17-2005 04:21 AM
Tomislav Kokoska

Dear all, I need step by step for increase SAP/ORACLE Table GLSP___0 ? FYI, I used SAP R/3 4.6C and Oracle Ver. 9.2.0.4.0 Regards, Paul --

pitungj

06-16-2005 05:35 PM
pitungj

Oracle’s 9i OCP (Oracle Certified Professional) DBA (Database Administrator) certification is a mid-level certification for IT professionals who...

Kennedy_f

06-16-2005 09:47 AM
DA Morgan

Good morning, Here is the message: SQL> connect sys/****** as sysdba Connected. SQL> Drop database link...

Ronald Ferro via DBMonster.com

06-16-2005 01:55 AM
Billy

I need help understanding whether I should invest in the scenario below Scenario: 1- I create a table table1, with colmns c1 (varchar32) ,c2...

upuaut@yahoo.com

06-15-2005 11:35 PM
DA Morgan

I have created a BFILE. Most DBMS_LOB functions works. However, FILEOPEN does not work. Any solution? Same output from SQLPLUS: SQL> desc x Name ...

thtsang_yh@yahoo.com.hk

06-15-2005 01:46 PM
thtsang_yh@yahoo.com.hk

Consider this simplified table structure: ID TITLE ID BOOKID NAME

danlamb

06-15-2005 08:51 AM
danlamb

Hi, I am trying to write a small occi windows applications. I am using VS Studio ..Net 7 (Windows XP). I can compile and link my small...

Michael Luchs

06-15-2005 06:09 AM
Moritz Klein

I am new to PLSQL. I declared an index by table: DECLARE TYPE index_by_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; index_by_table...

simon

06-15-2005 05:55 AM
Chris \( Val \)

"HansF" <News.Hans (AT) telus (DOT) net> wrote Good point I know a vendor that uses varchar fields in Oracle to store raw data. Means the server...

Rafal Dabrowa

06-15-2005 01:27 AM
Rafal Dabrowa

Hello Group, I was trying to write a script that returns the name of my tables and the number of records in each table. This is as close as I can...

Bruce G.

06-14-2005 03:54 PM
Jan Kucharski

Hi! I've got a rather stupid constraint problem: There's a table with data on PCB symbols (like "7400" or "Resistor"). Per symbol there's the number...

Volker Hetzer

06-14-2005 06:49 AM
andrewst@onetel.com

I performed the following under Oracle 10g: CREATE TABLE TESTER ( COL1 VARCHAR2(8) NOT NULL, COL2 VARCHAR2(8)...

reidt2@yahoo.com

06-13-2005 03:32 PM
Anurag Varma

My company is going to spring for some Oracle training courses for me. I'm wondering how much difference there is in the product between 9i and...

DH

06-13-2005 11:11 AM
HansF

What is the difference between LONG RAW and RAW? It seems that both represents unstructured large binary data.

mon

06-13-2005 08:46 AM
HansF

Hi all, someone know as possible force refresh of MV by script? I want to refresh when my trigger is on fire. Thanks Alen

Alen Cappelletti

06-12-2005 12:19 PM
DA Morgan

Can I get a select(*) statement to give back only the fields that have data? (I'm running this is SQL plus worksheet, on server 9, client...

deanbrown3d

06-12-2005 03:42 AM
Jim Smith

Hi All, Thanks for your previous help. Now I am facing another problem to writing the script...

Arijit Chatterjee

06-12-2005 02:05 AM
Michel Cadot

I am new to PLSQL. Is this a good programming practice to test if there is 0, 1 or > 1 rows returned from a SELECT INTO: DECLARE v_number...

simon

06-11-2005 05:50 PM
William Robertson

Hi All, I am trying to write a script as a menu from SQLPLUS screen. =====================Code -------1. Activity1 -------2. Activity2 set echo...

Arijit Chatterjee

06-11-2005 04:15 AM
Arijit Chatterjee

Hi, Ouput example : Dept No : 10 Accounting No of Employees : 2 Employee Details :

parag9i@gmail.com

06-11-2005 03:59 AM
Frank van Bortel

Hi, I am handling a complex query and ultimately the problem boils down to this. I have the data in the format Col1 Col2 X a X ...

puneet.bansal@wipro.com

06-11-2005 03:11 AM
at\@

I am writing a PL/SQL Block to loop through a series of numbers and insert them into a row of my table ... but I need to change an alpha character...

WebTracer

06-10-2005 06:30 PM
Rene Nyffenegger

I have installed Oracle 9i client tools on my XP Pro machine, but the Oracle ODBC driver does not show up as a choice in Data Source Administrator....

dgmoore@erols.com

06-10-2005 05:48 PM
Star Fleet Admiral Q

niranjan.sivaraman (AT) gmail (DOT) com wrote: You can write a function that returns the columns as a varchar2 for a given index

Gerard H. Pille

06-10-2005 05:25 PM
Barbara Boehmer

Given employee table is : create table employees ( employee_id number, manager_id number, ... ) manager_id is self-referencing another row's...

simon

06-10-2005 04:36 PM
Rene Nyffenegger

I am new to PLSQL. Here is a sample code from a textbook. Is the ELSE checking for 'error > 1 rows' necessary ? As far I know if there are >...

jack

06-10-2005 09:10 AM
Anurag Varma

I was wondering if there was a tool sitting out there anywhere that would enable me to quickly generate CREATE TABLE statements using the schema used...

ManChild

06-10-2005 09:08 AM
Mark D Powell

In bioinformatics tabular separated files (TSV) are quite common. It occured to me to try to set up Oracle external table (Oracle 10g) from such a...

Arto Viitanen

06-10-2005 07:18 AM
Arto Viitanen

Hi, I was wondering why people put "+ 0" after a column when creating view. For example, CREATE OR REPLACE FORCE VIEW APPS.PER_ADDRESSES_V (a, b,...

andyho99@yahoo.com

06-10-2005 01:59 AM
Jim Smith

I had some code in the package body but when taking it out I still encounter the error: Compilation errors for PACKAGE SIEBEL.IF_DVA_INBOUND Error:...

absinth

06-10-2005 01:38 AM
Akp