Sitemap

Amicuk Programming Answers

T-SQL functions in ORACLE

2015-10-11   Views:0

Advertisement

Use T-SQL functions in ORACLE too, so you can write one script version that works in SYBASE, SQLSERVER and ORACLE when need to use the following functions: ceiling, charindex, dateadd, datediff, datename, datepart, day, db_id, db_name, getdate, host_

Use T-SQL functions in ORACLE too, so you can write one script version that works in SYBASE, SQLSERVER and ORACLE when need to use the following functions:
ceiling, charindex, dateadd, datediff, datename, datepart, day, db_id, db_name, getdate, host_id, host_name, left, len, month, replicate, right, space, str, str_replace, stuff, substring, suser_id, suser_name, user_id, user_name and year.
The file [comp_tsql_ORA_schema.txt|http://forums.databasejournal.com/attachment.php?attachmentid=564&d=1258547015] creates the tablespace and schema to put the objects, and the file [comp_tsql_ORA.txt|http://forums.databasejournal.com/attachment.php?attachmentid=569&d=1259256898] creates the functions into the new schema. They will be avaliable for any schema of the oracle instance.
Hope this help!
Any suggestion please contact.
aklein2003
Edited by: user1958693 on 26/11/2009 10:16

The replay answer
Advertisement
jgarry wrote:
J2EE beta released around 1999. Religious programming wars far preceded that. Here's but [one example|http://groups.google.com/group/comp.lang.lisp/browse_thread/thread/1c50bc13e9302f00/34bb8f3ac77e2388?q=programming+language+religion#34bb8f3ac77e2388] from a quick google. I'm no longer convinced that elegance is a desirable trait for a language. So call me a heretic.
Ever tried XLISP? :-)
It's different. Back then it was simply the language itself. And it was not really a religious kind of battle, but more a mine-is-bigger-and-better-than-yours one.
With Java, it is all about The Acrhitecture and the blessed language of Java. ;-)
I wouldn't so much blame J2EE believers for that. I think there is a fundamental complexity to web type paradigms that hasn't been described in a precise and encompassing enough manner to enable correct project planning.The basic problem is that the database is treated as a persistent storage layer only. A bit bucket. And that is exactly what a database is not.
But as it is used that, loads of database features now need to be duplicated in the application layer. Which is done. Very poorly.
Heck, I've even been told that J2EE's 3-tier architecture is not client server. Such ignorance is really unbelievable. Or is it pure stupidity?Until you just made me look it up, I would have thought that too, I'm sure I saw client/server defined as two-tier in the last century. But I have much more stupid misdefinitions to deal with on a daily basis, simply from the multiplicity of paradigms. I tend to retreat into my shell. Hehehe. Know that feeling... These days I rather run away, or set shields to full power, than try to get in yet another frustrating, fruitless and futile discussion with a Java head about the wonders of the J2EE architecture. Or trying to explain that this "new" architecture is predated with what we used in the 80's on mainframe systems with transaction monitors, block devices (the 80's web browsers) and databases - which software layer for software layer was almost identical to "+The Great Architecture+" of today. (and we did it without buzzwords too) ;-)
Client-server is a software architecture and in essence describes 3 basic software components. The User Interface (UI), the Application (APP) and the Database (DB). And there are various ways to put these components together in a client-server architecture. The mistake that the Java fanbois make is thinking that client-server means having the client as the UI and APP as a single component (so-called fat client) and then the DB component as the server.
There are numerous versions of these - including the APP component being a server component (as we now these days more commonly used in over the web).
My beef with the J2EE "+religion+" always has been that client-server is client-server. The fundamentals stay the same.

Go to See the other 15 answers

T-SQL functions in ORACLE

Category:DefaultRelease time:2015-10-11Views:130

Use T-SQL functions in ORACLE too, so you can write one script version that works in SYBASE, SQLSERVER and ORACLE when need to use the following functions: ceiling, charindex, dateadd, datediff, datename, datepart, day, db_id, db_name, getdate, host_[More]

Calling a pl/sql function from oracle forms

Category:DefaultRelease time:2015-10-11Views:130

I have written a pl/sql function in a package. package name- sup function name - func I have written a when-button-pressed trigger .from here I want to call this function. How can I do that? Please help..Thanks a lot.. User may select 20-30 check box[More]

How I work with MS-SQL function in oracle

Category:DefaultRelease time:-0001-11-30Views:130

I'm working in oracle now but I don't know how can I use following function in oracle. convert, dateadd, datediff, fetch_status, isnumeric, reverse, str and stuffAlso available in 10g, the model clause version, taken from this How to display text in[More]

Access SQL Function in Oracle?

Category:DefaultRelease time:2015-10-11Views:130

Microsoft Access SQL has a function called LastOf which extracts data from a column within the last row returned when multiple rows are returned. This function works even when many tables are joined and only one of them returns multiple rows. Does Or[More]

Availability of stdnormal_inv  PL/SQL function in Oracle Database

Category:DefaultRelease time:-0001-11-30Views:130

I am in need of stdnormal_inv statistical function to calculate the Quantile of Standard Normal Distribution for safety stock computation in MRP module. If anyone knows whether any pl/sql code exists to compute stdnormal_inv, please help me with the[More]

Pl/sql function body returning SQL query - Print function

Category:DefaultRelease time:2015-10-11Views:130

Hello all, I have pl/sql function body returning SQL query for my reports for my new project that I am developing. We dont have any BI tool or anything for APEX so we use Oracle reports to get the same reports to be printed in PDF format. I had been[More]

Built-in SQL Functions?

Category:DefaultRelease time:2015-10-11Views:130

What are the built-in SQL functions in Oracle? I already know: COUNT, SUM, AVG, MAX, and MIN. Are there any more? Thanxhttp://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions2a.htmRead other 2 answers[More]

Using sql functions (min, max, avg) on varray or table collection

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I would like to know if there is a way to use sql function or oracle sql function like Min,Max, Avg or percentile_cont on varray or table collection ? Does anyone encountered this type of problem ? ThanksYes you can apply Min,Max, Avg... if varra[More]

SQL Function Deleted

Category:DefaultRelease time:-0001-11-30Views:130

Hi, i deleted my sql function in oracle.. Any one can tell me how to get it back ? some "Recycle Bin" thingy ?then you're out of luck,... the recyclebin thingy doesn't work for functions (or at least in Oracle 10g)Read other 3 answers[More]

CONVERT function in SQL Server to oracle

Category:DefaultRelease time:2015-10-11Views:130

All, How to convert CONVERT function in SQL Server to oracle, below mentioned format is in SQL Server: variable1 = convert(numeric(20), SUBSTRING( parameter1,parameter2,parameter3) parameter1 datatype nvarchar2(100) parameter2 datatype bigint paramet[More]

Recursive functions in Oracle SQL.

Category:DefaultRelease time:-0001-11-30Views:130

OK, Here is the pivot problem. Only this time were on an Oracle 11.1.0.7.0. I've created a table called: CREATE TABLE STAGING.MY_TAB_COLS   TABLE_NAME   VARCHAR2(30 BYTE),   COLUMN_NAME  VARCHAR2(30 BYTE) )And I've put the following data into it: Ins[More]

Hot
Is it possible to have multiple user accounts on one single ipad. Like one admit account, one for the Kids and one for mom and dad? Thanks! JosefiOS: Understanding Restrictions (parental controls)Read other 4 answers [More]
To whom it may concern, This morning I purchased an album, on listening to it three of the tracks are not playing correctly. I read on an apple discussion board that I should delete them and re-download them. This did not work as I was asked to pay f [More]
Hi All, In my infra, we have set the discovery policy as AD & IP range. All the machines are getting discovered, however in platform tab of Unix/Linux machines shows as 'Windows', and due to this we are unable to license the machines. Please help. Re [More]
Hi! I am using Macbook Pro and just recently upgraded OS to Yosemite 10.10.1, and then found out most fonts in Preview are gone. I can still use all my fonts in other app but just not in Preview. All fonts were there when I was using Mavericks' versi [More]
Hi all, I have a really strange problem when trying to use HsGetValue -functions in Smart View (in Excel 2010). The thing is that I can create a lot of formulas for a sheet that have links to other sheets. However, in some pont (I don't exactly when [More]
I have just buy C2-03 and disappointed with some basic options, kindly resolve them in next software update- 1- No option to Type message without opening slide keypad- please add onscreen keypad 2- No option to remove keypad lock during call inprogre [More]
I have a small problem with dates. I have a VB app that uses ODBC/ADO to access an Oracle 8 database, and I'm using a where clause which includes date conditions: and      ent_dt >= to_date ('10/01/2003', 'dd/mm/yyyy') and      ent_dt <= to_date ('3 [More]
OK- I just can't figure this one out. I am a first timer with the spry widgets not built into Dreamweaver. I've added a sliding panel widget, I want to break a story into two parts without adding a second page. When I open in a browser, both panels a [More]
Hi Guy's, Please help me Using Tabstrip control how to updated the related infotype records into related database table. Thanks and Regards, Sai.Hi Guy's, Please help me Using Tabstrip control how to updated the related infotype records into related [More]
Hi! I found a great deal on a Radikal Tech SAC 2.2 Control Surface. As my primary focus is Logic Audio I already have that covered, but as frequent Final Cut user my concern is that it should also work with said system. I know the SAC 2.2 works in fu [More]