Latest Answer: scott@8i> create database link ora8idev 2 connect to scott 3 identified by tiger 4 using 'ora8idev' 5 /Database link created.scott@8i> select * from dual@ora8idev;D-Xscott@8i> ...
Latest Answer: select a.*, level from emp astart with mgr is nullconnect by mgr = prior empno; ...
Latest Answer: use the following syntex for drop the columnalter table emp drop column ename; ...
Display the records between two range I know the nvl function only allows the same data type(ie. number or char or date Nvl(comm, 0)), if commission is null then the text “Not Applicable” want to display, instead of blank space. How do I write the query
Latest Answer: Cursor_already_open, Invalid_cursor ...
Latest Answer: select .nextval from dual;select .currval from dual;orselect * from user_sequences where sequence_name = ;here last_number is your currval and last_number + increment_by is your nextval ...
Latest Answer: Hi All,INSTR function finds the numeric starting position of a string within a string.As eg.Select INSTR('Mississippi','i',3,3) test1, INSTR('Mississippi','i',1,3) test2, ...
Latest Answer: Hi Rampratap, U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?Thanks Pratima ...
Latest Answer: Alter table modify constraint < constraintname> disable/enableexamplealter table CONTACT_US modify constraint CONTACT_US_UK disable; ...
Latest Answer: Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
