How to use group functions in the select clause using oracle?
No Answer is Posted For this Question
Be the First to Post Answer
when do u go for hash partitioning?
How to assign query results to variables?
Does facebook use oracle?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
6. Display the client name and order date for all orders using the traditional method.
What are the ways tablespaces can be managed and how do they differ?
What are the benefits of ordbms?
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
Explain an index segment?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is the difference between Delete, Truncate and Drop in Oracle?