yes, we can insert null values into foreign key column. and we can also insert duplicate values into foreign key column which are there in unique key column or primary key column.
Subscribe to:
Post Comments (Atom)
Query to find request set and its responsibility
SELECT FA.application_name, fr.responsibility_name program_attached_to, frg.request_group_name, fcp.request_set_name,...
-
--Open PO query. SELECT pha.segment1 ponumber, hou.name organization_code, pha.type_lookup_code potype, trunc(pha.cre...
-
--Query used to display the Order details and its invoice details select ooh.ORDER_NUMBER "Order Number" , ra.C...
-
-- Open PO Receipts. SELECT h.receipt_num ,h.shipment_header_id ,l.SHIPMENT_LINE_STATUS_CODE ,pha.segment1 PO_N...
No comments:
Post a Comment