Search results for query: *

Can someone help in alleviating this problem?

Hello. I have about 12 different sql queries currently in one sql file. Currently I have to manually run these scripts (using Navigator) one by one. If anything is retrieved then I save the reults as a .csv file. If nothing is retireved then I move onto the next script. Question is how...

I am currently trying to spool off the results of multiple sql statements(select empid from emp where deptno = 20 select ename from emp where deptno = 25, etc) contained within a file. Running this for the moment via command line in sqlplus. Not all my statements will return results and a 'nice...

Hello, I am fairly new to perl. I have initiated following the book - "Perl in easy steps". Have installed the Apache http server 2.0.50 and also v5.8.4 built for MSWin32-x86-multi-thread. My OS is Windows XP Prof. version 5.1 SP2. When my installation completes I do get the apache web...

MY query select DISTINCT p.prd_code, p.prd_name, s.brk_date, s.len_code from product p, spot s where p.prd_code = s.prd_code and s.len_code in (10,30) results PRD_CODE PRD_NAME BRK_DATE LEN_CODE AA01 AA MEMBERSHIP 23/07/2000 10 AA01 AA MEMBERSHIP 24/07/2000...

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve service name I am using DOS to connect into SQL Loader using command line ...... >sqlldr uname/psswd control=file.ctl even tried ... >sqlldr uname/psswd@instance control=file.ctl but get the above...

Hello, I am running this on win 2000 as a part of the Oracle 9.02 Developer suite. Is there some step in the configuration/installation or somwthing I have missed out???? Any help much appreciated

Hello, What do I want : Out of all the products in this system need to search for at least one which is featured in more then 10 commercials (i.e. product master block and commercial detail) I have an idea of the sql statement but not quite right - need a having count(*), group by??? I am...

Hello, I have had a local database created on me machine using Personal Oracle Edition for my own benefit and practising etc. My question is whether there is a method of being able to look at objects (tables, columns etc) which reside on a nother datasbe on the netwrk?? In DBA studio or...

Hello. Is there a feature within Des 6 / 9 where by you can capture - in form of a ERD and DDL script - a database schema as shown in the 'Host String' field of a connection window? rgds,,

Hello, I have got a varchar string 07363403LO980011035206687030MCE/LOCE465/030 which I have passed into my function. I want it to be 'worked on' on that the function eventually returns the string as -...

Hello, I am a novice in Oracle sql and would appreciate some assistance with a query. I currently have a script SELECT SUM(ad_len)/60, FROM ad a where prog_code = 'SM' and brk_date > '30-Apr-04' and brk_date < '01-Jun-04' and brk_time BETWEEN &1 and &2 Rather then having to...

Hello, I am looking to seek help on sql performance issue regarding joining of 6 tables. I have a commercial with rowcount of 44.5K campaign 78K product 14K product_commercial 49K and two region tables which have only 3 rows in each. One of the where conditions is to bring back rows for a...

Hello, I am currently trying to turn around some existing code within Forms 5.0 using Forms 6i on a Ora817 db. I am trying to improve performance and also make the code more readable, minimal and efficient. I currently have the following code as below. Purpose of procedure: To enable or...

Hello. I am trying to learn form and have forms 6i Version 6.0.8.11.3. I can retrieve all the .tif rows from s_image table from sqlplus. Within the form I have block level When-new-record-instance triggers on S_ord and s_item which call a program unit which contains the following code -...

Hello, I have installed (from a customised cd) Personal Oracle9i Release 9.2.0.1.0 and also Forms Version 6.0.8.11.3 - in separate homes. I now wish to Install designer from Oracle free download site. I know in past I had problems with installation so much so that I ended deleting the whole...

I installed oracle 9.2.0.1 Personal datbase version then installed oracle forms 6i version 6.0.8.11.3. Ineed to be able to start up forms and then be able to connect to the instance created in oracle 9i. I cannot recall how to do this. I just want forms to be able to connect to this 9i...

Hello. I have just installed Oracle personal edition 8.1.7. What I wish to know is that what sort of values should I 'ideally' have set up for the parameters and which ones need concern me. Since I have installed oracle my machine processing times for applications have slowed tremendously...

Hi, I have a procedure(s) which take in the follwoing parameters p_ret_cd IN OUT NUMBER, p_ret_msg IN OUT VARCHAR2 Then in the Begin section these are initialised p_ret_cd := 0; p_ret_msg := 'OK'; Then this procedure is called within...

I am getting the following error in sqlplus when running a package containing - PLS-00103: Encountered the symbol &quot;SELECT&quot; when expecting one of the following: ( ) - + mod not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> table avg count...