I want to record just the date part of sysdate in a date field without time, how can I do it? I have a web site and when a users clicks a link, it records username and system default date. How...
Installed Oracle 11g on RHEL 5.3. Logged on as oracle (member of dba group).
When try to connect to SQLPLUS
[oracle@mytestbox ~] $ sqlplus "/as sysdba"
receive the following and ca...
I used this setting, but could not get what I wanted.
--------
set pagesize 0 termout off feedback off trimspool on
spool c:\temp.sql
select file_name from dba_temp_files;
spool off
ty...
Hi there,
I am a beginner with Oracle so here is my current setup:
1. Windows 2008 64Bit Server
2. Installed Oracle 11g Enterprise Software Only 64-bit - Successful install as defined by in...
I have a JasperServer's scheduled hourly
"RO103" report that automatically emails
me every hour ONLY if it has results.
I got the below at 7pm, 8pm, and 9pm last night.
I then manuall...
Starting up EM console in iig client.?
just like the one in earlier versions.
How to use imp dp to import data to a schema cust?
can you give me syntax to import a data using impdp and also to map data to cust schema.
I need to bring data to cust schema from an dp file..
Hi EE,
The SQL below IS giving me the results that i am looking for.
I am coming from a Microsoft Access background, an am used to using a gui...
so i need some ORACLE sql help, pls:
...
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for IBM/AIX RISC System/6000: ...
Hi, I'm using Oracle Apex, and I wonder how to use button request values and how many button request value exists. Thanks in advance.
I'm spooling records into a text file and I have a datatype of clob(4000). I want to list out one record per line in the text file. So I'm concatenating all my columns. I'm also converting the...
Hello,
I need some help rewriting a trigger, the data structure change for one of our tables and now my trigger is invalid. I know that would can't have a trigger on multiple tables but I w...
I have windows XP , I have taken Online Hot Backup of Oracle 10g now i want to restore this and recover on another machime that is also windows XP, so what all steps do i need to restore and r...
I have tried this several times and still get the same results. I have a 9.2.0.8 database that is used for Oracle E-Business Suite. The Application is running at 11.5.10.2 CU2. I am just up...
Hello, I need to export an Oracle 10 database dump and need to be sure that the data is 100% consistent and therefore it would be nice to make sure that there are no connections nor internal j...
I want to search a number from a number array in pl/sql. Is there a smart way? Thanks in advance.
I've a session as schema_owner_A and start a long-running query against Table A.
In the meantime, I start a second session as schema_owner_A and truncate Table A.
After 30 mins the query...
Hi Experts
i need a script that makes rebuild indexes on database.
does anyone has such one?
10x
I used this script to backup.
connect target /
shutdown immediate;
startup mount;
run {
backup
format '/u05/%d_%s_%p'
filesperset 4
maxsetsize 30G
(database include current controlfil...
how to convert rows into column in oracle
How can I change the below #3 to
display both values, for ALL items,
not just one item at a time ?
----------------------------------------------------
--#1: below gets CANADA "Allerge...
I have a NUMBER(8) column that
has only three digit numbers in it.
How can I do something like the below
to make the MAST_ID column smaller without
having to do alot of manually work ...
Hi Experts,
How to fix the below error, please help asap and this very urgent.
SQL*Loader: Release 8.1.7.0.0 - Production on Mon Oct 5 08:50:32 2009
(c) Copyright 2000 Oracle Corporatio...
At the launch of Oracle 8i I received two black polo-shirts of high quality (the model with only a small matchbox sized logo) - actually, when weather permits, I still wear them, not to be ner...
hi,
I am preparing for an oracle interview. can anybody give me questions & answers for oracle DBA interview ?
