| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I have a question about how to retrieve the information of the calling
instance, such as instance name, in an external C procedure.
Thank...
Carlo Chung
|
07-09-2004 07:59 PM
Mark D Powell  | 3 | 233 |
| | | Hi!
Where running Oracle database 9.2.0.1.0 on Sun Solaris 8 7/01 (SPARC
platform). I'm trying to use the OS authentication method for a user
owning...
Christian Eriksson
|
07-09-2004 06:14 PM
Christian Eriksson | 4 | 273 |
| | | Hi All,
I am suddenly in a position where I need to learn to be my own Oralce
DBA. I have limited experience with Oracle and haven't ever...
Diana
|
07-09-2004 12:01 PM
Diana | 1 | 223 |
| | | It is the innovative way of keeping all your Favorite URLs on the web.
http://www.linkmemory.com
You come across many new websites each day. You...
LinkMemory
|
07-07-2004 10:58 PM
LinkMemory | 0 | 156 |
| | | Hello,
I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
of the PACKAGE BODY.
Currently the only means I know of is TOAD's...
george lewycky
|
07-07-2004 05:30 PM
Chris | 4 | 198 |
| | | I'm having problems with the output of the following script (I've
simplified it):-
select a.section,a.user,count(b.number),null
from table a, table...
Chuck100
|
07-07-2004 12:37 PM
Chuck100 | 4 | 297 |
| | | I'm trying to perform this insert in a non-procedural environment:
INSERT INTO table
(column1,
column2)
SELECT
:col1value,
MAX(column2) +...
Elliott
|
07-07-2004 12:12 PM
D Rolfe | 3 | 170 |
| | | What are the best tools/apps for creating spreadsheet reports
generated using an Oracle database? Considerations include cost,
simplicity of use,...
Joe Powell
|
07-06-2004 08:29 PM
Hans Forbrich | 2 | 166 |
| | | Please let me know how I can Load a packed decimal date coming from a
file from mainframe be loaded into a Oracle table date column? Any
help will be...
tamrakar
|
07-06-2004 06:53 PM
Davis | 1 | 348 |
| | | Hi.
We had a PC that had Oracle Client 8.0.5 and 8.1.7 installed in Default_Home
(c:\orant) and Default_Home1 (c:\oracle).
A third party package,...
John
|
07-06-2004 11:08 AM
Mark D Powell | 2 | 282 |
| | | Hi.
I have a number of batch jobs that are ran nightly on our Windows 2000 based
Oracle 8.1.7 (soon to be 9i) server. I have these designed just...
John
|
07-05-2004 11:22 AM
doug | 3 | 178 |
| | | We are a software development company based in the Netherlands. For
projects in Belgium we are looking for a Oracla Database Developer
(knowledge of...
Jobs @ Redline-systems.com
|
07-05-2004 06:11 AM
Jobs @ Redline-systems.com | 0 | 175 |
| | | WHERE d1 >= trunc(add_months(sysdate,-1),'month')
Joe Powell
|
07-02-2004 10:13 AM
Wit Serdakovskij | 10 | 359 |
| | | I'm working on an application where the user would like the capability
of creating new data elements, enter a value, and store the
information on a...
Joe C
|
07-02-2004 09:56 AM
Mark D Powell | 1 | 226 |
| | | a new user of oracle 10g.
tried the following statements on scott/tiger with tablespace x
create table mytest (
a varchar2(30)
);
alter table...
Andy
|
07-02-2004 04:49 AM
zhu chao | 1 | 150 |
| | | I have a problem with the regexp_like method.
How do i use it when i want to know if a text contains a word?
Example:
The text 'hi, how are you?'
If...
winnant
|
07-02-2004 02:11 AM
winnant | 0 | 253 |
| | | I plan to change the datatype from long raw to blob as from tables
stud_photo and cimpant _image below. But i am not sure if it is a good
idea. pls...
tracy
|
07-01-2004 03:22 PM
cs | 2 | 193 |
| | | Hallo
i am a beginner into Oracle Technologies.I would like to make backup
of my database,but i dont know how.Is there tools?Can i schedule...
Cristina
|
07-01-2004 03:10 PM
cs | 3 | 179 |
| | | Hi all
We're in the process of porting a system written for MySql to Oracle.
I would like to find out what the Oracle licensing issues are....
Sporge
|
07-01-2004 12:13 PM
Hans Forbrich | 7 | 173 |
| | | Hi,
I'm having a nightmare when trying to insert records into an Oracle
database that contain dates. I've believe I should be using the
to_date()...
Paul Long
|
07-01-2004 09:55 AM
Mark D Powell | 1 | 311 |
 | | Daniel Morgan <damorgan@x.washington.edu> wrote in message
Daniel is currently consulting for a bitch and/or converting to a bitch and
looking to...
omlet@omlet.org
|
07-01-2004 08:50 AM
Pete's | 1 | 132 |
| | | I currently have some trouble because of a misconfigured storage. The
technicans are involved, but the reconfiguration will requires several...
Markus Breuer
|
06-30-2004 08:34 AM
Markus Breuer | 0 | 127 |
| | | Hello,
I'm using Oracle 9.2 and would like to automatically save a copy of
each deleted record in XML format to another database table. There
would...
DaveS
|
06-29-2004 04:14 PM
DaveS | 0 | 262 |
| | | Connect /as sysdba;
@?/rdbms/admin/prvtxdb.plb
exit.
Rajeev
|
06-29-2004 09:42 AM
Mark D Powell | 1 | 178 |
| | | omlet (AT) omlet (DOT) org wrote:
Just curious - in your words, what is in this 'complete monitoring package'
that is not in Oracle Enterprise...
Hans Forbrich
|
06-28-2004 03:21 PM
omlet@omlet.org | 2 | 147 |
| | | please give me a mail.3q
phpbird
|
06-28-2004 02:02 PM
Ed prochak | 1 | 165 |
| | | Hi,
I was wondering if anyone could answer the following questions:
I'm using Oracle 8i and MS SQL Server 2000 by the way.
In oracle you can...
Dav
|
06-28-2004 01:39 PM
Dav | 0 | 257 |
| | | Hi
Please Help me that I faced this Question in an interview but I cant
Get The Proper Answer from Any Where..
SQl> Select * from emp where rownum <...
Prabu Krishnan
|
06-28-2004 11:09 AM
Bent Stigsen | 2 | 183 |
| | | Dear All,
I am faceing a problem in sql output in SQLPLUS screen.I am explaining
the...
Arijit Chatterjee
|
06-28-2004 07:52 AM
Arijit Chatterjee | 2 | 211 |
| | | Hello,
I have an Oracle Forms/Reports application made up of 44 forms, 7
reports and 4 stand alone forms that can be called independently or
from...
ptreves
|
06-28-2004 12:06 AM
ptreves | 0 | 198 |
| | | got a nice security set up in my test schema. updated the
text to reference the next level up in the schema hierarchy.
installed through SQL*Plus as...
robert
|
06-26-2004 10:37 AM
robert | 1 | 182 |
| | | Hi
i would like to have suggestions for optimizing select query so that
it runs faster.Besides using indexes on key columns what are...
hariom sharma
|
06-26-2004 01:23 AM
hariom sharma | 0 | 178 |
| | | cross posted to comp.database.oracle by mistake.
I'm getting the infamous ora 12154 - TNS could not resolve connect
identifier error.
My computer is...
George
|
06-25-2004 07:25 PM
George | 0 | 159 |
| | | I would like to EXPORT the DATABASE INSTANCE Named "GATES" and...
HARI OM
|
06-25-2004 06:11 PM
HARI OM | 0 | 184 |
| | | Table Name : Emp
EID ENAME
------ ----------
1001 John
1002 Gokul
1003 Daniel
1004 John
1005 Gokul
1006 Daniel
Prabu Krishnan
|
06-25-2004 12:29 PM
Ed prochak | 2 | 171 |
| | | In 11i Oracle has replaced the Expense distribution report APXEDRBS with a
Payables account analysis report. and the users strongly prefer the...
Gene Maillet
|
06-25-2004 10:23 AM
Greg Forestieri | 1 | 152 |
| | | Tom,
Suggest we try and get there for 1PM - by the time they've shown us how
the boat works and taken us on the 'trial cruise' they mention...
David Rolfe
|
06-25-2004 07:50 AM
David Rolfe | 0 | 199 |
| | | Hi,
I am using jsp page to connect to oracle database. We are using a
Borland Enterprise Server 5.2 application server and a web server
running on...
Vijai Kumar
|
06-25-2004 06:49 AM
sybrandb@yahoo.com | 1 | 184 |
| | | Is there a way to customize the SQLPLUS login banner ? ( e.g in
addition to the regular Copyright messages, is it possible to display
additional...
abhay
|
06-25-2004 05:46 AM
Romeo Olympia | 1 | 248 |
| | | Hello,
When I try to connect to my Oracle instance on the W2K server that it
is installed on, using SQLPLUS (ie, SQLPLUS user/password@instance),...
The CQMMAN
|
06-25-2004 05:33 AM
The CQMMAN | 8 | 198 |
| | | hi,
i worry about people doing something they shouldn't to my db and I
would like to track any structural changes (who and which)to my db. I
am using...
LC
|
06-25-2004 03:48 AM
tracy | 3 | 158 |
| | | Hi!
I followed the installation instructions from the oracle 9i built in
documentation and started the installation with the Result of this
output on...
Tamer
|
06-25-2004 03:39 AM
Frank van Bortel | 3 | 317 |
| | | Hi.
I wrote some stored procedures used by a web application. As I am
fairly new to Oracle, I am missing some concepts when creating...
Robert Scheer
|
06-25-2004 12:43 AM
hrishy | 1 | 231 |
| | | Hey,
how can I get ORA-..... error messages in languages other than
english.
I did a
alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1';
but...
Michael John
|
06-24-2004 02:34 PM
Michael John | 3 | 189 |
| | | I am relatively new to the DBA role. I am 8i OCP, and have a solid technical
background. Where I'm weak is on design. I'm aware that there is more...
Dale DeRemer
|
06-24-2004 09:07 AM
Dale DeRemer | 2 | 172 |
| | | Hi all,
We're looking at a vendor who uses the InterSystems Cache Database
Platform, but our IT department has zero experience with this...
Alex
|
06-23-2004 09:15 AM
Wolf Koelling | 4 | 222 |
| | | Hi,
I need help urgently. Yesterday i move a tables and indexes to
different tablespace using these command:
alter table my_table move tablespace...
tracy
|
06-23-2004 04:06 AM
LC | 2 | 165 |
| | | (Using Oracle 8)
I have 4 tables, which I describe below: CUSTOMERS, BOOKS, ORDERS,
ORDERITEMS. These should be pretty self-explanatory, although in...
Mark
|
06-22-2004 10:59 PM
Romeo Olympia | 1 | 135 |
| | | in my query can I convert a string to int
select convert(int,str_col) from table
I just need the order by, if there's a different way.
select...
Cindy Lee
|
06-22-2004 09:36 PM
Romeo Olympia | 1 | 205 |
| | | Hi All,
Do u know how to make 22nd column a primary key if there is a table of
100 columns and you don't know the names of the columns?
If u do...
Prabodh
|
06-22-2004 04:51 AM
Douglas Hawthorne | 1 | 195 |
