dbTalk Databases Forums  

Sponsored Links


comp.databases.oracle comp.databases.oracle


Discuss in the comp.databases.oracle forum.



Post New Thread
Threads in Forum : comp.databases.oracle Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
0 175
WHERE d1 >= trunc(add_months(sysdate,-1),'month')
Joe Powell
07-02-2004 10:13 AM
Wit Serdakovskij Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
0 262
Connect /as sysdba; @?/rdbms/admin/prvtxdb.plb exit.
Rajeev
06-29-2004 09:42 AM
Mark D Powell Go to last post
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 Go to last post
2 147
please give me a mail.3q
phpbird
06-28-2004 02:02 PM
Ed prochak Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
0 159
I would like to EXPORT the DATABASE INSTANCE Named "GATES" and...
HARI OM
06-25-2004 06:11 PM
HARI OM Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
1 195
Post New Thread

Display Options
Showing threads 501 to 550 of 2012
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.