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 8490i 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 15670can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
5 6911why 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 5609how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
UST,
11 15628
How do I enable sql encryption?
Explain spool.
How to select all records from the table?
Is full outer join same as cross join?
What packages(if any) has oracle provided for use by developers?
How many developers work on postgresql?
Which sql most popular?
What do you mean by table in sql?
what is heap table? : Sql dba
What is memory optimized table?
Can we perform dml on view?
What are the different tcl commands in sql?
What is the difference between sum and count in sql?
Can sql developer connect to db2?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?