How can I sort tables alphabetically in schema browser left panel (I have Oracle 10g) ?
Few questions...
1)Can you please elaborate on the SELECT....START WITH....
CONNECT BY.. CLAUSE. which we use in creating Record Group
for populating Tree.
2)Moreover my EMP table has ...
Currently I have a UNIX script that creates a SQL script
on the fly that unloads table data to a delimited ASCII
file via the sqlplus "spool" command. It works
flawlessly; however, we nee...
Hi,
I am calling an Oracle stored procedure from an ASP.Net application.
The Oracle Stored Procedure is:
----------------------------------------------------------------------
CREATE...
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 have installed TOAD to my pc and have all connection environment setup to the oracle db.
At point of login to the database, this is the error that I get:
OCI.DLL - The specified module cou...
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...
The Input format will be in week number and we need to find the first day of the week in Oracle's default date format.
I tried to use, to_date('2002-49','YYYY-IW'), it did not worked. I g...
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...
I currently have Quest Toad for Oracle 9.0.1.8 installed on my PC. I have the "Save Passwords" open enabled which saves the schema/password and database name for all connections I make. Ther...
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 ...
I do need to send an email directly fom Oracle Forms, just by pressing a but.
I already saw examples at Oracle Tech Net, but all of them use a package called UTML_STMP. I'm working on Oracle ...
Hi
Hopefully this is the correct area for this question- was not sure if it should come under UNIX or Oracle.
Been struggling all morning with this and wondered if anyone could help. Ba...
As I know, Oracle DB created with WE8ISO8859P1 character set cannot be converted directly to UTF8
Is there any possible way to convert (or migrate) data from WE8ISO8859P1 to UTF8 with minimal...
I get this error (in subject title) even though the file is right there in the directory. It's driving me nuts since I can't open up the library to modify some of the procedures that exist.
...
i am using oracle forms, and i want to create a table and then drop it inside the pl/sql code in a 'when-button-pressed' trigger. but when i am writing the syntax, it gives a compilation error...
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...
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 ...
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 need to export my toad software to a new laptop. I have many database connections and passwords saved on my old laptop (many of them which i do not remember now) which i want to export ...
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...
Hello, I'm using Oracle 7.34 for this. I want to just inform the user when a certain kind of UPDATE occured in Oracle. They will be making the changes in Access forms so I figured by callin...
Dear experts,
I have a csv file that I am picking up from the server using a "sequential file" stage and am having some trouble with the table definition.
My data is stored using the dat...
(p_username IN dba_role_privs.grantee%TYPE,
p_role OUT dba_role_privs.granted_role%TYPE) IS
v_username dba_role_privs.grantee%TYPE;
v_role dba_role_privs.granted_role%TYPE;
BEGIN
SELECT...
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...
