I have a loop to cycle through some dates by converting the dates to number. But the day hits an invalid day ie:32 while iterating through the loop. How can I stop this from happening?
I want a region to be conditionally displayed, in an ApEx application. But something didn't work.
The way I tried to make it is shown in the picture I attached. I want a region will be dis...
I need help with fixing the column headings. This is what I get.
DEPT_NAM (SELECTSUM(E.SAL)"DEPT_TOTAL_SAL"FROMEMPEWHEREE.DEPTNO=D.DEPTNO) (SELECTSUM(D.SAL)"COMPANY_TOTAL_SAL"FROMEMPD...
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archi...
Hi,
I have DB auditing enabled. (audit_trail=db) I have set this using ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE
So, I've run the attached code to enable select auditing on the hr.empl...
I have to create a Report related to Payables & Inventory in Oracle EBS 11i. Can somebody help in finding out following:
1. Name of Delivery table
2. Link between Purchase Invoice, Purchas...
Hello Experts,
I suppose to install SQLNet on all hosts communicating with Oracle 11g.
where do I download this?
what is it?
how to install it?
This is the first I hear about this...
Hi,
I need to update a field in one table (bug.bg_user_41) with a timestamp (au_time) from history tables (have to join audit_log to audit_properties to get only records that meet the cond...
Hi EE,
In a related EE post, I received guidance on how to set up an INNER JOIN - joining the same table to itself.
At the time, my situation was:
I'd like to query transfer students ...
Hi EE,
This is related to dvz's comment of a previous post:
I understand the steps to go to options for schema browser.
please look at screen shot 1 - in freeware the browser style radi...
I have company and credit columns in my table. If I found duplicate values for the credit column which has same company name then I have to make one credit column to null.
my table:
compan...
We've got a smallish 2-member oracle rac with archivelog enabled. We need to purge some of the old archive logs in the ASM disk/RMAN. They're up to 800gb now and date back to 4-22. help!
hi,
i want to copy databases between 2 different servers. on of these servers are located in sacramento another in new york.
we are using sql server 2000 in windows advanced server.
...
I created the database while installing oracle. Now I want to create another database.
Are the steps below correct?
1. Create the init_DL01DB.ora file for the new database DL01DB and put it...
Hi,
This is my situation:
I exported mydb.dmp from Oracle 9.2.0.1.0 version and also from Oracle 10.2.0.3.0 version
Oracle server is 9.0.1.3.0
Oracle client is 10.2.0.3.0
When I try to ...
hey guys i have oracle 10g database on solaris and would like to migrate on linux, so can i have all steps to be done to migrate. Thanks alot in advance
Experts,
I was trying to fix a connection problem with Oracle 11g by entering Alter system set processes =300 scope=spfile;
and rebooted. Now I cannot log into lsnrctl, sqlplus. I...
I need to do a backup on an Orcale 8.3 database
In cmd prompt I remember how to connect...with
set ORACLE_SID=ptmn
However...it's been a few years since I left this compoany and can'...
Hello,
I am trying to update a unique entry on the "remark" column on a table called item_revision_history.
Initially if I do the following
> desc item_revision_history
Name ...
Dear experts,
I want to import a set of CSV files to an Oracle table using external tables. However, CSV files are so large that they may contain approximately 800 fields and thousands of c...
I need to write a db trigger that will update a field in T2 based on the record being updated in T1.
T1 and T2 are relational where T1.id = T2.id and they are in a one-to-one relationship. ...
Can i have all Recovery Senories with Rman,Online Hotbackup and cold backup
if there are duplicates in a list of 10 records in a flat file . How to get the list of duplicates after bulk copying into a scrach table ?
Running a status on listener returns:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bb0.ccce.edu)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias ...
I am getting ora-12547
can some help quick
can connet to
$sqlplus /nolog
SQL> connect / as sysdba
ora-12547 :TNS:lost contact
I am doing patch and it is during the post installat...
