Explain joins in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are the different type of segments?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
what is the difference between first normal form & second normal form?
Why do we need oracle client?
How to call a sub procedure?
Why do we use coalesce function in oracle?
How to view the dropped tables in your recycle bin?
How to delete an existing row from a table in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?