Tags » Raghav

drop foreign key without name Oracle

I want to ask a very basic question here.
We may/may not name a constraint while creating a table or after creating the table.
Suppose i chose not to name the foreign key constraint. 76 more words

Recent Questions - Stack Overflow

DECODE Oracle SQL

I recently came across few decode queries.

I found this decode function somewhat confusing. here are the queries:

SELECTpromo_id,DECODE(NVL(promo_cost,0),promo_cost, promo_cost * 0.25, 100) "Discount"
FROM promotions; 

SELECTpromo_id,DECODE(promo_cost,10000, DECODE(promo_category, 'G1', promo_cost *.25, NULL), NULL)
"Catcost";
… 70 more words
Recent Questions - Stack Overflow