RE: procedure/function error

function cannot be called with EXEC. u have to call it within a procedure... -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of purushottam krishna hegdeSent: Friday, June 06, 2003 5:05 PMTo: Multiple recipients of list ORACLE-LSubject:

Off-Topic (InstallShield Installation Problem)

Hellolist, I have installed InstallShield(comes along with Delphi)in my PC. When i run it, it gives me the message : Installshield for Windows Installer is unable to start. Ensure that the Windows Installer engine has been installed properly. but when i go to control panel/services/and

Oracle Data Backup

Hellolist, I am using Oracle 8.1.6 I want to take Back-Up of Application Data at the end of the Day. Which is the best suitable option for backup? any directory (for eg: c:\oracle\ora81\rdbms) where from i can take it directly ? like in unix we have directory where all the

Oracle Interview questions for Implementation/Maintenence

Hellolist, I will be attending interview on oracle..but the position is for Maintenance/Implementation of Software. Could any one of you provide me with set of questions related to maintenance/Implementation issues in oracle ? Regards, Santosh

Rownum

Hello list, I wanted to know the concept of Rownum.. Is it similar to Row Id ? Thanks and Regards, Santosh

Data Capture program

Hellolist, I am in a project where the client wants a data capture program without any validation in any fields.. the back-end is Oracle 8.1.7. what is the best way to give the user the data capture program ? please provide me any solution as soon as possible. Thanks and regards,

RE: Data Capture program

the details.. it can be through ms access etc. but the database is oracle 8.1.7 -Original Message- Sent: Wednesday, March 19, 2003 8:31 PM To: Santosh Varma; Multiple recipients of list ORACLE-L Santosh, As one who has written a pile of these, you've left out a lot of details. The first

RE: Rownum

Thanks to all who replied to me. Now it is clear.. santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of John BlakeSent: Wednesday, March 19, 2003 7:15 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Rownum no, rownum is a

Oracle FAQ's

Hellolist, Could anyone of you tell me good sites where i can find questions/FAQ's related to oracle pl/sql, sql. triggers. Thanks and regards, Santosh

RE: From Microsoft Access to Oracle

oo4o through VBA to make the connection. This seems to work ok, but does require alittle more coding then the average MS Access database project. OTN has some great sections of using ADO and oo4o. - Original Message - From: Santosh

RE: AW: From Microsoft Access to Oracle

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

From Microsoft Access to Oracle

Hello list, I want to create a new form in Access where user input will be thereand the data entered i have to store it in Oracle database. Can anyone of you guide me in doing this..How ??? Thanks and Regards, Santosh

Snapshots

Could anybody of the list give me the correct explanation of the below ?mechanism provided by ORACLE for table replication - Snapshots and SNAPSHOT LOGs Thanks and Regards, Santosh

RE: Snapshots

Thanks to all who replied... santosh -Original Message- Sent: Tuesday, March 11, 2003 8:13 PM To: Santosh Varma; Multiple recipients of list ORACLE-L Santosh, I see that someone else has pointed you to an Oracle Tech Net document. But the short of it is: Snapshot

Date difference function

Hello list, I want to find the difference between 2 dates.. Any Oracle function for that ??? Thanks and Regards, Santosh

PL/SQL

Hello all, I wanted to know how to write scripts in PL/SQL. i mean how to start it ? directly write htem in sql SQL prompt itself ? and any good sites on PL/SQL to learn ? Thanks and Regards, Santosh

RE: oracle version

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Access Internet Web pages from SQL or PL/SQL

exceptionORA-06512: at "SYS.UTL_HTTP", line 174ORA-06512: at line 1 Thanks and Regards, Santosh Varma

Oracle Tools for Data WareHousing

Hello list, Any site where i can find the information related to oracle tools for data warehousing... any help will be appreaciated... Thanks and Regards, Santosh

Off-Topic (Delphi Mailing Lists)

Hello all, Sorry for posting an off-topic discussion. I wanted to know any delphi mailing lists (IF ANY)...could anybody help me out ? Thanks and Regards, Santosh

Invalid Procedures

Hello all, We have installed a package in a client's place. Oracle 8.1.7 is the server version. Often it happens that the procedures become invalid. I want to know because of what reason some procedures become invalid. Thanks and Regards, Santosh

RE: Urgent - Help ....

with NO change is the software and minor change in the software. TIA Regards, Harsh Agrawal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

OT topic - Testing tools

Hello all, Sorry for this off-topic..i want to know what are the testing tools (like win-runner) available and any good sites are there on the net from where i can learn them... Thanks and Regards, Santosh Varma

Newbie to Oracle DBA

Hello list, I wanted to know of some good sites where i can learn the basics as well as advanced DBA topics. Could anybody help me out ? Thanks and Regards, Santosh

Backup and Recovery

and Regards, Santosh Varma

RE: Backup and Recovery

tell me any other utility which the client will be able to use for Backup of their data ? Thanks and Regards, Santosh Varma -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: v$Views and d$Tables

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL

RE: v$Views and d$Tables

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

v$Views and d$Tables

Hello all, Could anyone of you give me a list of v$views and d$tables and their description... ? I am not able to log-in to dba ...i don't have access to it... or any links/documents where i can find them.. Thanks and Regards,Santosh

Database Creation

i am using oracle 8.1.7 and have a product ready for release to the customer in my office. in the client's place, only the oracle is installed. next step i presume is database creation to which my application will interact .. right ?? how do i make sure that the database i create is the

Scripts for creating Tables/schema's

i wanted a script which contains the create table/schema's for a existing database. How to get this script ? any utitlity or which option to be selected for achieving this after i install Oralce ? i am using oracle 8.1.7. Thanks and regards,Santosh

RE: Installation

with. Regards, Mark. Santosh Varma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] vsantosh@psi. cc: soft.netSubject: RE: Installation Sent

RE: Installation

to teach you Oracle. Ok, that's enough...it's now 3:00am in this timezone, and I gotta work tomorrow. G'night all. Hope that helps in some small way, -Mark On Tue, 2002-10-22 at 02:48, Santosh Varma wrote: u r right Mark. as regards version, i am using 8.1.5 I will come down to asking how

Creating new user

how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ? any help will be appreciated. Thanks and regards,Santosh

RE: Creating new user

] for importing on command prompt imp username/password@database fromuser=username touser=username file=export_dump_file If you just want the table structure and no data then use ROWS=N option too. regards Naveen -Original Message-From: Santosh Varma

RE: Creating new user

option too. regards Naveen -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Creating new user how to create a new user ? in oracle 8.1.7 ? and i

RE: Creating new user

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Installation

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Installation

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Installation

, O/S version, and Oracle version. Oracle is a constantly moving target. It's impossible to give a clear and complete answer without that. Hope that helps, -Mark On Tue, 2002-10-22 at 01:13, Santosh Varma wrote: it is a telecom product. i am asking about any oracle specific installations

[no subject]

Hello all, I have a client who will be doing the data capture and give me the data in a flat file. what i need to do in oracle is load from that flat file to my database. any scripts available ?? please send me across. ASAP Thanks and regards,Santosh

RE: Loading a flat file into Oracle

command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Sql query

a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network

RE: SQL Query

FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: Sql query

SQL I can run your query, then what's the problem?SQL Regards Naveen -Original Message-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002 2:53 PMTo: Multiple recipients of list ORACLE-LSubject: Sql query cannot perform

[no subject]

Hello all, I have a query - i have 2 tables - client and project fields in project table - clientid/projectid fields in client table - clientid/name i want to get the maximum orders one client has got. i mean a project having the greatest clients how to write it in single query ??

RE:

: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Off-topic (VB)

Hello all, Sorry for the off-topic discussion. But any one who knows VB can answer me personally. I have 2 forms. In the first form, through the program, i call a function connection() which is as follows - { Dim strconn As Stringstrconn = "Provider=SQLOLEDB.1;Persist Security

Off-topic

could anyone of u tell me a good mailing lists for Visual Basic/Delphi ?? Thanks and regards,Santosh

Off-Topic - Select in Informix

as another program which gives the same select on the same table returns correct value.. Any ideas are welcome Thanks and regards,Santosh Varma

Off-topic Informix

the same select shows the correct result.. What may be the reason ?? Thanks and regards,Santosh Varma

off-topic -UNIX question

Hello all, I get a process id by calling getProcessId()..I want to know from program whether that processId exists. Any way to find out how ? Thanks and regards, Santosh

Finding out last 10 records

Hello all Could any one of you guide me on how to select last 10 records from a table. and also finding out first 10 records.. Thanks and regards,Santosh

Regarding Indexes

?? Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Difference Between DBMS/RDBMS

could any body point me the difference(s) between DBMS and RDBMS ?? because in DBMS also as in RDBMS, we can related two or more tables..if a column exists in another table for relation ?? Thanks and regards, Santosh

RE: Difference Between DBMS/RDBMS

of list ORACLE-LSubject: R: Difference Between DBMS/RDBMS DBMS =Data Base Management System RDBMS=Relational Data Base Management System But actually i do not know any dbms that's not an rdbms. Bye , Marcello -Messaggio originale-Da: Santosh Varma [mailto:[EMAIL

RE: Difference Between DBMS/RDBMS

only fool's like you can point such differences...when not able to find valid differences. -Original Message- Sent: Tuesday, June 25, 2002 5:54 PM To: Multiple recipients of list ORACLE-L i give up the R, is that the difference? joe Santosh Varma wrote: could any body point me

Data Types

i wanted to know the exact difference between the following data types - NCHAR NVARCHAR2 VARCHAR2 VARCHAR Thanks and regards,Santosh

OCP Related

could any one of you tell me the sites where OCP related materials are available and where i can give free tests for readying for OCP exams ? Thanks and regards,Santosh

Basic Question

Could any body tell me the different between DataFiles and TableSpaces ? Is it that Datafiles are the tables in a Database and Tablespaces are the spaces allocated for each table with Datafiles in that ??? Thanks and regards,Santosh

Basic Question Again..

Could anybody describe and explain me the following - SGA ?? Redo Log Files ..and its use. Control Files in Oracle Database and its use. Thanks and regards,Santosh

Oracle and Delphi

Hi list, I am developing an application wherein Delphi is the Front-end and Oracle the Back-end. I wanted to know what all are needed to get connected to Oracle Database , i.e - settings,configuration etc.. Thanks and regards, Santosh

Oracle and Delphi

Thanks to u all who replied.. Cheers. Thanks and regards,Santosh Varma

Off-Topic

I know this is an Off-topic. But i wanted to know of any Delphi mailing lists available.. Any help will be Always Welcome... Thanks and regards,Santosh

RedHat

I wanted to know what is this RedHat, its significance and its features. Any links/doc's on that ??? Thanks and regards,Santosh

RE: Simple Query

Hi shibu, Try the following query - I hope this helps. SELECT count(*),sum(TC_LINECOUNT) from tablename.a,tablename.b where TC_ACTIONID = (select MAX(ACTIONID) from tablename.b where b.TC_TRANSCRIPTIDin (select DISTINCT TC_TRANSCRIPTID from tablename.a)) santosh -Original

RE: Query

') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET

Regarding report configuration

i wrote some reports in informix(.ace files). but recently we r shifting to oracle database. anybody having idea how to configure .ace files ?? any tool in oracle which we can use without much effort from our side to configure .ace files ? i hope i am clear. if not, please revert back to

RE: An Oracle logic error....

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Unix mailing List

to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: Delete slowing..

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City

RE: VMS equivalent of ls -lrt

Title: VMS equivalent of ls -lrt I wanted to know of any site where VMS documentation is there. can anybody help me out ?? detailed knowledge of VMS !! thanks in advance , santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent:

RE: select from dual?

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: Oracle related docs/OCP materials

I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma