And do you expect a link or a real example script??? On Tue 26. March 2002 19:29, you wrote: > Can someone please create a table for me? Umm...I need last and first name > columns. I don't want the DDL, I want you to connect to my database and > create it for me. I need this done yesterday. > > Thanks, really, thanks. Hurry up!! > > -----Original Message----- > Sent: Tuesday, March 26, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > LMAO > > Obligatory Oracle Question: > > Does anybody have a sample init.ora file that they use for a 9.0.1 > instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my > desktop PC play database.. > > -----Original Message----- > [EMAIL PROTECTED] > Sent: 26 March 2002 16:39 > To: Multiple recipients of list ORACLE-L > > > > Roland, > > What a surprise! I thought you were moving to an Access list? Because > I've taken a rather perverse interest in the questions you ask, I'll give > you a hint: triggers and exception handling. > > By the way, if no one has answered your question regarding a "table of > table definitions", it's probably because they are suffering from shock. > You are the DBA, are you not? This information already exists in a number > of cleverly designed Oracle supplied views. I suggest you become familiar > with the DBA_ views and the V$ views. A simple SQL query (which of course > you'll ask for someone to provide an example) should get you all the > information your heart desires. > > Study your craft my friend. > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > Roland.Skoldbl > [EMAIL PROTECTED] To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR > om > > > 03/26/2002 > 12:23 AM > Please respond > to ORACLE-L > > > > > > > Hallo, > > > Can anyone give me an example on a pl/sql code, which does the following: > > > > I have 4 procedures, and I want the following to be logged in a status > > table. > > > > Procedure names > > Start_time of procedure > > End_time_of procedure > > Error_code(if anything goes wrong) > > Error_message > > > > Please give me example onhow to write the code and also tell me how to > > pick > > > out the procedure_name, start_time of_procedure, end_time_ptocedure, > > error_code, error_message. > > > > Thanks in advance.And just dontgive me a link, i wantthis real example > > too. > > > Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).