Dear experts,
I want to run a .sql which contains some sql code as shown.
However, when I run sqlplus command in windows command prompt.
The sqlplus can successfully login but hold to wai...
Hi all,
I am trying to decrypt a string in Java Code which was encrypted using DBMS_OBFUSCATION_TOOLKIT in Oracle PL/SQL procedure.
Byte Key used in Java code is of format:
SecretKeyS...
Keep getting an error for some reason and I don't understand why.
Orginal Query:
SELECT TASK_DATE, isactive, B.QID, TECH, SUBMITTEDTIME, QUEUE_COUNT, SHIFT, to_date(Concat('9/25/2008', DUE...
I am loading bar delmited data with sql loader. Some of the files used the date format MM/DD/YYYY and others use YYYY-MM-DD HH24:MI:SS. The control file with MM/DD/YYYY format is listed belo...
Hello,
1. Can someone please post the classic ASP (NOT .net) code to connect to an Oracle 10g database?
2. Other than having the Windows 2003 Server (SP2) and IIS, what other software is r...
experts,
i got one problem while exporting table partition. please find the error message.
Note: RECORDLENGTH=1048576 truncated to 65535
Connected to: Oracle Database 10g Enterprise Edi...
how to update or set a new password expiry_date for a user whose password has expired in oracle
both using oem and through sqlplus.
regards
Hi;
In the Enterprise Manager Console home page, often the alert arises "N objects are invalid in XXX schema".
When i go to that objects, they are materialized views and it says "Need recom...
I've had a stored procedure that used to work with a sample of the below code. However, more recently rows are being returned without any error message? The below logic was use to obtain dat...
Hello,
I have a field which contain variable + value
'variable1:value1 ; variable2:value2 ; variable3:value3'
I want extract the value from variable
select * from t where REGEXP_LIKE...
I am calling FORM from another FORM,which works quite fine in forms6i,but in Oracle Forms10 it seems to have troble in accessing it's getting stuck/loop. iam not using for MENUS at all.
it'...
I need to generate and fetch a oracle report from java webapp. Since all seams to work fine while using rwservlet and webservices I need to decide upon best way to get it done.
I have orac...
hi all i'm a newbie to oracle forms i have a text item on a form i want to get the the text user enterd on a when-butto-pressed trriger how this could be done
Am new to shell scripting i have a script written in pl/sql code which runs fine in toad and pl/sql developer can some help me out how to run it in PUTTY.. can some explain step by step pleas...
Is there a way thourgh code I check to see if the .net framework 2 is installed. I am calling a .net component from vb6.
For each contact i have more than one actionnumber and its string value is pulled from other table(string table). How do i create temp table to have this way
At present my table has
C...
Hi,
I need to do a group by based on the month and the year of dates. To do this I use a TO_CHAR(SomeDate, 'YYYY') and TO_CHAR(SomeDate, 'MM'). This goes fine until I add in my select an inne...
Here is a SQL statement. Is there an easy way to do the following without a union? Thanks.
select 'T' from dual union select 'B' from dual;
Hi there,
How do you get all the current record details for each result of a MAX function.
E.G.
SELECT Arrayid
max(write_pending_count) AS MaxWritePend
F...
I have inherited a database from my predecessor in my role. Discoverer has been implemented in some test databases and production - I have been given access to production disco 4i apps tier u...
I am new in oracle developer forms. I have the following table:
Create table test_data(
Id number(3),
Id_value varchar2(10),
Category varchar2(3));
Insert into test_data(1, mobile,...
i need to import tables from a schema using data pump utility.
can someone help me how to import all the tables in the schema purchase.?
how to find index is local or global?
Hi Experts,
I've been running all my procedures by writing them all to a .SQL file and then running them from SQL PLUS
eg) SQL>@MY_PROCS.SQL
now as the application is moved live, the "cre...
I am doing a full export of my database. I go to import the DMP file and the process runs for a few minutes. The end of the log files says "Import terminated successfully without warnings." ...
