plsqldeveloper
Can somebody verify this for me in sql or teradata
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 */[详细]
2023-04-13 07:24 分类:问答PL/SQL send email with attachment?
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[详细]
2023-04-12 14:09 分类:问答How do I connect to a sql database through sql developer? [closed]
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[详细]
2023-04-07 10:18 分类:问答pl/sql conversion from number to string
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[详细]
2023-04-07 08:08 分类:问答Writing a SQL query over a given set of values
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.[详细]
2023-04-06 22:23 分类:问答PL/SQL data type support for size greater than NVarchar2
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[详细]
2023-03-31 11:04 分类:问答Escape ampersand in PL/SQL Developer
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[详细]
2023-03-29 11:56 分类:问答How to pass a List<> to an Oracle stored procedure
I have code that already stores String data inside a SQL table using a stored procedure: // my DAO public class SomeProcedure extends StoredProcedure {[详细]
2023-03-26 21:50 分类:问答selecting multiple columns in pl/sql collection
Actually i have created following procedure,which is working fine. CREATE or REPLACE PROCEDURE GET_NOS(开发者_开发问答[详细]
2023-03-26 11:09 分类:问答PL/SQL Developer: Multiple statements?
I have a script that generates a text file containing several SQL UPDATE statements: UPDATE TableX SET Field1 = \'New value 1\' WHERE Field2=\'1\';[详细]
2023-03-24 14:02 分类:问答