Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Best practices in Oracle ? Expand / Collapse
Author
Message
Posted Thursday, October 8, 2009 12:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, August 3, 2014 10:22 PM
Points: 97, Visits: 324
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


Regards
Kumar Harsh

Post #799726
Posted Thursday, October 8, 2009 11:12 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:40 PM
Points: 1,045, Visits: 2,724
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, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #800507
Posted Friday, October 9, 2009 2:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, August 3, 2014 10:22 PM
Points: 97, Visits: 324
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.


Regards
Kumar Harsh

Post #800578
Posted Wednesday, September 19, 2012 8:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:34 PM
Points: 23,302, Visits: 32,056
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

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1361389
Posted Wednesday, September 19, 2012 8:28 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:34 PM
Points: 23,302, Visits: 32,056
tutblog1 (9/19/2012)
Ok Brother,

If anyone need to learn SQL just tell about this blog. Its help me alot.

Thanks,


Why?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1361396
Posted Wednesday, September 19, 2012 10:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:23 AM
Points: 5,047, Visits: 11,799
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?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1361481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse