Interview

Business Email : Email Format

 

                Business email is very important while you are working in professional world. Today I am going to talk about email format. how can we create very professional email. you always keep in mind, you have need to follow 3W rules and some other sequences while writing any business email. 

             Let us talk about 3W  rule what is 3W rule, i am going break this 3w rule here

•  Who    --- whom you send email
• what action -- what action are you taking while send mail
• when   -- when are you come up with result, you have need to share certain deadline with receiver.

           what should common format follow while sending any type of professional email

          I am sharing exact sequences here

•     Friendly open
•     Reason for your mail
•     Attachment
•     Offering help
•     Closing line

Few rules you always need to follow 

1- Always re-read your email before send mail

2-     

Sample e-mail

 Hello Linda,
I hope you are doing well                --- friendly open

I am writing  to you with regards to reporting issue, As you requested , I have updated changes in report,                                                                                                      --Reason for your mail
I have enclosed attachment with my comments.-                                  -- attachment
If you have any further questions, Please let me know.  -- offering help
Looking forward you suggestion or feedback on report 

====================================================================

             

 

Business English: Wh Questions

 

    

question word	function	Business English Sentences
what	asking for information about something	What is your name? What is current project status?
	asking for repetition or confirmation	What? I can't hear you. You did what?
what...for	asking for a reason, asking why	What did you do that for? What did you do to fix this issue?
when	asking about time	When did he leave? When are you plan migrate the change into prod?
where	asking in or at what place or position	Where do they live? Where are store project documents?
which	asking about choice	Which colour do you want? Which type project do you want to work?
who	asking what or which person or people (subject)	Who opened the door? Who has made change for this invoice?
whom	asking what or which person or people (object)	Whom did you see?
whose	asking about ownership	Whose are these keys? Whose turn is it?
why	asking for reason, asking what...for	Why do you say that? Why are you make change in test instances?
why don't	making a suggestion	Why don't I help you? Why don’t work with your teammate?
how	asking about manner	How does this work? How does this work?
	asking about condition or quality	How was your exam?
how + adj/adv	asking about extent or degree	see examples below
how far	distance	How far is Pattaya from Bangkok?
how long	length (time or space)	How long will it take? How long will it take time to execute this program?
how many	quantity (countable)	How many cars are there? How many
how much	quantity (uncountable)	How much money do you have? How much ticket do you have now?
how old	age	How old are you?
how come (informal)	asking for reason, asking why	How come I can't see her? How come I can’t see this invoice in instance?

Business Meeting

SQL: Group By, Rollup, cube, grouping

 

   Grouping is used to identify count of distinct values in specific object. we have been applying grouping on  columns of table.

    Syntax 

•     Group by  <col_name1>, <col name2>
•     Rollup (<col_name1>, <col name2>)
•     Cube ((<col_name1>, <col name2>)
•     Grouping (<col name1>)

     We use group by to identify count or sum against distinct values of columns in table

      select col1 , col2, count(1) from table_t group by col1, col2.

here it is identified distinct value between col1 & col2 and display no of rows

Rollup   --- this function used to grouping in next level

     n --- No of columns

if we are doing rollup between 2 columns then you have need to do rollup next 3 level (n+1) level.

 

 First level --- It shows normal goruping

 2nd level   --- Grouping at distinct value of first columns

 3rd level    --  Grand total 

Cube   ---- This function used to grouping in next level

   n --- column numbers

( N*2)

so we have calculate level is 4

first level --- Shows normal grouping

2nd level -- Grouping at distinct value of first column

3rd level  -- Grouping at distinct value  of 2nd column

4th level  -- Grouping ( Grand Total)

==============================================

Testing script

create table group_test_t

( col1 number,

  col2 number)

 --- here my table has created

 -- I am going to understand grouping , gorup by ,rollup and cube function here

    --col1 has 2 distinct values and col2 has 3 distinct value

 ---step 2-- Insert data into table

   insert into group_test_t (col1,col2) values (1,1);

   insert into group_test_t (col1,col2) values (2,2);

   insert into group_test_t (col1,col2) values (2,3);

   ---step3 --- test group by function using count function now I am going find for 2 col 

   select col1,col2 ,count(1) as nu_rows from group_test_t group by col1,col2 order by 1

   --rollup always as n+1 level suppose there 2 col then leve would 3 level

   select col1,col2 ,sum(col1) as nu_rows from group_test_t group by rollup(col1,col2)  

      level 1 -- normal grouping 

      level 2-- grouping for each distict value in col1

      level 3 --- total grouping 

      col1  has value 1,  2

      col2 have value 1,2 ,3

      grouping normal 1,1 ==> 

                      2,2

                      2,3 

       level 2 grouping at distinct col1 

       1      ===> 1

       2 (2 times) ==> 2+2 =4

       level 3 --->

       1,2,3

              ==> level 2 grouping as 4 + 1 =5

              

   Now understand cube where level calculate as n*2

     select col1,col2 ,sum(col1) as nu_rows from group_test_t group by cube(col1,col2)              

       level 1-- Noraml Goruping

       level 2 --> grouping for distict value for col1

       level 3 --> grouping for distict value for col2

       level 4 --> total sub group.  

               

Unix

Oracle Workflow : Oracle Workflow Introduction

  Oracle workflow is complete workflow management system that facilities business process re engineering  Oracle workflow automatically process information and route from one place to other according business rules, you can easily change to any person inside or outside enterprise.

 Components of oracle workflow

1. Workflow Builder
2. Workflow Definition Loader
3. Workflow Notification system
4. Workflow engine.
5. workflow monitor.
6. Workflow Directory Services.

Oracle Workflow builder is graphical tool which help to design oracle workflow

Workflow Definition Loader is utility which help download and upload workflow definition between database and flat files.

Workflow notification  system handle send and receive response notification 

Workflow engine embedded in E-business Suite and it helps to monitors workflow status and coordinates  routing activities of process. 

        Workflow 

1. Attributes             =>  It is variable of oracle workflow
2. Process               ==>  Business process is combination activities
3. Notifications         =>  Define notification
4. functions              ==> PL\SQL functions
5. events                  ==>  Trigger
6. messages             ==> Define message for notifications
7. Lookup types        ==>  It is used display button in notification and list of values

  What are the item type attributes available in workflow?

          -Text

          -Number

          -Date

          -Lookup 

          -Form

          -URL

          -Document

          -Role

          -Attribute

        Oracle Workflow builder access level should be 100 for customization any workflow 

             Version 2.6.3.5

Access  level  : 100

Check box  which allowed modification of customized objects

I will explain about check box and access level  in next chapter.