The Owner's Manual specifies 10W-30. I use Quaker State Full Synthetic but traditionally, one uses non-synthetic engine oil for a 4-cylinder engine. As long as you use 10W-30, you really can't go wrong. Try not to mix synthetic and non-synthetic oils. Check what was used in the last oil change and use as close to that as you can.
10w-30
10W40
5w-30
There is no such thing as a 94 stanza, it became the altima in 93.
what kind of coolant goes into 2006 nissan altima
The 2011 Nissan Altima has double overhead cam (DOHC).
The 2007 Nissan Altima has double overhead cam (DOHC).
The 2003 Nissan Altima has double overhead cam (DOHC).
The 2009 Nissan Altima has double overhead cam (DOHC).
The 2008 Nissan Altima has double overhead cam (DOHC).
The 2004 Nissan Altima has double overhead cam (DOHC).
The 2001 Nissan Altima has double overhead cam (DOHC).