What are Column Level Constraint and Table Level Constraint? How do they differ from one another?
Latest Answer: Table level constraint:Ex: create table emp(empno integer,ename varchar(20),deptno integer,primary key(empno))column level constraint:create table emp(empno integer primary key,ename varchar(20),deptno integer)In table level need create constraint ...
Latest Answer: Assume 'location' is the column in 'Emp' table has several duplicatesEMPEmp_Id varchar(10)Location varchar(12) you can remove the duplicates using 'union' select location from emp ...
Latest Answer: Syntax : - Alter Table ADD Column ( [size1], [size2], ...);Example : - Alter Table Employee ADD Column (Address2 Varchar2(28),Phone2 Number(6)); ...
ID employee department manager----------------------------------------------1 Suresh c++ NULL 2 Suresh c++ NUll3 Suresh c++
Latest Answer: SELECT e.ename as Manager, m.ename as Employee FROM emp e, emp m WHERE e.MGR = m.EMPNO ...
What is a SET operator? What are the types what is the difference between SET operators and JOINS?
Latest Answer: SET operators are used to combine similar type of data from two or more tables. The no of columns and their data type must be same in all the queries. The column names from the first query will appear in the result.UNION ...
How will you establish many to many relationship in SQL?Ramco Systems dt. 02 Feb' 2008
Latest Answer: Cartesian product is an example for many to many reolationship in SQL.For exampleselect a.ename, a.job, a.sal, b.dname from emp a, dept bresults in many to many relationship. ...
There is a table with Pluks('plk') and Zinks ('zin'). Each Pluk onlyresides on a single Zink and each Zink may contain multiple Pluks. Howdo you find how many Pluks are on each and
Latest Answer: Dead lock is a unique situation in multiuser system that causes two or more users to wait indefinately for a locked resource. First user needs a resource locked by the second user and second user needs the resource locked by the first user.To avoid ...
What is SQL Tuning? How does it work? Thanks
Latest Answer: SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time ...
I'm using oracle9i to create a table which stores lyrics in long datatype. But if i store a long string of text and display it from the table, it displays only 80 chars. So someone help me how to
Latest Answer: Variable length character values up to 2 gigabytes. Only one LONG column is allowed per table. You cannot use LONG datatype in functions, WHERE clause of SELECT, in indexing and subqueries. ...
Latest Answer: What I understood from your question is that you want to comma seperate the values of a particular column for its different rows. If this the question then query will beDECLARE @SQL AS VARCHAR(500)SELECT @SQL = ISNULL(@SQL,' ')+',' ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
