Oracle Database Discussions

I'm currently learning Oracle and SQL and in the process am converting (and in spots improving, I hope) a fairly elaborate Access database I developed a while back.

Up to now I've only been working on importing the tables. But that has already got me wondering about good transparent naming conventions in Oracle. When I was working in Access, most people liked using the tbl prefix for tables and qry for queries. But the SQL book I'm working through seems to prefer the short "l_" prefix for tables and often names views with the suffix "view".

It seem pretty transparent to me to name all base tables tbl_... and all views qry_... as I'm creating these in Oracle. But it would be nice to know before getting too far along with actually creating them what the generally accepted norms are these days, and if these are different between Oracle and Access. I haven't see the term "query" much, although it may be due to the author of my SQL book, but I don't see any substantive difference between a view in SQL and what Access calls a select query. Anyhow, if I'm creating an Oracle database, I'd like to use the preferred Oracle terminology, since that makes communication and understanding a lot easier.