Remove CRLF remove double quotes while importing data in SQL database Remove Duplicates in SSIS package REMOVE DUPLICATES OF A TABLE WITH OUT SORT remove time stamp from datetime value in a column Remove unwanted columns in flat file before loading to table remove whitespace within a string before...
Add ability to choose between CRLF & LF for text output of tables In insert statements, ctrl click on inserted column should jump to matching expression and vice versa Add dependency pragma Added some connection properties CRC,DATABASE,DEFAULT_QUERY_TIMEOUT ...
-ocrlf use CRLF for output. End each output line with '\r\n' instead of '\n'."(CSV only). -onowrap do not wrap long columns(AT and MD only). -onull value(string) to convert from null on output. -oz string compression format for output. [ gzip | bz2 | zstd | lz4 | xz ...
6e71c34 - remove safe versions and use a flag instead (PR #2629 by @tobymao) v19.8.3 - 2023-12-04 ✨ New Features 05b41e8 - add identify to table_name (commit by @tobymao) 🐛 Bug Fixes 6351007 - tokenize CRLF sequence correctly (PR #2623 by @georgesittas) 🔧 Chores ...
objConn.Open "provider=SQLOLEDB;server=(local);database=tempdb;integrated security=SSPI" Set objCmd.ActiveConnection = objConn objCmd.CommandText = "SELECT CustomerID, CompanyName, City FROM Customers FOR XML AUTO, ELEMENTS" ' Open the ret...
utl_smtp.write_data( l_conn, utl_tcp.crlf ); utl_smtp.write_data( l_conn, l_message || utl_tcp.crlf ); utl_smtp.write_data( l_conn, utl_tcp.crlf ); -- Fetch the asset info for c in ( select * from assets where asset_id = p_asset_id ) loop -- Compress if a content...
g_reply t_string_table := t_string_table(); g_binary BOOLEAN := TRUE; g_debug BOOLEAN := TRUE; g_convert_crlf BOOLEAN := TRUE; PROCEDURE debug (p_text IN VARCHAR2); -- --- FUNCTION login (p_host IN VARCHAR2, p_port IN VARCHAR2, p_user IN VARCHAR2, p_pass IN VARCHAR2, ...
objConn.Open "provider=SQLOLEDB;server=(local);database=tempdb;integrated security=SSPI" Set objCmd.ActiveConnection = objConn objCmd.CommandText = "SELECT CustomerID, CompanyName, City FROM Customers FOR XML AUTO, ELEMENTS" ' Open the return stream and execute the command. Const adCRLF = -...
objConn.Open "provider=SQLOLEDB;server=(local);database=tempdb;integrated security=SSPI" Set objCmd.ActiveConnection = objConn objCmd.CommandText = "SELECT CustomerID, CompanyName, City FROM Customers FOR XML AUTO, ELEMENTS" ' Open the return stream and execute the command. Const adCRLF = -1...
<property name="message" value="CRLF and CR line endings are prohibited, but this file uses them." /> </module> --> <module name="TreeWalker"> <module name="AvoidNestedBlocks" /> <module name="ConstantName" /> <module name="EmptyCatchBlock" /> <module name="EmptyStatemen...