Best practices in Oracle ?

Question

Best practices in Oracle ?

pandeharsh

Ten Centuries

Points: 1106
More actions
October 8, 2009 at 12:34 am

#135557

Hi,
Do we have any naming convention in oracle store procedure like in sql server ?
For example,in sql server store procedure it is forbidded to prefix "sp" in naming store procedure, apart from other thing.
Do we have any such document or article for oracle.
Thanks
[font="Verdana"]Regards
Kumar Harsh[/font]
:unsure:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15681 More actions · Answer 1

Actually, the example you mentioned, using "sp_" as part of a stored procedure name, is not forbidden by the database engine. It is considered by many to be a bad practice since this pattern identifies system stored procedures, but it is technically allowed.

Naming conventions vary widely - even within SQL Server there is a lot of disparity. Some people use lower case object names, others use upper case. Some use underscores as word separators in object names, and others use no separators. Naming conventions are generally defined by the organization for whom you work.

If you're looking for overall best practices for Oracle, you'll have better luck if you search for Oracle-specific forums.

hth,

Tim

Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices

pandeharsh Ten Centuries Points: 1106 More actions · Answer 2

Hi,

Thanks.

Actually,I hv a best practices of Sql server document,where it is mention

like whether to use cursor or not etc and many such thing.

I was expecting equivalent of this document in oracle.

Hope,I find answer of all those thing in oracle gradually.

[font="Verdana"]Regards
Kumar Harsh[/font]

:unsure:

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

pandeharsh (10/9/2009)
Hi,
Thanks.
Actually,I hv a best practices of Sql server document,where it is mention
like whether to use cursor or not etc and many such thing.
I was expecting equivalent of this document in oracle.
Hope,I find answer of all those thing in oracle gradually.

If you are looking for Oracle information you should look for an Oracle site. SQLServerCentral.com is a Microsoft SQL Server centric site with perhaps a smattering of Oracle for those who do find themselves working with both, but there isn't a lot of Oracle knowledge here.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

tutblog1 (9/19/2012)
Ok Brother,
If anyone need to learn SQL just tell about this blog. Its help me alot.
Thanks,

Why?

Phil Parkin SSC Guru Points: 246960 More actions · Answer 5

tutblog1 (9/19/2012)
Ok Brother,
If anyone need to learn SQL just tell about this blog. Its help me alot.
Thanks,

Easily learn SQL with the help of images.

Is that because words are too difficult?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin