Can u please explain me the
Discussion on Except ,using cast like type cast. Question in
the context of difference between two tables
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
What is Oracle table?
How do you ensure database security?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
how to retrieve daily sal from emp table in oracle 10g
How many types of synonyms in Oracle?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
what is reindexing?
What is the Tune Query
Difference between cartesian join and cross join?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
What are the common oracle dba tasks?