2 Answered Questions for the topic oracle11g

06/25/19

Oracle DB: delete all the contents?

I have oracle DB it is for testing purpose, I have not added any tables. I just want clear all the files like control, redo, archive, date. Ultimately I want fresh db. I know it can done by delete... more

06/25/19

Oracle - If variable is null?

I need to return some dummy select when my variable matches string. This is what I tried: begin if :someVar = 'Yes' then select 1 from dual; end if; end; / I've tried... more

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.