Data types in sql, PL-SQL Programming

Data Types in SQL

SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates type with the term domain used in much of the relational database literature. SQL is at odds with this equation because it uses domain for a defined subset of a given type that is not itself a type. For example, the domain WEEKDAY might be defined to consist of the values 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', and 'Saturday', but the declared type of a column defined on that domain is that on which the domain itself is defined, perhaps VARCHAR(9). Also, whereas a domain is defined by specifying a constraint (on some underlying type), a constraint cannot be used to specify a user-defined type.

Posted Date: 1/18/2013 1:55:02 AM | Location : United States







Related Discussions:- Data types in sql, Assignment Help, Ask Question on Data types in sql, Get Answer, Expert's Help, Data types in sql Discussions

Write discussion on Data types in sql
Your posts are moderated
Related Questions
Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Write a stored procedure that accepts the post code in which the customer resides as the input parameter. The procedure should then use an explicit cursor to display comprehensive

1- You can check attribute names from each table in DBF11 by running for example:  desc dbf11.Member;  desc dbf11.Agent;  desc dbf11.Producer; Because some attribute names in

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

INSERT Statement The INSERT statement adds fresh rows of data to the specified database table or view. Syntax:

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so