Posts by debasisdas

Why not solve that using a Procedure instead.

506

The art of living is more like wrestling than dancing.

You need to read this.

No 11i is not a database like 11g.

You need to position the control by resting its X, Y co-ordinates using trigonometric functions SIN and COS.

You need to connect to SMS gateway for that.

Contact your telecom service provider for details.

All that does not come free like mailing service.

Hi Abellac,

Welcome to Daniweb.

But i am sure you are definitely not new to everything :)

Hi Rob,

Welcome to Daniweb.

Hi Sam,

Welcome to Daniweb.

Hi Brad,

Welcome to Daniweb.

Welcome to Daniweb.

Welcome to the forum.

What you said is very true, there is really no age bar for learning.

Hope you have a nice time learning new things.

Final year of which course ?

What did google suggest ?

^ lived in 2010.
< living in 2011.
V will live in 2012 also.

The first rule is, there is no rule.

Please find the details here and here.

In oracle object names are not case sensitive (if not used inside quotes).

you need to find a function for the purpose.

I think what you are looking for is Merge statement.

http://psoug.org/reference/merge.html

404

First of all that version of oracle is desupported.

If you still want that read some oracle 8i books, it is not possible to describe all that here.

Give us Lord, a bit o' sun,
A bit o' work and a bit o' fun;
Give us all in the struggle and sputter
Our daily bread and a bit o' butter.

You need to write password protected macros for that .

What did Google suggest ?

268

what exactly is the script that is throwing the above error message ?

can you post the exact syntax that you are using for reference of our experts.

To answer your question is beyond the scope of this discussion.

You need to read books for all those clarifications.

Life is simple, it's just not easy.

Success is the ability to go from one failure to another with no loss of enthusiasm.

The answer is a big NO.

But there are couple of work around for the solution.

You need to take and export of the schema and import the same into the target system.

you need to use the following commands for the purpose.

EXP
IMP

please find the details here , here and here.

my dear, you need to read books for that.

Do your home work yourself.

641

^
enjoys pepsi.

< don't like pepsi.

may prefer coke.
V

nude ---> naughty

405

No need to drop entire database , you simply need to drop the desired tables.

why not drop the schema then .

You need to use a counter in the button click and based on the counter value decide what is displayed in the textbox.

You need to drop all the tables.

Drop child table first and then the parent table.

try the following sample code.

MsgBox("Do you really wish to quit this program ?", vbOKCancel + vbQuestion, "Confirmation")

What exactly you are doing ?

Are you committing the transactions ?

You need to use the function Replace.

655

you need to delete records of child tables first and then the related parent tables.

You need to read this and this .

What exactly you want to alter ?

to drop the constraints you need to break the connenction to other tables.