0
select unique(it is an constraint)
hi folks
for returning the different values we have to use ths keyword "unique" so it provide the distinct values and we don't have the key word like"distinct"
eg: create table <tab_name>( name varchar2(12), no number unique);
from the above syntax we can predict the result by inserting the record's into the table.
in the above syntax the constraint "unique" specify that user has to not to insert duplicate records if user is trying to insert duplicate records it will pop up error like
"you are violating unique constraint. "
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
Multiple values for the same set of numbers mean median or mode?
Any set of numbers can have only one mean and only one median but it can have as many modes as it has values.
What is wrong with this statement the correlation between olympic gold medal times for the 800m hurdles and year is -66 seconds per year?
866
Why use process statement in vhdl?
Almost all programming languages are sequential in nature. But VHDL is a concurrent language. In an architecture for an entity, all statements are concurrent. So where do sequential statements exist in VHDL?. There is a statement called the process statement that contains only sequential statements. The process statement is itself a concurrent statement. A process statement can exist in an architecture and define regions in the architecture where all statements are sequential. A process statement has a declaration section and a statement part. In the declaration section, types, variables, constants, subprograms, and so on can be declared. The statement part contains only sequential statements. Sequential statements consist of CASE statements, IF THEN ELSE statements, LOOP statements, and so on.
Do extremely high or low scores affect the value of the median?
No, extremely high or low values will not affect the median. Because the median is the middle number of a series of numbers arranged from low to high, extreme values would only serve as the end markers of the values.
Is income discrete or continuous?
Income is discrete. People can have only a finite number of possible income values.
Difference in using a method that return value and method that does not return value in object orinted programming?
A method that return a value should have a return statement. The method signature should indicate the type of return value. While in the case of a method that does not return a value should not have a return statement and in the signature, the return type is void. When using a method that doesn't return a value, a programmer can not get a value from that function, but instead, it can only change variable values and run other methods.
Write a program to return a function using class in C Plus Plus?
Classes cannot return values, only functions can return values. But you cannot return a function from a function, you can only return a function pointer -- a pointer variable holding the address of the function you wish to return. All possible return values must be of the same type, therefore all function signatures and return types must be exactly the same -- only the name of the functions can differ.
How many values at the most can be returned to the calling function through a single return statement?
It depends on the language. Python, for instance, can return any number of values. However, it's best to keep the number of return values as low as possible for the sake of simplicity and readability. Most languages only allow one return value at most, but languages that allow you to create new types (classes or structures) also allow you to return multiple values through objects of those types. That is, an object is just one value, but it may have one or more member objects or values embedded within. Failing that, if the language provides a "tuple" type then you can use that. If the return values are of the same type then you can also return multiple values via an array, or a pointer to an array, or a list, or any other sequence container provided by the language.
Why is return statement not necessary when function is called by reference?
return is not necessary if the return type is void, and you want to leave the function only at its end.
Why function should return a value?
Not all functions return values. If you take a function which is of type void, you get a function which is does not return anything. The only functions which should return values are those which are used as a right side of expressions (so called rvalues).
Is it possible to place a return statement anywhere in 'C' program?
No. Return statements can only appear within a function body, but they can be placed anywhere within that body. If the function returns a value, then the return statement must also return a value of the same type.
Does sales return and allowances go on the statement of earnings?
--> another term for Statement of Earnings is Income Statement --> in income statement, you deduct the Sales Return & Allowances from the Gross Sales to come up with Net Sales --> in presentation purposes, usually it is only the Net Sales account that is shown
The set of values that makes a statement true?
If the statement is a mathematical equation, than those values are its "solutions". The number of them depends on the equation. There may be only one, more than one, or no solutions at all.
How many values you can return by call by value and call by reference at a time?
A function can only return one value, but it can modify its parameters if their type is 'in out' or 'out'.
How does biconditional statement different from a conditional statement?
a condtional statement may be true or false but only in one direction a biconditional statement is true in both directions
In SQL what does the 'INSERT INTO' statement mean?
IN SQL, the statement 'INSERT INTO' means to insert single or multiple records into a table. There are two possible ways to write the 'INSERT INTO' statement. The first way does not specify column names and only specifies the values. The second way specifies both the column names and the values.
Can you return multiple values from a function in C?
There are many approaches to this 'problem'. Since a C function is only allowed to return one value as the name of the function you have to provide parameters to the routine if you want multiple values to be returned.For example, traditionally you return a value thus:int Today () ;if (Today() == 2) ....int Today (){/* Some logic */return value ;}So if you want multiple values, send parameters to the routine that can be changed:int Today (int * val1, int * val2, char * charValue) ;Then, call it:int first ;int second ;char third ;if (Today (&first, &second, &third) == 2)In this case first, second, and third can be changed inside the Today routine and return multiple values.int Today (int * val1, int * val2, char * charValue){*val1 = 5 ;*val2 = 10 ;*charValue = 'Y' ;return 2 ;}
