Tag Archives: value

I have stored procedure after execution of operations i need to return one value and i need to capture that value using hibernate code

create or replace PROCEDURE ITEM_QUANTITY_PROCEDURE( CART_ID IN VARCHAR2, INPUT_ITEM_ID IN VARCHAR2, INPUT_STORE_ID IN VARCHAR2, LOGIN_ID IN VARCHAR2, QUANTITY IN NUMBER, STATUS IN VARCHAR2, OUT_STATUS OUT VARCHAR2) AS ON_H_QTY NUMBER := 0; B_QTY NUMBER := 0; FINAL_QTY NUMBER :=0; ITEM_CART_ID NUMBER … Continue reading

Finding the indices of the two items whose price adds up to to a value in an Array

I’m trying to solve Google code jam questions. Problem You receive a credit C at a local store and would like to buy two items. You first walk through the store and create a list L of all available items. … Continue reading

Get string from another string array if value matches

String Array 1: (In this format: <MENU>|<Not Served?>|<Alternate item served>) Burger|True|Sandwich Pizza|True|Hot Dog String Array 2: (Contains Menu) Burger Pizza Grill Chicken Pasta I need the menu is served or any alternate item served for that particular item. Code: for(int … Continue reading

How to calculate the value of px for adding it in css from the data provided below?

https://i.stack.imgur.com/0K2TD.png Total width for the bar = 500px Red box = 1 yellow box = 1 green box = 2 From this i need to calculate the px for the Redbox,YellowBox and green Box.

Getting the maximum value from a query

So, I need to find the most common customer First Name of all customers whose home address is in in Australia using the AdventureWorks Database (https://technet.microsoft.com/en-us/library/ms124438(v=sql.100).aspx). The code I have below gives me the answer i need (“Lacey” used 25 … Continue reading