Posts

Sql If Condition

Image
if condition use and if condition make result set .we are just confirming messages where you want to type and where you want to display .it might to declare local variable and getting some value .either greater then and less then the result will display on the screen on your SQL server . here we observed if statement .you can use as select statement and more .  

Microsoft windows activation

Microsoft windows activation

Food And Lifestyle

Image
Masaledar checken lolipop  (Indian best Checken) The Indian chicken lollipops was very delicious ever The oriental chicken lollipops get a desi makeover. Chicken wrapped in rustic spices and fried crisp. A great party starter! you can enjoy.. Chicken reshmi biryani Chicken reshmi biryani Makhni Paneer Biryani

GST AND GST TABLES IN ORACLE APPS

What is GST ? Goods and service tax is an indirect tax throughout India to replace taxes levied by the central and state governments. when goods and service taxes implemented, there will be three kinds of applicable goods and services taxes. CGST Where the revenue will be collected by the central government. SGST Where the revenue will be collected by the state government for intra-state sales. IGST Where the revenue will be collected by the central government for intra-state sales. Below is the comparison between new and old taxes regime TRANSACTION                NEW REGIME                  OLD REGIME                         COMMENTS Sale within  state                 CGST+SGST                     VAT+central excise/service       revenue will                                                                                          tax                                             be shared                                                                                    

How to create standard purchase order

A purchase order is commercial document and first official order issued by buyer to the supplier,indicating type,quantity,and agreed prices for product or services the supplier will provide to the buyer. 1)Standard purchase order:-this is used for one time purchases for good and services. here you know the item,price,payment item or delivery schedule. 2)Planned purchase order:-created when you have long term agreement with supplier.you must specify the the details of good and services ,payment term and the tentative delivery schedules. 3)Blanket purchase agreement:-this is created when the details of item and services,payment are know but not specify the delivery schedule. 4)Contact purchase agreement:-this is created when the term and conditions of a purchase are known but specific good and services are not. steps of standard purchase order creation:- 1)we go to navigator(vision operation USA) 2)go to purchase order 3)select operating unit(vision operation). 4)select supp

ORACLE FORM IMPORTANT NOTES

How to make the 3 text field and one push button ? You can just follow my steps to make beautiful custom form  oracle form like a application which developed the form first we can open the form builder and go to canvas . a canvas is basically a field area where items are situated on there such items like push button radio button,checks box,picture elements and so on.lets do the form where 3 text field and one push button to get result of two text field .when we put the value into two text field e.g like 10 or 30 then result pass to 3rd text field while button pressed result is gone to the 40.i hope you understanding properly. lets we do it. notes:-the items are situated physically on canvas but logically into the block. click canvas→go to plus sign to add new canvas 2 changed the name adding after double click on adding we get a frame (area) ⇓ yo see left side there is so many components ⇓ just go and drag and drop the 3 text fields ⇒same task for push button.now
WHAT IS RECORD ? Record is a composite data structure which hold data items of different kinds.Record consist of different fields similar to a row of data base table. 1)table base 2)cursor base record 3)user defined record To create table base or cursor base record we prefer % row type attribute which provide record type to represent a rows in data base table.record can stored rows from data base table or fetch from  cursor variable and cursor. e.g of table base declare v_rc employees.%rowtype; begin select * into v_rc from emolyees where employee_id=100; dbms_output.put_line('employees details:'||'v_rc.last_name||v_rc.first_name||v_rc.salary); end; 2)cursor base record declare cursor c_rec_emp is select last_name,employee_id,salary from employees v_c_r c_rec_emp.%rowtype; begin open c_rec_emp; loop fetch c_rec_emp into v_c_r; exit when c_rec_emp %notfound; dbms_output.put_line('employee datails:'||v_c_r.last_name||v_c_r.employee_id||v_c_r