How and in what way REPLACE is different from TRANSLATE?
Latest Answer: Replace and Translate both works with three argumentreplace(arg1,arg2,arg3)translate(arg1,arg2,arg3)the inbuilt function "Replace" replace the arg2 with arg3. it replaces the whole strig.while the inbuilt function "Translate" replace ...
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: By using rowid we can elminate the duplicate records in a tableDELETE FROM TABLE_NAME WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM TABLE_NAME GROUP BY COLUMN_NAME); ...
Latest Answer: Syntax:--------Alter table add after ;Example:-----------Alter table employee add age int after emp_name; ...
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. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
