VOUG Membership: Here's the first of my presentation highlights for the conference coming up March 1st and 2nd. I always send these out before each meeting to...
VOUG Membership - I was about to send out the next in my series of presentation summaries when our conference coordinator notified me of a potential problem....
All, I have several records that are address fields like this one below: 100 W MAIN ST APT 900 101 Davis Hwy SW #210 They are stored in one Address1 column....
Phillip, Hi. The last time we did this (cause I know it will happen again) the application development group wrote a program. Why? 1) The data was put in U.S....
Allen Shepard
ashepard@...
Feb 8, 2006 4:52 pm
829
VOUG Membership - Here's the second of my presentation highlights for the conference coming up March 1st and 2nd. By the way, the last date for early...
I have a table that I exported to Oracle from MS Access. The Access database must be identified with double quotes around each field. I wrote an Insert...
Always include a target column list in your INSERT statements. Without knowing the structure of your TBL_ADDRESS table, there is no way to determine which...
Mark C. Stock
mcstock@...
Feb 10, 2006 4:21 pm
833
VOUG Membership - Here's the third of my presentation highlights for the conference coming up March 1st and 2nd. As you know, the last date for early...
VOUG Membership - *Today* is the last day for early registration! Details at http://www.voug.org All of these presentations are scheduled for Session 3,...
VOUG Membership - We track registrations against historical trends from past conferences, and I have to say I'm amazed at the number of folks that registered...
VOUG Membership - Here's the fifth of my presentation highlights, to help you plan ahead. All of these presentations are scheduled for Session 5, which is...
VOUG Membership - Here's the sixth of my presentation highlights, to help you plan ahead for next week. All of these presentations are scheduled for Session...
VOUG Membership - Our conference coordinator just told me they'll be shutting down online registration for Wednesday's conference, so if you're a last-minute...
I am trying to calculate total Oracle memory usage on a Windows server. I am taking Total System Global Area from show sga to get the memory allocated to SGA....
Hi all, I am new in trigger development. I am using Oracle 10G and trying to develop a trigger to solve the following problem: I have 2 tables LIST_TABLE and...
Hello, I think there is no need of loop in trigger body because you trigger fors for every row. Second thing is you first checkt that the inserting row is...
The problem is that you are trying to loop through the columns as if the list of columns was an array, but it is not an array. Yes, I know, if you are used to...
Hiya All, I am trying to build an Application Server for the first time, and I am kinda stuck. I am trying to install Oracle AS 10.1.2.0.2 onto a machine that...
Larry Blankenship
lblankenship@...
Mar 20, 2006 2:10 pm
845
We have a 10g database running on HP-Unix Itanium servers. We have two identical servers with Oracle 10g installed and configured. All database files (control...
I have never done this before but I think it is very possible (I was about to test this idea but ended up creating them again). Since OEM jobs are saved in a...
Devamanoharan, Mano
devamanp@...
Mar 20, 2006 8:28 pm
847
I am writing an Oracle Standards Document for our Company but have found very few templates available for this. Does anyone out there have an Oracle Standards...
Yeah, we had that problem too. Turns out that this version of Forms and Reports server CANNOT be installed without OID. OID doesn't have to be running on the...
William, Hi. I too have found very few standards on the internet. Do you mean database naming standards or ones for columns and tables. ?? Allen ... I am...
Allen Shepard
ashepard@...
Mar 24, 2006 12:35 pm
850
I have a few standards-type documents on my website: http://www.smdi.com/employee/JohnF/ Don't know if anything there will be helpful to you. I found an old ...
We're a UNIX shop that uses 8i, 9i, and 10g. We're a bizarre mix at my company. We definitely have standards but they're not documented in one place. We have...
Hi, Ruth - you are right about picking the battles. Often a company is made up of many people who each have atleast 10 *different* years of database and...
Allen Shepard
ashepard@...
Mar 27, 2006 2:53 pm
853
Hey Bill, What kind of standards are you looking for, we have created some basic programming standards, if this is what you are looking for let me know. Thanks...
Since this was part of the original discussion - Can either Ruth, Allen or anyone provide some real world examples of the seperation between dba accounts....
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.
