I would like to create some PL/SQL procedures that return XML as CLOB parameters. I want to just do this (which works fine with simple tests):
Im working on a pl-sql script, in which I have about 10 TO_CHAR conversions. One of them is throwing an
I\'ve declared the following types in my PL/SQL package: TYPE t_simple_object IS RECORD ( wertNUMBER, gsNUMBER,
Here is an example of some TSQL that I would like to rewrite in PL/SQL. DECLARE @xml XML SET @xml = \'<theRange>
I have A anb 开发者_开发知识库B in String format A = 14/01/2007 B = 22:10:39 I try to insert date and time:
I have a function that returns an object that has 3 values. Is there a way to call that function from a select statement and have each value be a different column? I could break it into 3 functions, b
I am developing a enterprise software for a big company using Oracle. Major processing unit is planned to be developed in PL/SQL. I am wondered开发者_如何学C if there is any ORM like Hibernate for Jav
I have a table with a structure such as table(PK, a, b, c, d, e, f, g). And 开发者_开发百科I have many queries that I want to join:
Situation: I am cr开发者_如何学Goeating an app in C# that uses Oracle.DataAccess.Client (11g) to do certain operations on a Oracle database with stored procedures. I am aware that there is a certai
I\'m a bit new to Oracle\'s PL/SQL (using 10g), I was wondering if there\'s a way to make a private method in an object type, as is often do开发者_如何学Gone for private helper methods in other langua
加载中,请稍侯......