I am just getting started with PL/SQL Developer, and I have just loaded Oracle Personal 9i.
I have a lot of past experience with Oracle but not sure how to get the engine running.
I'm mo...
I have some *.dbf files and i want import it into oracle database.
How to do it?
i have the following update:
UPDATE test2
SET test2.id= (select max(test1.id) from test1 where test1.bez = test2.bez);
now the select '(select max(test1.id) from test1 where test1.be...
I have a button that has a trigger WHEN-BUTTON-PRESSED which calls the Show_LOV function in Forms that will then return a TRUE or FALSE boolean value. If true will display the LOV based on my...
I get this when trying to use the Microsoft OLE DB Provider for Oracle.
I get this message:
"Oracle client and networking components were not found. These components are supplied by Oracle...
Hi All,
I have question on Update statement.
I am trying to update a table DI_vendor_staging using DB link like below.
UPDATE DI_vendor_staging@dwp_ram di
set di.DI2_term...
HI,
I am working on Oracle 8.1.7.
My Table structure is as under:
create table test_tbl
(item_code VARCHAR2(30)
,item_description VARCHAR2(80)
);
My .ctl file is:
LOAD D...
How can I sort tables alphabetically in schema browser left panel (I have Oracle 10g) ?
Hi,
I'm really hoping someone can help me with this. I have a pl/sql program that has literally hundreds of statements within a block. I have a 'WHEN OTHERS' exception handler. Within this...
hello expert,
My office oracle database has several dba_roles setup how
can i view the contents of the roles --- what these role comprise of
thanks
Hi,
I have two parameters in reports: "date" and "worker number".
At runtime, when i select date on parameter form i need
that the parameter's "worker number" list would be dynamic accord...
I my form, everytime i try to do an insert record, i get the FRM-040508 error.
The sql for the WHEN-BUTTON-PRESSED triger is as follows simple:
create_record;
IF NOT Form_Success THEN...
Hi Experts,
My company is involved in troubleshooting a large oracle database which up until now we've had no design info on the actual database.
I've just gotten some files from the dev...
Hello,
I'm working with an old product, Oracle forms developer... and users every day comlaining that they works very slow. Also, program crack down with massages dump... ect.
What could be ...
How do I view an Oracle Profile? I want to check the password grace time on a user generated profile.
In a web application using ASP and Oracle, after moving to a new Win 2003 server and re-installing the software, we had the application working fine, and then the next day we started getting ...
If I set TNS_ADMIN environment for windows START (right click computer) -> properties => advanced => environment variable ....
and then open a cmd session , and type "sqlplus ....", it looks...
Hi all,
I should need a character function which, given a string and a
specific token, gives me back all the substrings.
Then I should load all these substring into a poplist (Forms 6i elem...
Dear Experts,
set feedback off
set heading off
set pagesize 0
spool abc
select * from customer;
spool off
abc.lst
---------------
SQL> select * from customer;
KC ...
HI all,
if my file is with extension csv file lets say aaa.csv
in the control file
i write this line
FIELDS TERMINATED BY ' '
my file is csv so what do i write after TERMINATED BY
is it...
I ran the following control file in sql loader:
LOAD DATA
INFILE 'c:\ntiac1\NTMeta.txt'
INTO TABLE ntiac_table
FIELDS TERMINATED BY '\'
(accens_num varchar2(400), unclass_title varcha...
Dear Experts,
set feedback off
set heading off
set pagesize 0
spool abc
select * from customer;
spool off
abc.lst
---------------
SQL> select * from customer;
KC ...
I get the following error 'Multiple-step operation generated errors. Check each status value.' when trying to read a date field from a recordset. The data has been selected from an Oracle dat...
Hello, could someone help me and tell if there is a possibility to set records (also can be blocks), but in fact all records displayed in oracle form doesn't matter how many related data block...
I'm using oracle 8i, and I'd like to know how to create, edit ,drop a public synonym and where do you do all that, i.e in the schema itself or do you have to be outside the schema which you wa...
