Posts by debasisdas

410

Of course you can ask for that my dear.

That will be delivered to with complementary gift wrapping with a scented red rose.

The only thing you need to conform is how are you going to pay for my service.

As i have said earlier , that would depend on what the procedure is doing.

for example if your procedure is doing some data processing test it against Hugh data, definitely you will get some difference in execution time.

I really do not understand what do you mean by -- I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data.

Welcome to Daniweb.

Hi luijean,

Welcome to Daniweb.

I think USA has a team, but they could not qualify for the event.

A person who wants nothing can never be defeated.

Yes you can.

Simply print system time at the beginning of the Procedure (before any looping or conditional branching) and once again at the end . and check the difference.

You are guilty of two counts.

1. Digging a dead thread / Hijacking others thread.
2. Not showing any effort.

Suggestion :-

1. Start a new thread for your own question.
2. shows some effort and post the code that you are working on.

and what is the query ?

in which part you are going to use relational algebra ?

Welcome to Daniweb.

This section is for general introduction of new members only.

Kindly post your question in the proper section of the forum.

Welcome to Daniweb.

Hi Garth,

Welcome to Daniweb.

Hi Billy,

Welcome to Daniweb.

Welcome to Daniweb.

426

I suspect a relation is broken accidentally.

Welcome to Daniweb.

This section is for general introduction of new members only.

Kindly post your question in the sub section of this section
depending on your database.

When you say, i consider you want to run the query dynamically on different field names.

If that is the case then, you need to maintain a flag, along with the input parameter and based on the value of the flag frame the query dynamically and execute.

if p_flag=1 then
SELECT * FROM person where lastname = @p_val;
else if p_flag=2 then
SELECT * FROM person where firstname = @p_val;
.......
......
end if;

1. find out he position of last "\" from right side.
2. add 1 to that value (+ 1)
3. find out the string from this position till the end of the string.

You want to select the items in the same row, not the same item ?

To succeed in life, you need three things: a wishbone, a backbone and a funnybone. ~Reba McEntire

Welcome to Daniweb to both jassaal and martin..

Welcome to Daniweb.

I don't understand why you need to use any division operator and why you need any relational algebra.

Kindly post the query that you are working on.

444

Lets eat, sleep and live cricket.

I am with my home team, they are the hot favorites.

Execution time is independent of lines of code.
It may happen that a procedure has 1000 lines of code because of a long running IF ELSE but the line 10 to 1000 never gets executed.

It depends on what the code is actually doing.

448

The screen shot shows the SCOTT account was not unlocked during installation.

1.login to the system account (password setting for this is compulsary,so you would have done that).
2.unlock the scott account.
3.change the password to what ever you want.

Start using.

to use sql developer, browse and set the path to javaw.exe (it will bw available under oracle home directory--bin sub directory)

You need to login at console only or else use the SQL Developer.

SQL * PLUS is not shipped with 11g anymore.

Check if your database service is up and running.

ListboxName.AddItem string -----this is a method

and set the Sorted property to True

Use the above hint and post back here what code you comeup with.

Do not expect us to guess and solve your problem.

Please pass more information.

Hi Rohit,

Hope you have a nice time here in the forum.

454

Hi Tommy ,

Welcome to Daniweb.

Our body needs peace of mind and is not suited to agitation.
This shows that an appreciation for peace of mind is in our blood.

--
H. H. Dalai Lama

Welcome to you as well.

@Vineeth

If a form is not visible (hidden), that does not mean the form is not loaded.

Why you need to re-invent the wheel !

All windows machines which are part of a domain works exactly this way.

User details are maintained in active directory.

A big welcome.

Please do not hijack others thread

Please start a new thread of your own.

On which event this code is being called ?

Welcome Timmo,

Nice simple intro.

Welcome to Daniweb.

HI Ayse,

Welcome to Daniweb.

We are pleased to have you around.

Welcome to Daniweb.

What do yo expect a single line solution ?

The codes provided in the links is straight forward. It is lengthy because of long running IF and CASE statements.