How a database is related to tablespaces?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What are the different types of database objects?
How to remove a row in a database table?
What is Index and different types of Indexes?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What do database buffers contain?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
How to use subqueries with the exists operator in oracle?
Why do we need oracle client?
How do I call oracle stored procedures that take no parameters?
What happens to the current transaction if a ddl statement is executed?
What is the difference between substr & instr functions?