oracleclub : Messages : 903-932 of 1112

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

903	Hello All, 1> I want to know which algorithm CONNECT BY PRIOR use? I mean how it works? 2> And how cursors work? Means how the select ename from emp;...	prachi korde prachikorde	Oct 13, 2008 8:16 am
904	Hello All, I need some help. I have one query using Self Join, as SELECT a.pno, a.pname, a.psal FROM ptemp4 a, (SELECT pno, psal FROM ptemp4 WHERE pno = 1)b ...	prachi korde prachikorde	Oct 15, 2008 7:59 am
905	Check the all example regarding "connect by prior" http://www.psoug.org/reference/connectby.html it is basically use for identify "child and parent" rows...	Mohammed Taj Oracle DBA star_taj	Oct 16, 2008 6:12 am
906	Thnx for the reply. Wht abt this? 2> And how cursors work? Means how the select ename from emp; query will work? The self join answer is not what i was...	prachi korde prachikorde	Oct 16, 2008 8:07 am
907	I know that you got the solution...i already saw your thread in ORAFAQ. the same thing i am going to sent you. � About the cursor you confiused. � A cursor...	Mohammed Taj Oracle DBA star_taj	Oct 16, 2008 8:36 am
908	How to clone database on the same host with different name In this post I will show how we can clone database on windows system without using RMAN duplicate....	m arju a_arju	Oct 16, 2008 4:32 pm
909	List of Patchset number in metalink You want to download patchset from metalink but you don't know the patchset number. In that case it may take some moments...	m arju a_arju	Oct 16, 2008 4:32 pm
910	Hi Friends, We are very happy to inform you that we are launching training program on PMP (Project Management Professional)....... To get more details on...	Positive Fanatic positivefanatic	Oct 16, 2008 4:32 pm
911	How to take RMAN backup on a remote disk It is common to hear that for backup there is not sufficient space on my server or my server disk is about to full....	m arju a_arju	Oct 16, 2008 4:32 pm
912	Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process. The...	m arju a_arju	Oct 16, 2008 4:32 pm
913	How to know whether I use analyze or DBMS_STATS Automatic statistics gathering should be sufficient for most of the cases. And automatic statistics gathering...	m arju a_arju	Oct 16, 2008 4:32 pm
914	RMAN-00554,RMAN-04005,ORA-0103 when remote connection by rman Whenever I try to connect remotely to a database through rman it fails with message RMAN-00554,...	m arju a_arju	Oct 16, 2008 4:32 pm
915	hi Prachi, To Avoid Mutating in Trigger,we have to use PRAGMA AUTONOMOUS_TRANSACTION like below CREATE TRIGGER t1 AFTER UPDATE ON emp DECLARE PRAGMA...	mani_ocm	Oct 18, 2008 11:19 am
916	Dear Friends, Oracle Released CPU patch 2008 for the various product. it is actually security bug fix patch which need to apply and storngly recommended by...	Mohammad Taj star_taj	Oct 19, 2008 4:48 pm
917	Hello All, Do someone has any solution for below: 11> If I have more than one tables, & has columns in all the tables whose some of the values are...	prachi korde prachikorde	Oct 20, 2008 6:48 am
918	thanks a lot taj.. babu Mohammad Taj <star_taj@...> wrote: Dear Friends, Oracle Released CPU patch 2008 for the various...	Babu B ind_babu05	Oct 20, 2008 9:02 am
919	hai, i installed oracle database Release 10.2.0.1.0 - Beta and oracle client Release 8.1.5.0.0 my problem is following... SQL*Plus: Release 10.2.0.1.0 - Beta...	Martin Andrews andrewstster	Oct 21, 2008 5:06 am
920	ORA-03113 is a generic error. you need to check "alertsid.log" file for more details. or sent us last few lines of alertlog file when the error is raised. ... ...	Mohammad Taj star_taj	Oct 21, 2008 5:09 am
921	If i am not getting you wrong. you can use "sequencename.nextval" in the insert statement. suppose i have two table called "chi","pra" in that table i have two...	Mohammad Taj star_taj	Oct 21, 2008 5:14 am
922	Thanks for reply Taj. I know i can do this. But in the below case, what I want is, I have some values already generated fot those table columns. And now...	prachi korde prachikorde	Oct 21, 2008 7:03 am
923	You can do the following things. 1. first check the highest value of the column through max function. select max(columname) from tablename; then create...	Mohammad Taj star_taj	Oct 21, 2008 7:07 am
924	SIR, HOW CAN I 'alertsid.log' SIR.. THANK YOU MARTIN ANDREWS T ________________________________ From: Mohammad Taj <star_taj@...> To:...	Martin Andrews andrewstster	Oct 21, 2008 7:07 am
925	go to the %ORACLE_BASE%/admin then check alertsid.log file. ... raised. ... <andrewstster@ ...> ... one roof. Go to http://in.promos.yahoo.com/groups/...	Mohammad Taj star_taj	Oct 21, 2008 7:08 am
926	SIR, I CHECK TAHT FILE. BUT WHAT I DO TO SOLVE THIS PROBLEM. ________________________________ From: Mohammad Taj <star_taj@...> To:...	Martin Andrews andrewstster	Oct 21, 2008 7:13 am
927	CHECK TAHT FILE. BUT WHAT I DO TO SOLVE THIS PROBLEM. what i said ealier follow that. ... raised. ... <andrewstster@ ...> ... ...	Mohammad Taj star_taj	Oct 21, 2008 7:15 am
928	Hello, AS per Taj.. Post your alertlog last 100 lines.. Babu Mohammad Taj <star_taj@...> wrote: CHECK TAHT FILE. BUT WHAT I DO TO SOLVE THIS PROBLEM. ...	Babu B ind_babu05	Oct 21, 2008 2:17 pm
929	Hello, I agree taj but prod. env. this is not helpful. For Example: In 2008; you can create sequence like; OCA081001 (1001 - Sequence first value, increment by...	Babu B ind_babu05	Oct 21, 2008 2:23 pm
930	Hi friends, Can you share the doc. ( how to install the OEM Oracle Enterpriser Manager 10g in Unix Solaris, if any body having. pls send to my mail.... thanks...	Ganesh kumar raghava_ganesh	Oct 21, 2008 4:43 pm
931	Hi Ganesh, Pls! find the attached doc.. Regards Shekhar ... From: Ganesh kumar <raghava_ganesh@...> Subject: [oracleclub] Hi.... how to Install...	Shekhar BE be_shekhar	Oct 22, 2008 2:18 pm
932	Hi Friends, Today accidently i ran catalog.sql script in the existing database and i faced some typical errors such as unable to access dba_registry etc. Again...	guna dev guna_dev	Oct 23, 2008 11:23 am

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages