NULLNOT NULLCHECKDEFAULT
Latest Answer: The Constraints are Primary Unique Check Null ...
TRUNCATE deletes much faster than DELETETRUNCATEDELETEIt is a DDL statementIt is a DML statementIt is a one way trip,cannot ROLLBACKOne can RollbackDoesn't have selective features (where clause)HasDoesn't
Latest Answer: DELETE is a DML command so it works on row level, where TRUNCATE is a DDL command, so it works on object level, TRUNCATE actually deletes the table and recreates it, so whatever people say that it works faster or frees occupied space or high water mark ...
TABLESVIEWSINDEXESSYNONYMSSEQUENCESTABLESPACES etc
Latest Answer: In Oracle DB Objects are Table View Indexes Sequences Used to generate primary key values Synonym ...
'' Should be used before '%'.
Latest Answer: select * from emp where instr('ename','%')!=0 ...
Suppose there are two fields in table(Employee) say Name and Salary and there are in total 100 records in table. Now my query gives the name of an employee whose salary is 10th among 100 salaries. this query should be solve in SQL not in PL/SQL
SQL> select sal, (to_char(to_date(sal,'j'), 'jsp'))from emp;the output like,SAL (TO_CHAR(TO_DATE(SAL,'J'),'JSP'))--------- -----------------------------------------------------800
Latest Answer: In order to display the number values , the best it can be done is with the julian i.e. j and jsp. however, using the translate also returns the same value for whatever value to display.select to_char(to_date(1920,'j'),'jsp') from dual; ...
INSTR('120000 12 0 .125',1,'.')output 13
Latest Answer: select instr('1200023.56', '.') from dual; ...
Yes
Latest Answer: Yes, called as composite primary key ...
Latest Answer: Assume there is an emp table with 3 columns (ename, sal, dept)
DELETE FROM emp
WHERE rowid > ANY (SELECT rowid
FROM emp e2
WHERE e2.ename = e1.ename
AND e2.sal = e1.sal
AND e2.dept = e1.dept);
OR
DELETE FROM emp a
WHERE EXISTS (
SELECT 'true'
FROM ...
Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?
SELECT customer_no, payments from customer C1WHERE 3
View page << Previous 8 9 10 11 [12] 13 14 15 16 17 Next >>
Go Top
