OraFAQ Forum: Server Administration

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

		insert into....bla bla...select @@indentity as 'ID' ? By: ceppya on Tue, 23 January 2001 02:59
		Re: insert into....bla bla...select @@indentity as 'ID' ? By: Gabriel on Thu, 01 February 2001 16:19

		Date Validation By: Pat McCormack on Mon, 20 November 2000 09:10
		Re: Date Validation By: Babu Paul on Mon, 20 November 2000 09:30
		Re: Date Validation By: Pat McCormack on Mon, 20 November 2000 09:43
		Re: Date Validation By: KAW on Thu, 01 February 2001 15:52

		Table Access script By: Regina on Wed, 31 January 2001 14:32
		Re: Table Access script By: Andrew again... on Wed, 31 January 2001 19:38
		Re: Table Access script - dependancies... By: Andrew again... on Wed, 31 January 2001 19:47
		Re: Table Access script - dependancies... By: Regina on Thu, 01 February 2001 10:13

		partitioning tables By: Chris on Wed, 24 January 2001 13:56
		Re: partitioning tables By: Andrew again... on Wed, 31 January 2001 20:37

		Using aliases to improve performance? By: Gerald on Wed, 31 January 2001 15:48
		Re: Using aliases to improve performance? By: Andrew again... on Wed, 31 January 2001 19:55

CREATE TYPE

By: Hans Dzaack on Wed, 31 January 2001 08:32

		public database link error By: user on Thu, 11 January 2001 17:05
		Re: public database link error By: Bala on Fri, 12 January 2001 10:50
		Re: public database link error By: Stelios Karkazis on Wed, 31 January 2001 06:30

		Maximum number of tables in Oracle queries By: Pasc Ora on Tue, 30 January 2001 08:21
		Re: Maximum number of tables in Oracle queries By: Balazs VISSY on Wed, 31 January 2001 05:55

By: saran on Wed, 31 January 2001 01:01

By: Ken Mascola on Tue, 30 January 2001 22:25

		Text entry into VARCHAR2 column results in junk data By: Charleton on Wed, 24 January 2001 08:49
		Re: Text entry into VARCHAR2 column results in junk data By: Sudhir M. Pongurlekar on Mon, 29 January 2001 14:35

		SQL HELP PLEEZ! By: niki on Wed, 24 January 2001 12:06
		Re: SQL HELP PLEEZ! By: me on Thu, 25 January 2001 14:04
		Re: SQL HELP PLEEZ! By: Sudhir M. Pongurlekar on Mon, 29 January 2001 14:32

		oracle8i By: alon on Tue, 23 January 2001 10:52
		Re: oracle8i By: Vinod on Tue, 23 January 2001 12:37
		Re: oracle8i By: me on Tue, 23 January 2001 14:14
		Re: oracle8i By: K.SREENIVASAN on Mon, 29 January 2001 07:05

		creating a procedure By: gary on Wed, 24 January 2001 15:43
		Re: creating a procedure By: Suresh Vemulapalli on Wed, 24 January 2001 17:46
		Re: creating a procedure By: Robert Moy on Thu, 25 January 2001 00:04
		Re: creating a procedure By: Robert Moy on Thu, 25 January 2001 20:22

By: ezmoods@hotmail.com on Wed, 24 January 2001 19:09

		one product , different name and display name By: Mike on Wed, 24 January 2001 15:42
		Re: one product , different name and display name By: Suresh Vemulapalli on Wed, 24 January 2001 17:50

		Question about parsing. By: BoOsTaH on Wed, 24 January 2001 10:41
		Re: Question about parsing. By: Andrew again... on Wed, 24 January 2001 15:01

By: Syed Afroz Alam on Wed, 24 January 2001 14:13

		Ref cursor problem while calling from VB By: Sichu on Tue, 23 January 2001 06:18
		Re: Ref cursor problem while calling from VB By: Bala on Tue, 23 January 2001 13:17
		Re: Ref cursor problem while calling from VB By: Sichu on Wed, 24 January 2001 05:18

		updating multiple fields By: IT Lover on Tue, 23 January 2001 18:22
		Re: updating multiple fields By: Suhen on Tue, 23 January 2001 23:51

		Datatype By: Raj on Mon, 22 January 2001 23:44
		Re: Datatype By: John R on Tue, 23 January 2001 06:09
		Re: Datatype By: Sajit Nair on Tue, 23 January 2001 21:19

		sql help By: Ravi Kiran on Mon, 22 January 2001 07:35
		Re: sql help By: Balazs VISSY on Mon, 22 January 2001 08:43
		Re: sql help By: Andrew again... on Mon, 22 January 2001 12:25
		Re: sql help By: Balazs VISSY on Tue, 23 January 2001 06:32
		You can use order by in subquery By: Bala on Mon, 22 January 2001 13:23

		how to insert lots of data into a table! By: Beginer on Tue, 23 January 2001 00:50
		Re: how to insert lots of data into a table! By: John R on Tue, 23 January 2001 06:02

		date problem By: jeya on Mon, 22 January 2001 20:55
		Re: date problem By: Mahesh on Mon, 22 January 2001 21:55

		Tough SQL*Plus question By: Jim K. on Fri, 19 January 2001 12:56
		Re: Tough SQL*Plus question By: Bala on Fri, 19 January 2001 14:03
		Re: Tough SQL*Plus question By: me on Mon, 22 January 2001 07:58
		Re: Tough SQL*Plus question By: Jim K. on Mon, 22 January 2001 08:11
		Re: Tough SQL*Plus question By: John R on Mon, 22 January 2001 08:50
		Re: Tough SQL*Plus question By: Jim K. on Mon, 22 January 2001 08:52
		Re: Tough SQL*Plus question By: me on Mon, 22 January 2001 11:58
		Re: Tough SQL*Plus question By: Jim K. on Mon, 22 January 2001 12:51

		Appending a spool file By: jimmy on Mon, 22 January 2001 03:23
		Re: Appending a spool file - no By: Andrew again... on Mon, 22 January 2001 12:05

		Deleting duplicate rows By: Thavamani on Tue, 22 August 2000 03:53
		Re: Deleting duplicate rows By: Subrahmanyam Thodla on Tue, 22 August 2000 10:25
		Re: Deleting duplicate rows By: geetha on Fri, 25 August 2000 07:08
		Re: Deleting duplicate rows By: geetha on Fri, 25 August 2000 07:09
		Re: Deleting duplicate rows By: Vijay on Mon, 22 January 2001 08:13
		Re: Deleting duplicate rows By: Vijay on Mon, 22 January 2001 08:14

		Oracle Number data type By: Tam on Thu, 18 January 2001 17:12
		Re: Oracle Number data type By: SQL_Tuner on Fri, 19 January 2001 00:25
		Re: Oracle Number data type By: Balazs VISSY on Mon, 22 January 2001 04:48

By: shyam on Mon, 22 January 2001 01:18

		maxextents By: Uday on Fri, 15 December 2000 03:32
		Re: maxextents By: John R on Fri, 15 December 2000 03:39
		Re: maxextents By: aadit on Sun, 21 January 2001 14:29

By: Brad Wickwire on Sun, 21 January 2001 10:21

		Trigger insuring parent records inserted before progeny By: Gene K. Smith on Thu, 18 January 2001 16:37
		Re: Trigger insuring parent records inserted before progeny By: Robert Moy on Sat, 20 January 2001 18:38

		finding duplicate values in a column By: meena on Fri, 19 January 2001 14:19
		Re: finding duplicate values in a column By: Paul on Fri, 19 January 2001 14:31
		Re: finding duplicate values in a column By: Mahesh on Sat, 20 January 2001 04:48

		SQL Loader By: Arch on Fri, 19 January 2001 10:28
		Re: SQL Loader By: Andrew again... on Fri, 19 January 2001 18:45

		Spooling from SQLPLUS using a .bet or .cmd file By: Matt on Wed, 17 January 2001 10:14
		Re: Spooling from SQLPLUS using a .bet or .cmd file By: Suresh Vemulapalli on Wed, 17 January 2001 10:44
		Re: Spooling from SQLPLUS using a .bet or .cmd file By: Andrew again... on Wed, 17 January 2001 12:27
		Re: Spooling from SQLPLUS using a .bet or .cmd file By: Sajit Nair on Thu, 18 January 2001 22:45
		Re: Spooling from SQLPLUS using a .bet or .cmd file By: bc on Fri, 19 January 2001 17:29

		Tablespace % used query By: Sajit Nair on Fri, 19 January 2001 00:38
		Re: Tablespace % used query By: Andrew again... on Fri, 19 January 2001 15:33

		decode in control file By: Prasad on Fri, 19 January 2001 08:51
		Re: decode in control file By: Bala on Fri, 19 January 2001 14:17

		Selecting values from two tables depending on the condition satisfied from ... By: Suma on Fri, 19 January 2001 11:52
		Re: Selecting values from two tables depending on the condition satisfied f... By: Madhav Kasojjala on Fri, 19 January 2001 12:38