Question { iFlex, 27567 }

what is difference between procedure and function,
procedure and trigger?

Answer

functions and procedures:
1.Functions Returns a value, procedure not return a value.
2.parsed & compiled at runtime, Procedure stored as a
pseudo code in database ie. Compiled form.
3.Cannot effect the state of database,sp effect the state
of database using Commit etc..
4.mainly used to compute the values, sp used to process the
tasks.
5.It can be invoked from sql statement :eg:select, sp can
not invoked.
6.it is not accept more than one argument.sp accept more
than one argument.

Trigger and procedure:

1.It is run Automatically , sp run it manually.
2.With in a trigger u can call the sp, with in a sp u can
not call the trigger.
3.when u r creating the trigger u have to identify event
and action of your trigger. not possible in sp.
4.Trigger not pass the arguments but sp pass the arguments.

Question { IBM, 10667 }

suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?

Answer

SQ--->AGG SEQ
SOURCE ----->JOINER---->ROUTER---->TARGET1 AND TARGET2
SQ--->EXP


HERE AGG:1. CT---[O]--->COUNT(EMPNO)
2. NEWPORT---[O]--->1

EXP:1.NEWPORT----[O]---->1

JOINER:NEWPORT(EXP)=NEWPORT(AGG)

ROUTER: GROUP1--->NEXTVAL<=ROUND(CT/2)
GROUP2--->NEXTVAL>ROUND(CT/2)

Question { TCS, 26173 }

How can i send first half of the records to one target and
Remaining to other target?

Answer

Here

SOURCE------>SQ--->AGG---> SEQ\ /T1
----->JOINER----->ROUTER----
SOURCE------>SQ--->EXP---> \T2


THIS IS THE PROCESS
HERE AGG--->TWO PORTS 1)NEW PORT 2)COUNT PURPOSE
EXP---->1)NEW PORT ONLY
JOINER-->COMPARE TO THE (AGG & EXP) NEW PORTS AND
APPLY THE FULL JOIN
ROUTER--->TWO CONDITIONS

Question { 9646 }

"pravalli nagireddy" record is there in address column but i
want display only 'nagireddy' from the main string what is
query for that pls tell me

Answer

select substr("pravalli nagireddy",instr("pravalli
nagireddy",' '),10)from

Is This Answer Correct ?

1 Yes

7 No