Can someone please try the SQLs below in 9i?
I tried in 8i, different 10g boxes and 11g...
The blank-padded comparison semantics works with outer joins in 8i, but it doesn't work in 10g ...
In ORACLE Discoverer I have the following three columns that I am retrieving from queries in my business area
PLAN |CELL |CAUSE CODE
===========================
THERE |CABLE |DEFECTIVE
T...
Hi,
I use round function in my query.But i want to take 2 decimal places like this number 100.1 ...
I have an Oracle query that retuns too many rows of information. It is pulling from two tables:
WIP_NOFICHIERS and WIP_ORDER
Here is my SQL:
'I've edited out some parts
SELECT wo.NUMB...
I am getting this error while inserting into a table. I am getting for few records only.
i need to calculate summation with group by but i dont care
if it group by x,y or group by y,x
Hi everyone,
I use oracle 10G, and when I created a report in HTML format from Oracle Enterprise Manager of the 10G client, all my accented characters (french characters) appear as Chinese...
The following code only creates months through 10/31/08, any clue why it tops and how to fix it?
About a week ago we turned archivelog mode on in an 11g oracle server. The flash_recovery_area is now full, and redo logs can't be archived, so the database won't open.
I need to delete so...
Hello
I have an Oracle procedure calling a procedure inside a package. The procedure inside the package performs an update of two tables across a dblink based on variables passed into the ...
Hi there,
I have a TOP N query that returns a result set as follows:
GroupID DeviceID Difference TopN
1 B 34 1
1...
Can some one give me step by step link to perform oracle export/import or explain it.?
regds
Hi,
I have to upgarde a DB on windows from 10203 to 10204,do i have to install teh base release and apply the 10204 patchset and upgrade DB or is there a patch for it,can anybody please ...
I have a similar problem. I have lot of form files that we need to compile all the time. Especially when we put alerts or any debug statements, a compile all takes a lot of time. And this may ...
dear experts ,
If the oracle Alert log file has lost is there any ways we can regenerate till specific date of DB state ?
how to know how many rows are there in a paricular block?
Hello All,
The current where clause I have in my query is
Where (TO_DATE(TS.DDLN_DT) -3 ) = TRUNC(SYSDATE);
This will pull members 3 days prior to the current date. I want to change it ...
I already have emp and etc tables created in db.
I just need to run "lab1.sql" file and commands already in file.
================================================================
select emp...
Attach the table and insert record scripts. I need a simple sql to update the exp_date column and here is the rule. When the same emp_no change to a differet state, then update exp_date with...
Hi experts.
we are using Oracle 10g database. using DATA PUMP i exported data.
I have exported dump file & target data base in place. I just need to import only data to target data base,...
Am developing a form, there is a block i have with a tabular view it contain list of checkboxes. Checkboxes are database items and set to a certain field when it is checked and record saved th...
Hi
How to alter a user in remote database? I don't think we can use db link i alter statement. Is there a alternative.
Thanks
i have created a role as sys (role_a). I have a user (user_a) who has been granted the role
grant role_a to user_a;
When i log in as user_a and revoke the role from user_a it is OK. I am...
I have the Oracle 10.0.2 client software on my laptop (running XP SP3) and need to use the native Oracle ODBC client for use on a project (ie not "Microsoft ODBC for Oracle"). I have installed...
Can using the DBMS_LOB corrupt the Database?
My question is " Is this package able to open datafiles /access Unix files and corrupt the database"???
My concern is some of the developmen...
