db* CODECOP Version 4.3.0 (2022-09-02 07:12:58 +0200) for Trivadis PL/SQL & SQL Coding Guidelines Version 4.2

License

Philipp Salvisberg, Trivadis AG, CH-8152 Glattbrugg
valid thru	9999-12-31
valid for versions less than	5
max. files	unlimited
max. lines	unlimited
max. commands	unlimited
max. bytes	unlimited
limited to	personal use

Parameters

path	/usr/local/bin/tvdcc/sample
filter	(sql\|prc\|fnc\|pks\|pkb\|trg\|vw\|tps\|tpb\|tbp\|plb\|pls\|rcv\|spc\|typ\|aqt\|aqp\|ctx\|dbl\|tab\|dim\|snp\|con\|collt\|seq\|syn\|grt\|sp\|spb\|sps\|pck\|md\|mdown)$
timeout	10
complexity	4
output	/usr/local/bin/tvdcc/./tvdcc_report.html
template	html.xsl
excel	true
html	true
transonly	false
cleanup	true
check
skip	0000,1050,2130,3160,3170,5010,7170,7460,7740,8410,8510
nosonar	true
license
validator	com.trivadis.tvdcc.validators.TrivadisGuidelines3
genmodel	false

Processing

Start of processing	2022-09-02 11:54:21
End of processing	2022-09-02 11:54:27
Processing time in seconds	5.768

Content

Number of files	122
Number of bytes	227,509
Number of lines (LOC)	9,413
Number of comment lines	1,169
Number of blank lines	1,428
Number of net lines	6,816
Number of commands	298
Number of statements (PL/SQL)	1,584
Max. cyclomatic complexity	5	( < 11	11..50	> 50	)
Max. Halstead volume	575	( < 1001	1001..3000	> 3000	)
Min. maintainability index (MI)	82	( > 84	64..84	< 64	)
Number of issues	298
Number of warnings	298
Number of errors	0

Issue Overview

#	%	Severity	Characteristics	Message
1	0.3%	Blocker	Portability, Reliability	G-2150: Avoid comparisons with NULL value, consider using IS [NOT] NULL.
1	0.3%	Blocker	Reliability, Testability	G-5030: Never assign predefined exception names to user defined exceptions.
1	0.3%	Blocker	Reliability, Testability	G-7720: Never use multiple UPDATE OF in trigger event clause.
2	0.7%	Critical	Reliability	G-5070: Avoid using Oracle predefined exceptions
2	0.7%	Critical	Testability	G-7910: Never use DML within a SQL macro.
1	0.3%	Critical	Reliability	G-2160: Avoid initializing variables using functions in the declaration section.
1	0.3%	Critical	Reliability	G-3310: Never commit within a cursor loop.
1	0.3%	Critical	Reliability	G-4120: Avoid using %NOTFOUND directly after the FETCH when working with BULK OPERATIONS and LIMIT clause.
1	0.3%	Critical	Efficiency, Reliability	G-4230: Always use a COALESCE instead of a NVL command, if parameter 2 of the NVL function is a function call or a SELECT statement.
1	0.3%	Critical	Efficiency, Reliability	G-4240: Always use a CASE instead of a NVL2 command if parameter 2 or 3 of NVL2 is either a function call or a SELECT statement.
1	0.3%	Critical	Maintainability	G-5020: Never handle unnamed exceptions using the error number.
13	4.4%	Major	Maintainability, Testability	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.
11	3.7%	Major	Maintainability	G-4365: Never use unconditional CONTINUE or EXIT in a loop.
6	2.0%	Major	Changeability, Maintainability	G-7110: Try to use named notation when calling program units.
5	1.7%	Major	Efficiency	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.
4	1.3%	Major	Maintainability	G-3120: Always use table aliases when your SQL statement involves more than one source.
4	1.3%	Major	Maintainability	G-4370: Avoid using EXIT to stop loop processing unless you are in a basic loop.
4	1.3%	Major	Efficiency, Maintainability	G-7160: Always explicitly state parameter mode.
3	1.0%	Major	Maintainability	G-2180: Never use quoted identifiers.
3	1.0%	Major	Maintainability, Reliability, Testability	G-3145: Avoid using SELECT * directly from a table or view.
3	1.0%	Major	Changeability, Reliability	G-3180: Always specify column names instead of positional references in ORDER BY clauses.
3	1.0%	Major	Reliability	G-5040: Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.
3	1.0%	Major	Reliability	G-5060: Avoid unhandled exceptions
3	1.0%	Major	Maintainability, Reliability, Testability	G-7130: Always use parameters or pull in definitions rather than referencing external variables in a local program unit.
3	1.0%	Major	Reliability	G-7230: Avoid declaring global variables public.
2	0.7%	Major	Portability	G-2510: Avoid using the LONG and LONG RAW data types.
2	0.7%	Major	Maintainability, Reliability	G-3140: Try to use anchored records as targets for your cursors.
2	0.7%	Major	Changeability, Reliability	G-3190: Avoid using NATURAL JOIN.
2	0.7%	Major	Efficiency	G-4385: Never use a cursor for loop to check whether a cursor returns data.
2	0.7%	Major	Maintainability, Testability	G-7430: Try to use no more than one RETURN statement within a function.
2	0.7%	Major	Maintainability, Testability	G-7710: Avoid cascading triggers.
2	0.7%	Major	Efficiency	G-8110: Never use SELECT COUNT(*) if you are only interested in the existence of a row.
1	0.3%	Major	Reliability	G-1060: Avoid storing ROWIDs or UROWIDs in database tables.
1	0.3%	Major	Maintainability, Reliability	G-2110: Try to use anchored declarations for variables, constants and types.
1	0.3%	Major	Reliability	G-2170: Never overload variables.
1	0.3%	Major	Portability, Reliability	G-2190: Avoid using ROWID or UROWID.
1	0.3%	Major	Reliability	G-2310: Avoid using CHAR data type.
1	0.3%	Major	Portability	G-2320: Never use VARCHAR data type.
1	0.3%	Major	Portability	G-2330: Never use zero-length strings to substitute NULL.
1	0.3%	Major	Maintainability, Reliability	G-3110: Always specify the target columns when coding an insert statement.
1	0.3%	Major	Testability	G-3185: Never use ROWNUM at the same query level as ORDER BY.
1	0.3%	Major	Testability	G-3220: Always process saved exceptions from a FORALL statement.
1	0.3%	Major	Reusability, Testability	G-3320: Try to move transactions within a non-cursor loop into procedures.
1	0.3%	Major	Efficiency, Reliability	G-4130: Always close locally opened cursors.
1	0.3%	Major	Reliability	G-4140: Avoid executing any statements between a SQL operation and the usage of an implicit cursor attribute.
1	0.3%	Major	Maintainability, Testability	G-4210: Try to use CASE rather than an IF statement with multiple ELSIF paths.
1	0.3%	Major	Reliability, Testability	G-4250: Avoid using identical conditions in different branches of the same IF or CASE statement.
1	0.3%	Major	Maintainability, Testability	G-4310: Never use GOTO statements in your code.
1	0.3%	Major	Reliability, Testability	G-4325: Never reuse labels in inner scopes.
1	0.3%	Major	Reliability	G-4350: Always use 1 as lower and COUNT() as upper bound when looping through a dense array.
1	0.3%	Major	Efficiency	G-4390: Avoid use of unreferenced FOR loop indexes.
1	0.3%	Major	Changeability, Maintainability	G-5050: Avoid use of the RAISE_APPLICATION_ERROR built-in procedure with a hard-coded 20nnn error number or hard-coded message.
1	0.3%	Major	Maintainability, Testability	G-6010: Always use a character variable to execute dynamic SQL.
1	0.3%	Major	Maintainability, Reliability	G-7140: Always ensure that locally defined procedures or functions are referenced.
1	0.3%	Major	Maintainability, Testability	G-7320: Avoid using RETURN statements in a PROCEDURE.
1	0.3%	Major	Testability	G-7330: Always assign values to OUT parameters.
1	0.3%	Major	Maintainability	G-7420: Always make the RETURN statement the last statement of your function.
1	0.3%	Major	Reusability	G-7440: Never use OUT parameters to return values from a function.
1	0.3%	Major	Reliability, Testability	G-7450: Never return a NULL value from a BOOLEAN function.
1	0.3%	Major	Security	G-7510: Always prefix Oracle supplied packages with owner schema name.
1	0.3%	Major	Efficiency, Maintainability	G-7810: Never use SQL inside PL/SQL to read sequence numbers (or SYSDATE).
1	0.3%	Major	Efficiency, Reliability	G-8120: Never check existence of a row to decide whether to create it or not.
1	0.3%	Major	Changeability, Maintainability	G-8210: Always use synonyms when accessing objects of another application schema.
1	0.3%	Major	Maintainability, Reliability, Security, Testability	G-9010: Always use a format model in string to date/time conversion functions.
1	0.3%	Major	Maintainability, Reliability, Security, Testability	G-9020: Try to use a format model and NLS_NUMERIC_CHARACTERS in string to number conversion functions.
76	25.5%	Minor	Maintainability, Reliability, Reusability, Testability	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.
7	2.3%	Minor	Reliability, Testability	G-9030: Try to define a default value on conversion errors.
6	2.0%	Minor	Maintainability	G-1040: Avoid dead code.
5	1.7%	Minor	Maintainability	G-1020: Always have a matching loop or block label.
4	1.3%	Minor	Efficiency, Maintainability	G-1030: Avoid defining variables that are not used.
4	1.3%	Minor	Maintainability	G-4320: Always label your loops.
4	1.3%	Minor	Testability	G-9040: Try using FX in string to date/time conversion format model to avoid fuzzy conversion.
3	1.0%	Minor	Maintainability	G-2185: Avoid using overly short names for explicitly or implicitly declared identifiers.
3	1.0%	Minor	Maintainability, Reliability	G-3150: Try to use identity columns for surrogate keys.
3	1.0%	Minor	Maintainability	G-4330: Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations.
3	1.0%	Minor	Maintainability	G-4380: Try to label your EXIT WHEN statements.
3	1.0%	Minor	Changeability, Maintainability	G-4395: Avoid hard-coded upper or lower bound values with FOR loops.
3	1.0%	Minor	Maintainability	G-7120: Always add the name of the program unit to its end keyword.
3	1.0%	Minor	Maintainability	G-7410: Avoid standalone functions – put your functions in packages.
3	1.0%	Minor	Reliability	G-7730: Avoid multiple DML events per trigger.
2	0.7%	Minor	Maintainability	G-1010: Try to label your sub blocks.
2	0.7%	Minor	Maintainability	G-1070: Avoid nesting comment blocks.
2	0.7%	Minor	Maintainability	G-2140: Never initialize variables with NULL.
2	0.7%	Minor	Efficiency	G-2220: Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.
2	0.7%	Minor	Efficiency	G-2230: Try to use SIMPLE_INTEGER datatype when appropriate.
2	0.7%	Minor	Reliability	G-2340: Always define your VARCHAR2 variables using CHAR SEMANTIC (if not defined anchored).
2	0.7%	Minor	Maintainability, Portability	G-4220: Try to use CASE rather than DECODE.
2	0.7%	Minor	Maintainability	G-4375: Always use EXIT WHEN instead of an IF statement to exit from a loop.
2	0.7%	Minor	Efficiency, Maintainability	G-7150: Try to remove unused parameters.
2	0.7%	Minor	Changeability	G-7220: Always use forward declaration for private functions and procedures.
1	0.3%	Minor	Efficiency, Testability	G-1080: Avoid using the same expression on both sides of a relational comparison operator or a logical operator.
1	0.3%	Minor	Changeability	G-2120: Try to have a single location to define your types.
1	0.3%	Minor	Maintainability	G-2145: Never self-assign a variable.
1	0.3%	Minor	Efficiency	G-2210: Avoid declaring NUMBER variables, constants or subtypes with no precision.
1	0.3%	Minor	Maintainability	G-2410: Try to use boolean data type for values with dual meaning.
1	0.3%	Minor	Maintainability, Portability, Reusability	G-2610: Never use self-defined weak ref cursor types.
1	0.3%	Minor	Maintainability	G-3115: Avoid self-assigning a column.
1	0.3%	Minor	Maintainability, Portability	G-3130: Try to use ANSI SQL-92 join syntax.
1	0.3%	Minor	Maintainability	G-3195: Always use wildcards in a LIKE clause.
1	0.3%	Minor	Maintainability	G-4110: Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor returned data.
1	0.3%	Minor	Testability	G-4260: Avoid inverting boolean conditions with NOT.
1	0.3%	Minor	Testability	G-4270: Avoid comparing boolean values to boolean literals.
1	0.3%	Minor	Maintainability	G-4340: Always use a NUMERIC FOR loop to process a dense array.
1	0.3%	Minor	Efficiency	G-4360: Always use a WHILE loop to process a loose array.
1	0.3%	Minor	Testability	G-5080: Always use FORMAT_ERROR_BACKTRACE when using FORMAT_ERROR_STACK or SQLERRM.
1	0.3%	Minor	Maintainability	G-6020: Try to use output bind arguments in the RETURNING INTO clause of dynamic DML statements rather than the USING clause.
1	0.3%	Minor	Maintainability	G-7125: Always use CREATE OR REPLACE instead of CREATE alone.
1	0.3%	Minor	Efficiency, Maintainability	G-7210: Try to keep your packages small. Include only few procedures and functions that are used in the same context.
1	0.3%	Minor	Maintainability	G-7250: Never use RETURN in package initialization block.
1	0.3%	Minor	Maintainability	G-7310: Avoid standalone procedures – put your procedures in packages.

Complex PL/SQL Units

File name	PL/SQL Unit	Line	# Lines	# Comment lines	# Blank lines	# Net lines	# Stmts	Cyclomatic complexity	Halstead volume	Maintainability index
guidelines/guideline_1040_04.sql	AnonymousPlsqlBlock	10	31	1	6	31	14	5	349	93
guidelines/guideline_4370_45.sql	AnonymousPlsqlBlock	14	29	0	3	29	13	5	411	82
guidelines/guideline_4310_39.sql	my_package.password_check	26	21	0	3	21	10	5	492	86
guidelines/guideline_4310_39.sql	my_package.password_check	63	21	0	3	21	10	5	492	86
guidelines/guideline_4320_40.sql	AnonymousPlsqlBlock	12	18	0	3	18	9	5	289	91
guidelines/guideline_4320_40.sql	AnonymousPlsqlBlock	41	25	0	3	25	9	5	346	85
guidelines/guideline_4370_45.sql	AnonymousPlsqlBlock	54	25	0	3	25	9	5	346	85

File Overview

File name	# Warnings	# Errors	# Bytes	# Lines	# Net lines	# Cmds	# Stmts	Max. cyclomatic complexity	Max. Halstead volume	Min. MI	Elapsed seconds
guidelines/guideline_5080_na.sql	9	0	1,810	51	39	2	10	3	147	100	0.008
guidelines/guideline_9010_na.sql	8	0	1,685	36	20	2	2	1	32	127	0.008
guidelines/guideline_1020_02.sql	7	0	1,549	82	62	2	26	4	306	86	0.034
guidelines/guideline_3320_na.sql	7	0	1,273	48	33	2	9	2	138	109	0.017
guidelines/guideline_4310_39.sql	7	0	3,645	102	76	3	22	5	492	86	0.067
guidelines/guideline_4320_40.sql	7	0	1,425	69	55	2	18	5	346	85	0.060
guidelines/guideline_7130_62.sql	7	0	2,643	77	55	2	14	3	169	99	0.011
guidelines/guideline_8410_na.sql	7	0	2,806	94	65	4	16	2	318	95	0.013
guidelines/guideline_9020_na.sql	7	0	1,872	38	20	2	2	1	40	126	0.011
guidelines/guideline_9030_na.sql	7	0	1,222	35	20	2	2	1	37	126	0.006
guidelines/guideline_9040_na.sql	7	0	1,583	36	20	2	2	1	32	127	0.013
guidelines/guideline_1040_04.sql	6	0	1,497	69	52	2	19	5	349	93	0.076
guidelines/guideline_2510_25.sql	6	0	944	40	26	4	2	1	0	221	0.009
guidelines/guideline_4370_45.sql	6	0	1,888	82	66	2	22	5	411	82	0.011
guidelines/guideline_7220_66.sql	6	0	2,011	76	60	4	16	2	114	103	0.026
guidelines/guideline_7910_na.sql	6	0	1,033	38	23	2	4	1	59	114	0.011
guidelines/guideline_2180_15.sql	5	0	547	30	22	2	4	2	51	121	0.009
guidelines/guideline_2185_16.sql	5	0	694	32	22	2	4	2	51	121	0.008
guidelines/guideline_4140_34.sql	5	0	2,404	67	40	2	11	2	143	123	0.057
guidelines/guideline_6020_59.sql	5	0	1,838	43	31	2	2	1	41	126	0.009
guidelines/guideline_7330_na.sql	5	0	785	31	21	2	2	1	28	136	0.006
guidelines/guideline_7420_73.sql	5	0	1,052	40	32	2	9	3	114	107	0.007
guidelines/guideline_7430_72.sql	5	0	1,089	45	34	3	8	2	102	111	0.007
guidelines/guideline_2410_24.sql	4	0	953	43	32	3	7	2	124	114	0.013
guidelines/guideline_3120_27.sql	4	0	1,923	60	38	5	0	0	0	221	0.013
guidelines/guideline_7120_61.sql	4	0	1,171	49	36	2	8	3	69	107	0.048
guidelines/guideline_7150_64.sql	4	0	1,500	49	39	2	12	2	108	103	0.009
guidelines/guideline_7160_68.sql	4	0	1,379	29	18	2	0	0	0	221	0.007
guidelines/guideline_7250_na.sql	4	0	1,795	51	32	2	8	1	84	116	0.010
guidelines/guideline_3180_na.sql	3	0	735	27	15	2	0	0	0	221	0.007
guidelines/guideline_3310_na.sql	3	0	2,556	84	56	3	15	4	385	88	0.061
guidelines/guideline_4110_31.sql	3	0	999	48	34	2	10	2	138	106	0.010
guidelines/guideline_4130_33.sql	3	0	1,803	44	31	2	7	1	128	117	0.012
guidelines/guideline_4385_48.sql	3	0	773	34	26	2	6	2	113	117	0.020
guidelines/guideline_5060_56.sql	3	0	1,847	49	31	2	6	3	82	106	0.008
guidelines/guideline_7125_na.sql	3	0	1,254	49	36	2	8	3	69	107	0.008
guidelines/guideline_7230_67.sql	3	0	3,274	83	51	5	6	1	61	127	0.010
guidelines/guideline_7740_na.sql	3	0	1,928	58	37	6	9	3	125	110	0.010
guidelines/guideline_8310_na.sql	3	0	1,717	55	39	3	10	2	123	128	0.010
guidelines/guideline_1010_01.sql	2	0	390	30	20	2	12	1	22	140	0.028
guidelines/guideline_1030_03.sql	2	0	1,330	47	38	2	7	3	139	104	0.033
guidelines/guideline_1070_07.sql	2	0	451	23	10	2	4	1	0	221	0.052
guidelines/guideline_2145_na.sql	2	0	734	27	18	2	6	1	82	122	0.012
guidelines/guideline_2220_19.sql	2	0	987	32	16	2	2	1	6	143	0.057
guidelines/guideline_2230_na.sql	2	0	1,584	42	20	2	2	1	6	143	0.009
guidelines/guideline_2330_22.sql	2	0	723	26	15	2	2	1	6	143	0.059
guidelines/guideline_3140_29.sql	2	0	1,235	45	34	2	10	2	196	128	0.012
guidelines/guideline_3170_na.sql	2	0	1,387	48	16	10	0	0	0	221	0.010
guidelines/guideline_3190_na.sql	2	0	1,315	53	24	5	0	0	0	221	0.008
guidelines/guideline_4220_36.sql	2	0	2,249	51	33	4	0	0	0	221	0.054
guidelines/guideline_4375_46.sql	2	0	927	37	24	2	9	3	132	105	0.048
guidelines/guideline_4380_47.sql	2	0	2,013	64	53	2	17	3	444	90	0.010
guidelines/guideline_5030_52.sql	2	0	2,118	65	39	2	9	4	259	97	0.008
guidelines/guideline_7110_60.sql	2	0	796	25	14	2	2	1	70	131	0.006
guidelines/guideline_7170_na.sql	2	0	4,228	80	66	2	24	2	575	111	0.017
guidelines/guideline_7710_77.sql	2	0	1,367	66	55	3	4	1	189	92	0.009
guidelines/guideline_7720_na.sql	2	0	1,271	41	28	2	2	1	63	112	0.007
guidelines/guideline_7810_na.sql	2	0	525	23	14	2	2	1	33	127	0.005
guidelines/guideline_8120_na.sql	2	0	1,144	38	26	2	5	2	91	108	0.007
guidelines/guideline_na_54.sql	2	0	2,440	73	53	2	10	3	143	102	0.012
guidelines/guideline_0000_00.sql	1	0	530	28	18	3	3	1	41	134	0.440
guidelines/guideline_1060_06.sql	1	0	913	38	26	2	2	1	57	137	0.014
guidelines/guideline_1080_na.sql	1	0	949	29	16	2	0	0	0	221	0.028
guidelines/guideline_2110_08.sql	1	0	1,364	44	34	2	6	3	100	108	0.014
guidelines/guideline_2120_09.sql	1	0	928	35	23	3	4	1	56	127	0.012
guidelines/guideline_2135_na.sql	1	0	1,547	51	39	2	9	3	189	99	0.021
guidelines/guideline_2140_11.sql	1	0	330	20	12	2	2	1	41	134	0.055
guidelines/guideline_2150_12.sql	1	0	555	26	16	2	4	2	31	127	0.009
guidelines/guideline_2160_13.sql	1	0	932	32	23	2	7	2	185	105	0.013
guidelines/guideline_2170_14.sql	1	0	1,291	46	38	2	12	1	217	106	0.015
guidelines/guideline_2190_17.sql	1	0	1,044	31	18	2	2	1	45	125	0.014
guidelines/guideline_2210_18.sql	1	0	822	28	16	2	2	1	6	143	0.011
guidelines/guideline_2310_20.sql	1	0	517	20	10	2	0	0	0	221	0.007
guidelines/guideline_2320_21.sql	1	0	657	19	8	2	0	0	0	221	0.006
guidelines/guideline_2340_23.sql	1	0	704	19	8	2	0	0	0	221	0.007
guidelines/guideline_2610_na.sql	1	0	929	39	29	2	6	2	174	105	0.011
guidelines/guideline_3110_26.sql	1	0	484	27	17	2	0	0	0	221	0.055
guidelines/guideline_3115_na.sql	1	0	507	17	5	2	0	0	0	221	0.009
guidelines/guideline_3130_28.sql	1	0	753	27	17	2	0	0	0	221	0.055
guidelines/guideline_3145_na.sql	1	0	1,457	47	30	2	4	2	124	124	0.053
guidelines/guideline_3150_na.sql	1	0	1,636	45	21	4	1	1	30	135	0.015
guidelines/guideline_3185_na.sql	1	0	889	36	23	2	0	0	0	221	0.007
guidelines/guideline_3195_na.sql	1	0	999	30	13	3	0	0	0	221	0.011
guidelines/guideline_3210_30.sql	1	0	1,621	44	32	2	6	2	226	102	0.013
guidelines/guideline_3220_na.sql	1	0	1,960	53	41	2	8	3	404	93	0.017
guidelines/guideline_4120_32.sql	1	0	2,707	95	69	3	21	3	304	95	0.062
guidelines/guideline_4210_35.sql	1	0	826	35	27	2	9	4	175	104	0.009
guidelines/guideline_4230_37.sql	1	0	650	17	5	2	0	0	0	221	0.007
guidelines/guideline_4240_38.sql	1	0	768	22	11	2	0	0	0	221	0.006
guidelines/guideline_4250_na.sql	1	0	1,147	41	30	2	10	4	151	104	0.008
guidelines/guideline_4260_na.sql	1	0	485	25	16	2	4	2	72	122	0.007
guidelines/guideline_4270_na.sql	1	0	740	29	20	2	6	2	121	117	0.008
guidelines/guideline_4325_na.sql	1	0	868	34	24	6	4	2	91	116	0.007
guidelines/guideline_4330_41.sql	1	0	1,148	42	28	2	8	2	173	103	0.008
guidelines/guideline_4340_42.sql	1	0	1,519	49	33	2	9	2	345	101	0.010
guidelines/guideline_4350_43.sql	1	0	1,855	55	35	3	7	3	151	109	0.009
guidelines/guideline_4360_44.sql	1	0	1,977	58	39	2	11	3	367	98	0.058
guidelines/guideline_4365_na.sql	1	0	868	30	20	2	8	2	108	113	0.008
guidelines/guideline_4390_49.sql	1	0	1,699	50	39	2	8	2	332	99	0.008
guidelines/guideline_4395_50.sql	1	0	788	30	19	2	4	2	91	116	0.006
guidelines/guideline_5020_51.sql	1	0	948	33	22	2	7	4	104	109	0.006
guidelines/guideline_5040_53.sql	1	0	1,734	43	22	3	7	2	50	149	0.006
guidelines/guideline_5050_55.sql	1	0	1,341	26	8	2	2	1	30	181	0.006
guidelines/guideline_5070_57.sql	1	0	934	26	10	2	2	1	5	145	0.004
guidelines/guideline_6010_58.sql	1	0	584	23	14	2	2	1	39	134	0.006
guidelines/guideline_7140_63.sql	1	0	1,586	42	24	2	4	1	25	136	0.008
guidelines/guideline_7210_65.sql	1	0	69,458	4,217	3,368	2	840	1	0	221	1.935
guidelines/guideline_7310_69.sql	1	0	672	27	16	3	2	1	0	221	0.007
guidelines/guideline_7320_70.sql	1	0	1,423	43	28	2	7	3	129	108	0.008
guidelines/guideline_7410_71.sql	1	0	625	22	12	2	2	1	6	143	0.007
guidelines/guideline_7440_74.sql	1	0	634	24	15	2	3	1	21	133	0.006
guidelines/guideline_7450_75.sql	1	0	547	23	14	2	2	1	6	143	0.005
guidelines/guideline_7510_76.sql	1	0	577	22	12	2	2	1	47	133	0.005
guidelines/guideline_7730_na.sql	1	0	1,425	44	26	3	6	3	82	114	0.006
guidelines/guideline_8110_78.sql	1	0	1,504	52	41	2	7	4	244	95	0.010
guidelines/guideline_8210_79.sql	1	0	1,520	46	31	3	6	3	114	107	0.008
guidelines/guideline_8510_na.sql	1	0	1,177	41	32	2	5	2	131	104	0.008
guidelines/guideline_1050_05.sql	0	0	1,817	58	38	3	10	4	124	101	0.016
guidelines/guideline_2130_10.sql	0	0	1,218	41	22	3	4	1	44	129	0.057
guidelines/guideline_3160_na.sql	0	0	1,588	55	29	4	6	1	151	111	0.054
guidelines/guideline_5010_na.sql	0	0	915	32	12	2	4	1	79	158	0.006
guidelines/guideline_7460_na.sql	0	0	803	21	11	2	0	0	0	221	0.004

Total	298	0	227,509	9,413	6,816	298	1,584	5	575	82	4.514

File Issues

guidelines/guideline_5080_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	17	Major	G-7110: Try to use named notation when calling program units.	in_customer_id
2	17	Major	G-7110: Try to use named notation when calling program units.	in_discount
3	36	Major	G-7110: Try to use named notation when calling program units.	in_customer_id
4	36	Major	G-7110: Try to use named notation when calling program units.	in_discount
5	23	Minor	G-5080: Always use FORMAT_ERROR_BACKTRACE when using FORMAT_ERROR_STACK or SQLERRM.	sqlerrm
6	13	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_customer_id in customer.id%type
7	14	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_discount in customer.discount_percentage%type
8	32	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_customer_id in customer.id%type
9	33	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_discount in customer.discount_percentage%type

guidelines/guideline_9010_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Major	G-9010: Always use a format model in string to date/time conversion functions.	to_date(in_dob_str)
2	16	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
3	17	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
4	28	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
5	29	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
6	20	Minor	G-9030: Try to define a default value on conversion errors.	to_date(in_dob_str)
7	32	Minor	G-9030: Try to define a default value on conversion errors.	to_date(in_dob_str,'YYYY-MM-DD')
8	32	Minor	G-9040: Try using FX in string to date/time conversion format model to avoid fuzzy conversion.	'YYYY-MM-DD'

guidelines/guideline_1020_02.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	36	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit basic_loop
2	73	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit basic_loop
3	17	Minor	G-1020: Always have a matching loop or block label.	<<prepare_data>>
4	22	Minor	G-1020: Always have a matching loop or block label.	<<process_data>>
5	28	Minor	G-1020: Always have a matching loop or block label.	<<while_loop>>
6	34	Minor	G-1020: Always have a matching loop or block label.	<<basic_loop>>
7	39	Minor	G-1020: Always have a matching loop or block label.	<<for_loop>>

guidelines/guideline_3320_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.	for l_counter in 1..5 loop insert into headers (id,text) values (l_counter,'Number ' \|\| l_counter); insert into lines (header_id,line_no,text) select l_counter,rownum,'Line ' \|\| rownum from dual connect by level <= 3; commit; end loop create_headers
2	16	Major	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.	for l_counter in 1..5 loop insert into headers (id,text) values (l_counter,'Number ' \|\| l_counter); insert into lines (header_id,line_no,text) select l_counter,rownum,'Line ' \|\| rownum from dual connect by level <= 3; commit; end loop create_headers
3	21	Major	G-3320: Try to move transactions within a non-cursor loop into procedures.	commit
4	12	Minor	G-4395: Avoid hard-coded upper or lower bound values with FOR loops.	1..5
5	43	Minor	G-4395: Avoid hard-coded upper or lower bound values with FOR loops.	1..5
6	28	Minor	G-7120: Always add the name of the program unit to its end keyword.	create_rows
7	29	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	p_header_id in headers.id%type

guidelines/guideline_4310_39.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	38	Major	G-4310: Never use GOTO statements in your code.	goto check_other_things
2	75	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit check_digit
3	75	Major	G-4370: Avoid using EXIT to stop loop processing unless you are in a basic loop.	exit check_digit
4	75	Minor	G-4375: Always use EXIT WHEN instead of an IF statement to exit from a loop.	exit check_digit
5	18	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_password in varchar2
6	55	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_password in varchar2
7	92	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_password in varchar2

guidelines/guideline_4320_40.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit
2	51	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit basic_loop
3	14	Minor	G-4320: Always label your loops.	while (i <= co_max_value) loop i := i + co_increment; end loop
4	19	Minor	G-4320: Always label your loops.	loop exit; end loop
5	23	Minor	G-4320: Always label your loops.	for i in co_min_value..co_max_value loop sys.dbms_output.put_line(i); end loop
6	28	Minor	G-4320: Always label your loops.	for r_employee in (select last_name from employees) loop sys.dbms_output.put_line(r_employee.last_name); end loop
7	20	Minor	G-4380: Try to label your EXIT WHEN statements.	exit

guidelines/guideline_7130_62.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Major	G-7130: Always use parameters or pull in definitions rather than referencing external variables in a local program unit.	r_emp
2	23	Major	G-7130: Always use parameters or pull in definitions rather than referencing external variables in a local program unit.	r_emp
3	23	Major	G-7130: Always use parameters or pull in definitions rather than referencing external variables in a local program unit.	r_emp
4	16	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
5	46	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
6	49	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_salary in employees.salary%type
7	50	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_comm_pct in employees.commission_pct%type

guidelines/guideline_8410_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	38	Major	G-5040: Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.	when others then -- log error lock_up.release_lock(in_lock_name => co_lock_name); raise;
2	89	Major	G-5040: Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.	when others then -- log error lock_up.release_lock(in_lock_handle => l_handle); raise;
3	17	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_lock_name in varchar2
4	23	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_lock_name in varchar2
5	49	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_lock_name in varchar2
6	50	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_release_on_commit in boolean := false
7	71	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_lock_handle in varchar2

guidelines/guideline_9020_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Major	G-9020: Try to use a format model and NLS_NUMERIC_CHARACTERS in string to number conversion functions.	to_number(in_salary)
2	18	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
3	19	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_salary in varchar2
4	30	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
5	31	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_salary in varchar2
6	22	Minor	G-9030: Try to define a default value on conversion errors.	to_number(in_salary)
7	34	Minor	G-9030: Try to define a default value on conversion errors.	to_number(in_salary,'99999999999999999999.99999',q'[nls_numeric_characters='.,']')

guidelines/guideline_9030_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
2	15	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
3	27	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
4	28	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
5	18	Minor	G-9030: Try to define a default value on conversion errors.	to_date(in_dob_str,'YYYY-MM-DD')
6	18	Minor	G-9040: Try using FX in string to date/time conversion format model to avoid fuzzy conversion.	'YYYY-MM-DD'
7	31	Minor	G-9040: Try using FX in string to date/time conversion format model to avoid fuzzy conversion.	'YYYY-MM-DD'

guidelines/guideline_9040_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
2	17	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
3	28	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
4	29	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dob_str in varchar2
5	20	Minor	G-9030: Try to define a default value on conversion errors.	to_date(in_dob_str,'YYYY-MM-DD')
6	32	Minor	G-9030: Try to define a default value on conversion errors.	to_date(in_dob_str,'FXYYYY-MM-DD')
7	20	Minor	G-9040: Try using FX in string to date/time conversion format model to avoid fuzzy conversion.	'YYYY-MM-DD'

guidelines/guideline_1040_04.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	19	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit my_loop
2	11	Minor	G-1040: Avoid dead code.	2 = 3
3	19	Minor	G-1040: Avoid dead code.	exit my_loop
4	26	Minor	G-1040: Avoid dead code.	'x' = 'y'
5	38	Minor	G-1040: Avoid dead code.	5 = 6
6	45	Minor	G-1040: Avoid dead code.	return

guidelines/guideline_2510_25.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Major	G-2510: Avoid using the LONG and LONG RAW data types.	g_long long;
2	11	Major	G-2510: Avoid using the LONG and LONG RAW data types.	g_raw long raw;
3	10	Major	G-7230: Avoid declaring global variables public.	g_long
4	11	Major	G-7230: Avoid declaring global variables public.	g_raw
5	32	Minor	G-1030: Avoid defining variables that are not used.	g_long
6	33	Minor	G-1030: Avoid defining variables that are not used.	g_raw

guidelines/guideline_4370_45.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	25	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit basic_loop
2	43	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit process_employees
3	64	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit basic_loop
4	20	Major	G-4370: Avoid using EXIT to stop loop processing unless you are in a basic loop.	exit while_loop when i > co_max_value
5	32	Major	G-4370: Avoid using EXIT to stop loop processing unless you are in a basic loop.	exit for_loop when i = co_max_value
6	43	Major	G-4370: Avoid using EXIT to stop loop processing unless you are in a basic loop.	exit process_employees

guidelines/guideline_7220_66.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Minor	G-7220: Always use forward declaration for private functions and procedures.	does_exist
2	14	Minor	G-7220: Always use forward declaration for private functions and procedures.	does_exist
3	14	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type
4	32	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type
5	51	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type
6	58	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type

guidelines/guideline_7910_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Critical	G-7910: Never use DML within a SQL macro.	insert
2	20	Critical	G-7910: Never use DML within a SQL macro.	commit
3	13	Minor	G-7410: Avoid standalone functions – put your functions in packages.	row_generator
4	29	Minor	G-7410: Avoid standalone functions – put your functions in packages.	row_generator
5	14	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_num_rows in number
6	30	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_num_rows in number

guidelines/guideline_2180_15.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	"sal+comm" := "my constant"
2	25	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_sal_comm := co_my_constant
3	8	Major	G-2180: Never use quoted identifiers.	"sal+comm"
4	9	Major	G-2180: Never use quoted identifiers.	"my constant"
5	10	Major	G-2180: Never use quoted identifiers.	"my exception"

guidelines/guideline_2185_16.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	i := c
2	27	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_sal_comm := co_my_constant
3	10	Minor	G-2185: Avoid using overly short names for explicitly or implicitly declared identifiers.	i integer;
4	11	Minor	G-2185: Avoid using overly short names for explicitly or implicitly declared identifiers.	c constant integer := 1;
5	12	Minor	G-2185: Avoid using overly short names for explicitly or implicitly declared identifiers.	e exception;

guidelines/guideline_4140_34.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	32	Major	G-4140: Avoid executing any statements between a SQL operation and the usage of an implicit cursor attribute.	sql%rowcount
2	18	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dept_id in departments.department_id%type
3	23	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
4	44	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dept_id in departments.department_id%type
5	49	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type

guidelines/guideline_6020_59.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Minor	G-6020: Try to use output bind arguments in the RETURNING INTO clause of dynamic DML statements rather than the USING clause.	out out_new_salary
2	12	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
3	13	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase_pct in types_up.percentage
4	29	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
5	30	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase_pct in types_up.percentage

guidelines/guideline_7330_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_message := 'Hello, ' \|\| in_name
2	12	Major	G-7330: Always assign values to OUT parameters.	out_greeting
3	12	Minor	G-7150: Try to remove unused parameters.	out_greeting out varchar2
4	11	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_name in varchar2
5	24	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_name in varchar2

guidelines/guideline_7420_73.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-7420: Always make the RETURN statement the last statement of your function.	return l_ret
2	8	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_from in pls_integer
3	9	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_to in pls_integer
4	27	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_from in pls_integer
5	28	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_to in pls_integer

guidelines/guideline_7430_72.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-7430: Try to use no more than one RETURN statement within a function.	return true
2	14	Major	G-7430: Try to use no more than one RETURN statement within a function.	return false
3	8	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_value in pls_integer
4	22	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_value in pls_integer
5	39	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_value in pls_integer

guidelines/guideline_2410_24.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_bigger := constants_up.co_numeric_true
2	28	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_bigger := true
3	41	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_bigger := nvl(co_newfile < co_oldfile,false)
4	11	Minor	G-2410: Try to use boolean data type for values with dual meaning. (co_numeric_false, co_numeric_true).	l_bigger pls_integer;

guidelines/guideline_3120_27.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Major	G-3120: Always use table aliases when your SQL statement involves more than one source.	last_name
2	10	Major	G-3120: Always use table aliases when your SQL statement involves more than one source.	first_name
3	11	Major	G-3120: Always use table aliases when your SQL statement involves more than one source.	department_name
4	24	Major	G-3120: Always use table aliases when your SQL statement involves more than one source.	employee_id

guidelines/guideline_7120_61.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Minor	G-7120: Always add the name of the program unit to its end keyword.	employee_api
2	11	Minor	G-7120: Always add the name of the program unit to its end keyword.	employee_by_id
3	11	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
4	32	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type

guidelines/guideline_7150_64.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Minor	G-7150: Try to remove unused parameters.	in_manager_id in departments.manager_id%type
2	8	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type
3	9	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_manager_id in departments.manager_id%type
4	31	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_department_id in departments.department_id%type

guidelines/guideline_7160_68.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-7160: Always explicitly state parameter mode.	in_first_name employees.first_name%type
2	13	Major	G-7160: Always explicitly state parameter mode.	in_last_name employees.last_name%type
3	14	Major	G-7160: Always explicitly state parameter mode.	in_email employees.email%type
4	15	Major	G-7160: Always explicitly state parameter mode.	in_department_id employees.department_id%type

guidelines/guideline_7250_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	27	Minor	G-1040: Avoid dead code.	return
2	27	Minor	G-7250: Never use RETURN in package initialization block.	return
3	13	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase in types_up.sal_increase_type
4	37	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase in types_up.sal_increase_type

guidelines/guideline_3180_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	15	Major	G-3180: Always specify column names instead of positional references in ORDER BY clauses.	4
2	15	Major	G-3180: Always specify column names instead of positional references in ORDER BY clauses.	1
3	15	Major	G-3180: Always specify column names instead of positional references in ORDER BY clauses.	3

guidelines/guideline_3310_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	38	Critical	G-3310: Never commit within a cursor loop.	commit
2	32	Major	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.	for r_order in ( select o.order_id,o.customer_id from orders o where o.order_status = 'New' ) loop l_discount := sales_api.calculate_discount(p_customer_id => r_order.customer_id); update order_lines ol set ol.discount = l_discount where ol.order_id = r_order.order_id; l_counter := l_counter + 1; if l_counter = 100 then commit; l_counter := 0; end if; end loop new_orders
3	61	Major	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.	for r_order in ( select o.order_id,o.customer_id from orders o where o.order_status = 'New' ) loop l_discount := sales_api.calculate_discount(p_customer_id => r_order.customer_id); update order_lines ol set ol.discount = l_discount where ol.order_id = r_order.order_id; end loop new_orders

guidelines/guideline_4110_31.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Minor	G-4110: Always use %NOTFOUND instead of NOT %FOUND to check whether a cursor returned data.	not c_employees%found
2	20	Minor	G-4330: Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations.	fetch c_employees into r_employee
3	42	Minor	G-4330: Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations.	fetch c_employees into r_employee

guidelines/guideline_4130_33.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Major	G-4130: Always close locally opened cursors.	open c_department_salary(p_dept_id => in_dept_id)
2	12	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dept_id in departments.department_id%type
3	30	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dept_id in departments.department_id%type

guidelines/guideline_4385_48.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_employee_found := true
2	31	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_employee_found := c_employees%found
3	14	Major	G-4385: Never use a cursor for loop to check whether a cursor returns data.	for r_employee in c_employees loop l_employee_found := true; end loop check_employees

guidelines/guideline_5060_56.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Major	G-5060: Avoid unhandled exceptions	select department_name into l_department_name from departments where department_id = in_id
2	16	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_id in departments.department_id%type
3	32	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_id in departments.department_id%type

guidelines/guideline_7125_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Minor	G-7125: Always use CREATE OR REPLACE instead of CREATE alone.	employee_api
2	11	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type
3	32	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_employee_id in employees.employee_id%type

guidelines/guideline_7230_67.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	25	Major	G-7230: Avoid declaring global variables public.	g_salary_increase
2	33	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase in types_up.sal_increase_type
3	64	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_increase in types_up.sal_increase_type

guidelines/guideline_7740_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Minor	G-3150: Try to use identity columns for surrogate keys.	nextval
2	35	Minor	G-3150: Try to use identity columns for surrogate keys.	nextval
3	17	Minor	G-7730: Avoid multiple DML events per trigger.	insert or update on departments

guidelines/guideline_8310_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-5060: Avoid unhandled exceptions	select * into r_return from departments where department_name = in_dept_name
2	36	Major	G-5060: Avoid unhandled exceptions	select * into r_return from departments where department_name = l_dept_name
3	10	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_dept_name in departments.department_name%type

guidelines/guideline_1010_01.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	8	Minor	G-1010: Try to label your sub blocks.	begin null; end
2	12	Minor	G-1010: Try to label your sub blocks.	begin null; end

guidelines/guideline_1030_03.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Minor	G-1030: Avoid defining variables that are not used.	l_first_name
2	12	Minor	G-1030: Avoid defining variables that are not used.	e_good

guidelines/guideline_1070_07.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Minor	G-1070: Avoid nesting comment blocks.	/* comment one -- nested comment two */
2	11	Minor	G-1070: Avoid nesting comment blocks.	-- comment three /* nested comment four */

guidelines/guideline_2145_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_function_result := maintenance.get_config('parallel_degree')
2	13	Minor	G-2145: Never self-assign a variable.	l_parallel_degree := l_parallel_degree

guidelines/guideline_2220_19.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Minor	G-2220: Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.	number(5,0)
2	14	Minor	G-2230: Try to use SIMPLE_INTEGER datatype when appropriate.	number(5,0)

guidelines/guideline_2230_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Minor	G-2220: Try to use PLS_INTEGER instead of NUMBER for arithmetic operations with integer values.	number(5,0)
2	20	Minor	G-2230: Try to use SIMPLE_INTEGER datatype when appropriate.	number(5,0)

guidelines/guideline_2330_22.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Major	G-2330: Never use zero-length strings to substitute NULL.	:= ''
2	9	Minor	G-2340: Always define your VARCHAR2 variables using CHAR SEMANTIC (if not defined anchored).	varchar2(1)

guidelines/guideline_3140_29.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	17	Major	G-3140: Try to use anchored records as targets for your cursors.	into l_employee_id,l_first_name,l_last_name
2	22	Major	G-3140: Try to use anchored records as targets for your cursors.	into l_employee_id,l_first_name,l_last_name

guidelines/guideline_3170_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	23	Major	G-3145: Avoid using SELECT * directly from a table or view.	*
2	42	Major	G-3145: Avoid using SELECT * directly from a table or view.	*

guidelines/guideline_3190_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	13	Major	G-3190: Avoid using NATURAL JOIN.	natural join departments d
2	32	Major	G-3190: Avoid using NATURAL JOIN.	natural join departments d

guidelines/guideline_4220_36.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Minor	G-4220: Try to use CASE rather than DECODE.	decode(ctry.country_code, constants_up.co_ctry_uk, constants_up.co_lang_english , constants_up.co_ctry_fr, constants_up.co_lang_french , constants_up.co_ctry_de, constants_up.co_lang_german , constants_up.co_lang_not_supported)
2	18	Minor	G-4220: Try to use CASE rather than DECODE.	decode(ctry.country_code, constants_up.co_ctry_uk, constants_up.co_lang_english , constants_up.co_ctry_fr, constants_up.co_lang_french , null , constants_up.co_lang_unknown , constants_up.co_lang_not_supported)

guidelines/guideline_4375_46.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	exit process_employees
2	16	Minor	G-4375: Always use EXIT WHEN instead of an IF statement to exit from a loop.	exit process_employees

guidelines/guideline_4380_47.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	29	Minor	G-4380: Try to label your EXIT WHEN statements.	exit when l_innerlp = co_exit_value
2	32	Minor	G-4380: Try to label your EXIT WHEN statements.	exit when l_innerlp = co_exit_value

guidelines/guideline_5030_52.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Blocker	G-5030: Never assign predefined exception names to user defined exceptions.	no_data_found exception;
2	26	Critical	G-5070: Avoid using Oracle predefined exceptions	raise no_data_found

guidelines/guideline_7110_60.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-7110: Try to use named notation when calling program units.	r_employee
2	14	Major	G-7110: Try to use named notation when calling program units.	co_id

guidelines/guideline_7170_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_wait in integer
2	58	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	in_wait in integer

guidelines/guideline_7710_77.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-7710: Avoid cascading triggers.	departments_hist
2	43	Major	G-7710: Avoid cascading triggers.	departments_hist

guidelines/guideline_7720_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Blocker	G-7720: Never use multiple UPDATE OF in trigger event clause.	update of department_id
2	12	Minor	G-7730: Avoid multiple DML events per trigger.	update of department_id or update of department_name on departments

guidelines/guideline_7810_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_sequence_number := employees_seq.nextval
2	11	Major	G-7810: Never use SQL inside PL/SQL to read sequence numbers (or SYSDATE).	employees_seq.nextval

guidelines/guideline_8120_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-8110: Never use SELECT COUNT(*) if you are only interested in the existence of a row.	count(*)
2	19	Major	G-8120: Never check existence of a row to decide whether to create it or not.	l_count = 0 then insert into departments values in_r_department;

guidelines/guideline_na_54.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	date_in in date
2	50	Minor	G-8310: Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.	date_in in date

guidelines/guideline_0000_00.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Minor	G-2140: Never initialize variables with NULL.	l_value pls_integer := null;

guidelines/guideline_1060_06.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Major	G-1060: Avoid storing ROWIDs or UROWIDs in database tables.	rowid

guidelines/guideline_1080_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Minor	G-1080: Avoid using the same expression on both sides of a relational comparison operator or a logical operator.	emp.salary > 3000 or emp.salary > 3000

guidelines/guideline_2110_08.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-2110: Try to use anchored declarations for variables, constants and types.	l_last_name varchar2(20 char);

guidelines/guideline_2120_09.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Minor	G-2120: Try to have a single location to define your types.	subtype big_string_type is varchar2(1000 char);

guidelines/guideline_2135_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	19	Major	G-2135: Avoid assigning values to local variables that are not used by a subsequent statement.	l_message := 'Hello, ' \|\| l_last_name

guidelines/guideline_2140_11.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	8	Minor	G-2140: Never initialize variables with NULL.	l_note big_string_type := null;

guidelines/guideline_2150_12.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Blocker	G-2150: Avoid comparisons with NULL value, consider using IS [NOT] NULL.	l_value = null

guidelines/guideline_2160_13.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Critical	G-2160: Avoid initializing variables using functions in the declaration section.	l_department_name departments.department_name%type := department_api.name_by_id(in_id => co_department_id);

guidelines/guideline_2170_14.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	17	Major	G-2170: Never overload variables.	l_variable

guidelines/guideline_2190_17.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-2190: Avoid using ROWID or UROWID.	rowid

guidelines/guideline_2210_18.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Minor	G-2210: Avoid declaring NUMBER variables, constants or subtypes with no precision.	number

guidelines/guideline_2310_20.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-2310: Avoid using CHAR data type.	char(200)

guidelines/guideline_2320_21.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-2320: Never use VARCHAR data type.	varchar(200)

guidelines/guideline_2340_23.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Minor	G-2340: Always define your VARCHAR2 variables using CHAR SEMANTIC (if not defined anchored).	varchar2(200)

guidelines/guideline_2610_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Minor	G-2610: Never use self-defined weak ref cursor types.	type local_weak_cursor_type is ref cursor;

guidelines/guideline_3110_26.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	8	Major	G-3110: Always specify the target columns when coding an insert statement.	insert into departments values ( departments_seq.nextval ,'Support' ,100 ,10)

guidelines/guideline_3115_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Minor	G-3115: Avoid self-assigning a column.	first_name = first_name

guidelines/guideline_3130_28.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Minor	G-3130: Try to use ANSI SQL-92 join syntax.	employees e ,departments d

guidelines/guideline_3145_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	19	Major	G-3145: Avoid using SELECT * directly from a table or view.	*

guidelines/guideline_3150_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	26	Minor	G-3150: Try to use identity columns for surrogate keys.	nextval

guidelines/guideline_3185_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	17	Major	G-3185: Never use ROWNUM at the same query level as ORDER BY.	rownum

guidelines/guideline_3195_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	15	Minor	G-3195: Always use wildcards in a LIKE clause.	e.last_name like 'Smith'

guidelines/guideline_3210_30.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Major	G-3210: Always use BULK OPERATIONS (BULK COLLECT, FORALL) whenever you have to execute a DML statement for more than 4 times.	for i in 1..t_employee_ids.count() loop update employees set salary = salary + (salary * co_increase) where employee_id = t_employee_ids(i); end loop process_employees

guidelines/guideline_3220_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	22	Major	G-3220: Always process saved exceptions from a FORALL statement.	forall i in 1..t_employee_ids.count() save exceptions update employees set salary = salary + (salary * co_increase) where employee_id = t_employee_ids(i)

guidelines/guideline_4120_32.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	26	Critical	G-4120: Avoid using %NOTFOUND directly after the FETCH when working with BULK OPERATIONS and LIMIT clause.	c_employees%notfound

guidelines/guideline_4210_35.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Major	G-4210: Try to use CASE rather than an IF statement with multiple ELSIF paths.	if l_color = constants_up.co_red then my_package.do_red(); elsif l_color = constants_up.co_blue then my_package.do_blue(); elsif l_color = constants_up.co_black then my_package.do_black(); end if

guidelines/guideline_4230_37.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	10	Critical	G-4230: Always use a COALESCE instead of a NVL command, if parameter 2 of the NVL function is a function call or a SELECT statement.	nvl(dummy,my_package.expensive_null(value_in => dummy))

guidelines/guideline_4240_38.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Critical	G-4240: Always use a CASE instead of a NVL2 command if parameter 2 or 3 of NVL2 is either a function call or a SELECT statement.	nvl2(dummy,my_package.expensive_nn(value_in => dummy) ,my_package.expensive_null(value_in => dummy))

guidelines/guideline_4250_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-4250: Avoid using identical conditions in different branches of the same IF or CASE statement.	constants_up.co_red

guidelines/guideline_4260_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Minor	G-4260: Avoid inverting boolean conditions with NOT.	not l_color

guidelines/guideline_4270_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	13	Minor	G-4270: Avoid comparing boolean values to boolean literals.	l_is_valid = true

guidelines/guideline_4325_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	14	Major	G-4325: Never reuse labels in inner scopes.	<<my_label>>

guidelines/guideline_4330_41.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Minor	G-4330: Always use a CURSOR FOR loop to process the complete cursor results unless you are using bulk operations.	fetch c_employees into r_employee

guidelines/guideline_4340_42.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	27	Minor	G-4340: Always use a NUMERIC FOR loop to process a dense array.	i > t_employees.count()

guidelines/guideline_4350_43.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-4350: Always use 1 as lower and COUNT() as upper bound when looping through a dense array.	t_employees.first()..t_employees.last()

guidelines/guideline_4360_44.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	28	Minor	G-4360: Always use a WHILE loop to process a loose array.	1..t_employees.count()

guidelines/guideline_4365_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	13	Major	G-4365: Never use unconditional CONTINUE or EXIT in a loop.	continue process_employees

guidelines/guideline_4390_49.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	23	Major	G-4390: Avoid use of unreferenced FOR loop indexes.	for i in co_lower_bound..co_upper_bound loop sys.dbms_output.put_line(l_row \|\| co_delimiter \|\| l_value); l_row := l_row + co_row_incr; l_value := l_value + co_value_incr; end loop for_loop

guidelines/guideline_4395_50.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Minor	G-4395: Avoid hard-coded upper or lower bound values with FOR loops.	1..5

guidelines/guideline_5020_51.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Critical	G-5020: Never handle unnamed exceptions using the error number.	when others then if sqlcode = co_no_data_found then null; end if;

guidelines/guideline_5040_53.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	21	Major	G-5040: Avoid use of WHEN OTHERS clause in an exception section without any other specific handlers.	when others then my_package.some_further_processing();

guidelines/guideline_5050_55.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	18	Major	G-5050: Avoid use of the RAISE_APPLICATION_ERROR built-in procedure with a hard-coded 20nnn error number or hard-coded message.	raise_application_error(-20501,'Invalid employee_id')

guidelines/guideline_5070_57.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	16	Critical	G-5070: Avoid using Oracle predefined exceptions	raise no_data_found

guidelines/guideline_6010_58.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-6010: Always use a character variable to execute dynamic SQL.	execute immediate 'select employees_seq.nextval from dual' into l_next_val

guidelines/guideline_7140_63.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	19	Major	G-7140: Always ensure that locally defined procedures or functions are referenced.	function my_func return number

guidelines/guideline_7210_65.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Minor	G-7210: Try to keep your packages small. Include only few procedures and functions that are used in the same context.	example_pkg

guidelines/guideline_7310_69.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Minor	G-7310: Avoid standalone procedures – put your procedures in packages.	my_procedure

guidelines/guideline_7320_70.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	20	Major	G-7320: Avoid using RETURN statements in a PROCEDURE.	return

guidelines/guideline_7410_71.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Minor	G-7410: Avoid standalone functions – put your functions in packages.	my_function

guidelines/guideline_7440_74.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	9	Major	G-7440: Never use OUT parameters to return values from a function.	out_date out date

guidelines/guideline_7450_75.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	11	Major	G-7450: Never return a NULL value from a BOOLEAN function.	return null

guidelines/guideline_7510_76.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-7510: Always prefix Oracle supplied packages with owner schema name.	dbms_output.put_line(co_hello_world)

guidelines/guideline_7730_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	17	Minor	G-7730: Avoid multiple DML events per trigger.	insert or update on departments

guidelines/guideline_8110_78.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	15	Major	G-8110: Never use SELECT COUNT(*) if you are only interested in the existence of a row.	count(*)

guidelines/guideline_8210_79.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	19	Major	G-8210: Always use synonyms when accessing objects of another application schema.	oe.products

guidelines/guideline_8510_na.sql overview

Issue#	Line	Severity	Message	Code Excerpt
1	12	Major	G-4385: Never use a cursor for loop to check whether a cursor returns data.	for emp_rec in ( select employee_id from employees order by employee_id ) loop null; -- some processing end loop employees