Can anyone tell me why I get the error "Date format picture ends before converting entire input string" when running this select statement
SELECT SUM(OP.SORDQTYSTK_ORIG * OP.DECWIDTH) M2
F...
I HAVE A tablespace rbs which holds 3 rollback segments rb1, rb2, rb3. i been having this ora1562 failed to extend rollback segment rb2 by ... for which i resized the datafile to a much bigg...
Auditing wants a quarterly report of users and their roles for each database. Is there a script or method to export a list of users that have access to a database and list their roles. The m...
I am trying to decode data that is base 64 encoded and store it in a view or another table, so that I may view it in Crystal Reports. The data is stored in Oracle 8.1.7. Is there a function? S...
how can I use quotation marks as part of value in table,
in another work how can I get value a'bc from dual
select 'a'bc' from dual
is not working
I have a select statement and I want to add some months to my SQL statement. I need to Add 6 Months to the Hire_date.
I cannot get a nested function to work here.
SELECT LAST_NAME, HIRE_DA...
Hi,
I am planning on installing Oracle 9i Database on a SunFire V890 server running Solaris 9. I wanted to know what is an optimal disk configuration for the install. I was thinking of m...
Hi,
I have the following tables/data :
SQL> select dept_id, sum(salary) from emp group by dept_id;
DEPT_ID SUM(SALARY)
---------- -----------
1 9750
2 91...
I am having problems writing the physical backup files that RMAN creates to a remote database.
I can use RMAN and connect to target and recovery on the remote machine..initiate the backup ...
I know how to time a pl/sql block.
But, I would like to run a pl/sql block and get the average cpu activity and disk i/o in terms of percentages when running the pl/sql block.
How can I ...
Good day. I am having difficulties in accessing remote Oracle database from a ASP page. I installed Oracle9i Client - Administrator option from the CD in the web server but the problem still r...
I have a query created for a report that allows the user to select what information they wish to sort the end report by. I uderstand that decode automatically type-casts the decode statement ...
Hello,
I want to put logic in my sql statement such that based on the data in one column, I multiply the value in another field by 1 or negative 1. For example, consider this data
Amoun...
Select complete_date from schedules
Where schedule_type = REP
And schedule_id = 50;
My problem here is that the schedule_id may have more than one row returned because it may have mul...
I have an application using java and oracle ... it gives me ORA-01000 - max open cursors excedeed.
I have max open cursos limit set in ora.init
Also in the application i have kept a check ...
Hi,
I have an Excel spreadsheet which contains a column of data I want to load to a table in an Oracle database. I heard that Oraload feature of Oracle could help import data from a .txt f...
I have installed oracle 9i on win2k server. Then created a new tnslistener service, configured listening location with new ip address an configured database services specifying the oracle home...
What are the advantages of using Stored Procedures instead of a product like SQRW.
I know Stored Procedures are compiled while SQRW is an interpretive language, but where do I really save i...
Hello to all the experts, I really need some help with my Oracle 8i installation. Here is my information.
OS: hpux-11.11 U 9000/785
Kernel: 64-bit
File System: Enhanced Journaled File...
Due to security "hole" in our old DB Schema, I have recreated schema using new schema owners but keeping old schema owner as an "end-user". However, application programs written prior had dir...
What is the dos command to stop an ORACLE instance?
how could i pass a hexvalue of a varchar as varchar and decode it using utl_raw or otherwise?
e.g.
create or replace function fnHex2Char( vHexVal in varchar2) as
is
begin
....
end;
As the syntax for the CREATE DATABASE LINK command is
CREATE [SHARED][PUBLIC] DATABASE LINK link_name
[CONNECT TO user IDENTIFIED BY password]
[AUTHENTICATED BY user IDENTIFIE...
hi all
plz tell me how we cab convert clob to blob
have one table with clob colum type now i want to store that data to another table with blob coloum type
Dear All,
I use a financial application which has embended a Oracle DB 8.1.7. Often on Win 2000 platform we receive this alarm in OraDim.log file:
Tue Sep 23 10:26:40 2003
Message 51 no...
