What Is PL/SQL Language Case Sensitive

Home > Oracle > PL/SQL

Q

What Is PL/SQL Language Case Sensitive? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: FYIcenter.com

A

PL/SQL language is not case sensitive:

Reserved words are not case sensitive. For example: CASE and Case are identical.
Variable names and other names are not case sensitive. For example: TOTAL_SALARY and total_salary are identical.

But values in string literals are case sensitive. For example: 'DBA' and 'dba' are different.

2007-05-01, 4979👍, 0💬

How To Find Out What Privileges a User Currently Has
How To Find Out What Privileges a User Currently Has? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on tho... 2007-05-01, 5331👍, 0💬

What Is a Named Program Unit
What Is a Named Program Unit? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is... 2007-04-30, 5205👍, 0💬

How To Place Comments in PL/SQL
How To Place Comments in PL/SQL? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are two ways to place comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you... 2007-05-01, 5174👍, 0💬

What Are the Types PL/SQL Code Blocks
What Are the Types PL/SQL Code Blocks? - Oracle DBA FAQ - Understanding PL/SQL Language Basics There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of code... 2007-05-01, 5111👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Understanding PL/SQL Language Basics A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defin... 2007-04-30, 5092👍, 0💬

What Is PL/SQL Language Case Sensitive
What Is PL/SQL Language Case Sensitive? - Oracle DBA FAQ - Understanding PL/SQL Language Basics PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and... 2007-05-01, 4980👍, 0💬

What Privilege Is Needed for a User to Create Indexes
What Privilege Is Needed for a User to Create Indexes? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise g... 2007-05-01, 4573👍, 0💬

What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema
What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to delete rows from tables of someone else's schema, he/she needs the DELETE ANY TABLE privilege. The following tutorial exercise gives... 2007-05-01, 4545👍, 0💬

What Privilege Is Needed for a User to Query Tables in Another Schema
What Privilege Is Needed for a User to Query Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercis... 2007-05-01, 4519👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.