Question

What does it mean to make user classes in SQL?

Answer 1

We can create classes in sql.Those are called as user classes in SQL.

These can be entire SQL programs or some other fragments to re-use the classes.

• In SQL, user class allow iterate over all rows that are fetched.
• In SQL query ,we give a bulk mode of operations,so the query will execute ,more no of times.
• So,By using user classes we can reduce the time and space .

Considerations of Extra Spaces:-

• when extra spaces are need in sql query,then user defined classes are used here.
• Then we can reduce some space in the sql database.or query.

Considerations of Case sensitivity:-

• when we are processing a sql query or statement ,the system automatically converts all field names to Uppercase letters.
• we can prevent lower to upper by using the user class.
• use %Nouppercase meta-SQL statement at the beginning of the sql query.