PostgreSQL select column names where there is no default value : SELECT column_name, column_default FROM information_schema.columns WHERE (table_schema, table_name) = ('public', 'test') AND column_default IS NULL ORDER BY ordinal_position;
ImageMagick Resize the width, adding a prefix to the same names in current directory under Windows 7: & 'C:\Program Files\ImageMagick-7.0.8-Q16\convert.exe' -strip -thumbnail '250x>' *.jpg -set filename:area "thumb-%t" ./%[filename:area].png Result: 1.jpg --> thumb-1.png 2.jpg --> thumb-2.png 3.jpg --> thumb-3.png 4.jpg --> thumb-4.png
DBMS_OUTPUT has different default buffer sizes, depending on your Oracle version. You can increase the buffer up to 1,000,000 using the following PL/SQL statement: DBMS_OUTPUT.ENABLE(1000000); The SQL*Plus statement to achieve the same result is: SET SERVEROUTPUT ON SIZE 1000000 Starting with Oracle release 10g, it is possible to use the following unlimited buffer settings: DBMS_OUTPUT.ENABLE (buffer_size => NULL);
Comments
Post a Comment