How to use subqueries in the from clause in oracle?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
Which is faster join or subquery in oracle?
What is the diff between Oracle and SQL Server
What is Oracle table?
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 to define a cusotmer as a supplier in ORACLE R12
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
Maximum how many triggers can be updated in table ?
5 Answers Accenture, Cap Gemini,
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Differentiate between TRUNCATE and DELETE?