I have a line of code in Oracle and I had to convert it into Teradata. The Oracle query is /* add to avoid invalid number due to junk开发者_开发技巧 in column */
we have a table with files saved as BLOB I write a code that email these files as an attachment! everything works fine so far, but the files (EXCEL,PDF, ... what ever) are not readable by the progra
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari
i need to convert number to string in pl/sql without using the inbuilt functions , we should use stri开发者_开发知识库ng/module operations for this. for exampleif the input is 123 then the output shou
I am trying to write a plsql query that allows me to query a set of known values that are not stored in a table.
PL/SQL has data type NVARCHAR2(size) where the size is 32767 bytes; equivalent to 4095 records. Now, what data type should i give as an alternative to NVARCHAR2 that could s开发者_如何学JAVAupport mo
I\'m trying a simple INSERT statement against an Oracle datab开发者_开发问答ase.One of the values is a VARCHAR2 field and the insert statement contains an ampersand.How do I do this?I\'ve tried the fo
I have code that already stores String data inside a SQL table using a stored procedure: // my DAO public class SomeProcedure extends StoredProcedure {
Actually i have created following procedure,which is working fine. CREATE or REPLACE PROCEDURE GET_NOS(开发者_开发问答
I have a script that generates a text file containing several SQL UPDATE statements: UPDATE TableX SET Field1 = \'New value 1\' WHERE Field2=\'1\';
加载中,请稍侯......