Explain the types of joins in sql?
What is blind sql injection?
using comand prompt how can import table data and table space with example
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
what are the advantages of package?
How do you update f as m and m as f from the below table testtable?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
What is mutating table?
Does a join table need a primary key?
Why truncate is faster than delete?
how to show all tables with 'mysql'? : Sql dba
How do you go back in sql?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.