Hot answers tagged

3

NUM is not a reserved word. The best way is not to use reserved words. If you insist on using them, you can put them between quotation marks. This does not work: SET SERVEROUTPUT ON declare begin number; begin begin := 10; DBMS_OUTPUT.put_line('The value of begin ' || begin); end; / This does: SET SERVEROUTPUT ON declare "begin" number; ...


1

Customers come and go. Sometimes they have the right to take their data with them. To extract a subset of data from one schema where the data could be anywhere and the only marker might be a tenant number is a lot harder than putting each customer's data in one schema. One solution I have seen used is to have a master schema with the metadata concerning ...



Only top voted, non community-wiki answers of a minimum length are eligible