How could I refresh a sequence in Oracle using an SQL statement? I've got the problem, that the current number of a sequence is less the highest...

Robert Wehofer

02-23-2005 04:49 AM
Rauf Sarwar

My system id 9.2.0.5 on Windows 2000 with sp 4 One of my old table have columns build with char, one is order_id as char(11) and other one...

cschang

02-22-2005 10:57 PM
cschang

Hi, I need to analyze the data of very large tables (over 10 million records). Therefore I want to retrieve a set of randomly chosen records (about...

andreas.krisor@gmx.net

02-22-2005 06:33 PM
casey.kirkpatrick@gmail.com

Expert Oracle9i Database Administration http://www.webfile.ru/195712 Oracle Wait Interface A Practical Guide to Performance Diagnostics &...

sinvv

02-22-2005 02:03 PM
DA Morgan

I would like to automatically write a users e-mail address based off of the first letter of the user's first name combined with the user's last name....

Paul Izzo

02-22-2005 02:02 PM
DA Morgan

Does anyone have any idea why, in SQL*Plus 3.3.4 under Oracle 8.1.6 (with all the patches), this query will work: SELECT MAX(SUM(ci.quantity)) INTO...

McCormick

02-22-2005 09:37 AM
McCormick

Je dois extraire de ma base, toutes les donnees des abonnes en fonction de ce qui est dans mon "select". Par contre, il ne faut pas que j'ai ceux...

Kevin

02-22-2005 09:25 AM
Stéphan Paya

On 21 Feb 2005 05:04:09 -0800, "Paul Izzo" <paul.izzo (AT) mosca-ag (DOT) com> wrote: Please stop wasting bandwith, and forcing people to read...

Paul Izzo

02-22-2005 07:58 AM
Paul Izzo

Hi, I have a problem with jobs -after creating a job when goes time of its execution nothing happens. When I start job manually (dbms_job.run) it...

Wojtek Wawrzyniak

02-22-2005 05:35 AM
Wojtek Wawrzyniak

I need to export public synonyms from one to another oracle database. Since public synonyms are logical objects and owner 'PUBLIC' is also logical a...

Tom

02-22-2005 03:55 AM
Tom

In some Pro*C productivity library I wrote about 10 years ago. I was going through my archives and found it. Here are the docs I wrote for the...

Stan Milam

02-21-2005 11:18 PM
Mark Bole

Hello, I just observed that while creating index with "COMPUTE STATISTICS" also collect the table/column (for the column in index)...

maks

02-21-2005 05:30 PM
maks

Hi, I have written a script that will get the age of a person in Years, Months and Days, based on the sysdate and date_of_birth in a table. Enjoy -...

Craig & Co.

02-21-2005 04:28 PM
Craig & Co.

OCA Oracle 10g Administration I Study Guide: http://www.webfile.ru/193796 OCP Oracle 10g New Features for Administrators Study...

sinvv

02-21-2005 09:39 AM
sinvv

hello, i have following problem: server: oracle 9i on sun/solaris client: win2k with oracle forms 2000...

Andreas Zimmermann

02-21-2005 08:28 AM
CarlosReis

After install Oracle 8.1.7 on Win XP, message "strtdb80.exe has encountered a problem and needs to close.." occurs after restarting comoputer.. Any...

Tom

02-21-2005 04:38 AM
Frank van Bortel

I'm trying to move a delimited file into a table. One of the fields in my table is set to varchar(4000), however the input is sometimes longer than...

Alex Landsman

02-21-2005 04:26 AM
Frank van Bortel

March 11th sees Scottish Developers present their first Java/Oracle-themed Day Conference. Sessions: * Introduction to JavaServer Faces * Service...

Craig Murphy

02-20-2005 10:23 PM
DA Morgan

Hi there, Our small company regularly alters tables, creates new views, adds triggers and sequences, and these changes have to be reciprocated...

deanbrown3d@yahoo.com

02-20-2005 06:09 PM
DA Morgan

"Monica" <monica.ramosgar (AT) gmail (DOT) com> wrote It sounds like a language issue and not a blob issue. What language are you using? In Delphi,...

Tom Dyess

02-20-2005 06:05 PM
DA Morgan

Hello, I've installed Oracle 10g in a Windows 2003 Standard Edition and everything was working perfectly but one day I start the server and I...

2much4u

02-20-2005 06:01 PM
DA Morgan

Looking for an easy way to generate useful Oracle schema documentation? Download SqlSribe free now! Sql Scribe is a pure 100% Java solution that...

sqlscribe@yahoo.com

02-20-2005 05:55 PM
DA Morgan

We have an old database. Some of the columns were built with char data type. We used to use the Trim() or RTRIM() to trim off the space...

cschang

02-20-2005 05:53 PM
DA Morgan

Hello What is 'outer query' ? Could anybody give any example ? Thanx Michal

vertigo

02-20-2005 05:46 PM
DA Morgan

Question 1:- Describe the following with the help of examples: 1)Generalization and its role in Inheritance. 2)abstract Classes 3)State...

rohit srivastava

02-20-2005 03:48 PM
GreyBeard

This statement is found in oracle's training material: INSERT INTO (SELECT employee_id, last_name FROM employee WHERE...

Den

02-18-2005 02:48 PM
Ed Prochak

All, I have a variable myavg in my sql reports. Now I want to display the value of this variable in a "compute" statement, is that possible ? Or, I...

maya

02-18-2005 12:10 PM
maya

Hello, I'm looking at ways to generate reports based on data in an Oracle database. This data will be viewed in Excel. I've looked at Oracle...

Hank

02-18-2005 11:06 AM
DA Morgan

Hi, I am going to take-up OCA exam of pl/sql this month. I have some doubts in couple of question h so I will send the question to below. I would...

rajii

02-18-2005 06:55 AM
Mark C. Stock

Hello, I have a problem which seems to be common to all of those who try to compile the sample programs that come with the xdk. Actually, I'm trying...

bidon70

02-18-2005 06:44 AM
bidon70

Hi all, Im using the function getParameterMap of HttpRequest.This is working fine if I use it on Oracle Application Server..But If using the same...

srinivas

02-18-2005 05:27 AM
srinivas

http://www.orafaq.com has a forum , i think, for OCP. regards Prasad Yammanur "Den" <dd (AT) hotmail (DOT) net> wrote

prasad yammanur

02-17-2005 09:35 PM
prasad yammanur

Hello INSERT INTO ALL WHEN DEPT_NO IN (12,14) THEN INTO EMP SELECT * FROM EMP_OLD; Is it correct statemant ? I think it's not (without first INTO...

vertigo

02-17-2005 03:11 PM
Ed Prochak

I am trying to get information from an LDAP server using the DBMS_LDAP package. I got the following code from the sample directory that came with...

M Rothwell

02-17-2005 02:05 PM
M Rothwell

I don't know how to begin on a query (SELECT statement) to find all the tasks assigned to an arbitrary manager (say, staffID='JSmith') and...

Bruce Hensley

02-17-2005 01:23 PM
bruce@aristotle.net

Hello Does oracle create automaticly indexes on not null columns ? Thanx Michal

vertigo

02-17-2005 11:46 AM
DA Morgan

Could someone tell me what the OracleCSService service does, and when its needed? I have a batch file that starts and stops a local database on my...

deanbrown3d@yahoo.com

02-17-2005 11:39 AM
deanbrown3d@yahoo.com

Nawiazemy wspolprace przy pracach zleconych ze specjalista w zakresie administracji bazami danych: * Oracle * DB2 Zainteresowane osoby prosimy o...

02-17-2005 09:31 AM

Hello i have table with columns: empno, empname and salary. How should i ask to receive empno,empname and salary for distinct empname (empno and...

vertigo

02-17-2005 08:10 AM
vertigo

Hi there. I have an Oracle Database 8.1.7.0.0 running on Windows 2000 SP4. I have a query from one customer which gives a different result...

Marc Eggenberger

02-17-2005 05:53 AM
Marc Eggenberger

I'm doing a query, using NOT LIKE, but not getting the results I would like. WHERE myfile NOT LIKE 'VAR%' I would like for it to return ALL records...

Randy Harris

02-16-2005 07:56 PM
Rauf Sarwar

I've hit a problem on pro*c at work and I'm not sure what's causing it - One problem is that I'm not a pro*c programmer ! we have an oracle cursor...

John Nichol

02-16-2005 04:26 PM
John Nichol

I need to grant a user the ability to recompile invalid views on another schema. For procedures/functions/packages is is simple: grant alter any...

ford_desperado@yahoo.com

02-16-2005 02:03 PM
ford_desperado@yahoo.com

Is there a way to copy users or roles and their grants from one instance to another? Perhaps using "exp full=y", then imp?

Randy Harris

02-16-2005 11:01 AM
Mark D Powell

Hi, I'am facing a strange behaviour of my ORACLE 9.2.0.4 server. I always get the same time back from select to_char(sysdate, ('DD.MM.YYYY...

Zephyr

02-16-2005 10:48 AM
Zephyr

The Oracle RDBMS includes an audit command that can be used to perform a wide range of basic auditing activities. I am against auditing everything...

Mark D Powell

02-16-2005 09:58 AM
Mark D Powell

I have a question on some information that has been passed on similar threads. Specifically concerning the possibility that Oracle would never ignore...

G Quesnel

02-16-2005 08:55 AM
Thomas Kyte

Hi, Is there anyway to make an http connection to url from an stored procedure?. I need a oracle job, who have send xml information to a http web...

Ion

02-16-2005 02:54 AM
Ion

Hi, Thank you for your responses, so far. I have since found out the query used would return no records. select /*+ INDEX (MESSAGE_DETAILS...

Craig & Co.

02-15-2005 10:29 PM
Craig & Co.

As well known a DATE or TIMESTAMP type can be converted (to VARCAHR) after selection but BEFORE writing to the ResultSet by using the CONVERT...

George Dainis

02-15-2005 07:48 PM
George Dainis