Dear Friends , In what way can I have date for example for the last 3 hours ? Thank you Denisa RADO Position: SERVICES DATA BASE ADMINISTRATOR Dept.:...
Dear taj how can i format the system date in order to receive the data for the last 3 hours Select * from contract where activation > sysdate - (3 * 3600 ) ...
Use TO_CHAR & TO_DATE function. Babu "Rado, Denisa, VF-AL" <Denisa.rado@...> wrote: Dear taj how can i format the system date in order to receive the...
Can you please help me more ? ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf Of Babu B Sent:...
Sorry babu i don't understand the use of 3/24 ? ________________________________ From: oracleclub@yahoogroups.com [mailto:oracleclub@yahoogroups.com] On Behalf...
The system date is like this in what way can i format it to receive data for the last 3 hours Denisa RADO Position: SERVICES DATA BASE ADMINISTRATOR Dept.:...
Hello Taj & Arju, Please expalin me this interval 1/144. Recently i saw this interval in replication area. I can't able to understand this one from oracle...
Hi, Thanks for your support. Please teach me; How you saying it's TEN Mintues. Babu Meda Sorostinean <meda_mona@...> wrote: Hi Babu, SYSDATE + (1/144)...
 interval => 'SYSDATE + 1/144',  SYSDATE=24 hours  Trunc(24 hoours + 1 hours/144=10.41,2)  this is the equation  S. M. Monzur Hassan ... From: Babu B...
Here you can see, Babu, fractions of 24h, together with their meanings: sysdate fraction Meaning 1/6 Every four hours 1/12 Every two hours 1/24 Each hour 1/48...
Hello Meda, Can you send me link? (Where you taken below screen shot) Meda Sorostinean <meda_mona@...> wrote: Here you can see, Babu, fractions of 24h,...
How to restore an Spfile from autobackup older than 7 days Whenever we issue in RMAN, RMAN> restore spfile from autobackup; then restoring from autobackup...
Recover database after missing online redo logs and all controlfiles. This example is based on, You have lost all your current and backup of controlfiles. You...
 http://appsdbataj. blogspot. com this blog was not opening and not working pls give me information http://appsdbataj. blogspot. com this blog was not...
try this Babu narmada Kumari <narmada1956@...> wrote: http://appsdbataj. blogspot. com this blog was not opening and not working pls give me information ...
What will happen if oracle unable to write Alertlog, Core Dump Or Tracefiles In this I will show what can happen if Oracle is unable to write to the ...
Hi Friends, I was trying to clone my production database on test server.As mentioned in Taj's blog,I followed all the steps..copied all files pfile,created a...
Hello Friends, I cloned the production database on my test server.I created the pfile/control file the problem is ...I installed the patch on my second ...
Really?Be clear in explaining ur problems.whenever there is a problem we cannot give u solution without knowing the oracle version?? 1)u cloned the production...
In DBUA you trying to change ORACLE_HOME manually. if not then try means you have to change manually ORACLE_HOME location in DBUA and click on next to proceed...
How to avoid of recreating pfile or spfile if any error in spfile Let us some talk about pfile and spfile. Suppose I have done some wrong-edit inside spfile...
sorry i saw ur email today How did u apply the patch (steps in details and which oracle document are u following) u cannot use DBUA to upgrade the version from...
May be i didnt understand ur problem properly... 1)ur saying that patchset installation is fully compleated?u ran catupgrade.sql etc etc Give me the out put of...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
