there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?12 12727
Differences between UNIQUE and DISTINCT in select statements26 118504
What are the attributes of SQL*PLUS ?2 7937
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.13 14387
i want to display 1 to 10 numbers using one select statement.18 31068
why use cursors?5 8849
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c8 9151
What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?9 13021
How can i insert data inro a table with 3 columns using FORALL?2 8678
what is autonomouse transaction?3 5714
what are pl/sql collections?4 27564
How to create a view on a table which does not exists4 16506
how to write utl file pkg in SQL1 4677
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?4 16428
what is the difference difference between procedure and packages2 7680
why the pic micro controller have internal eeprom?But in 8051 have only rom and ram.
Tell me what are the disclosures required in telemarketing? : insurance cold calling
Tell me what is applique?
List the type of locks?
Mention what is the difference between kernels, support packages & sap note?
can you explain about configuration files?
What is Comp-2?
What does socket consist of?
Clear property is available in ____,___ control.
Which property is used to add or subtract space between the letters that make up a word?
What is difference between static class and normal class?
Write code for the following in ASP a)Display attributes of a file b) File copy c) get disk capacity.
How to change postgresql root user password?
what is an extended stored procedure? : Sql server database administration
whatis the commertial spec. of distribution boards ?