If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)5 6952
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.11 13089
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)5 5654
Please let me know if UNION ALL and Natural Join does the same operation and are same...7 11082
With out using count() function. How to the find total number of rows in a table?6 9296
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.2 4816
why should required for Indexed by table in pl/sql3 5423
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
What is set transaction?
Why is pl sql used?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is the file extension for sql database?
How can you tell the difference between an index and a view?
what are properties of a transaction? : Sql dba
What is the use of primary key?
Which join is like inner join?
What is database white box testing and black box testing?
Why having clause is used in sql?
What is sqlite format?
List and explain the different types of join clauses supported in ansi-standard sql?
What is cursor in pl sql?
what is uncommittable transactions? : Transact sql
Can we create table in function?