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
Hi,All How display header fields in QPLD By Firos.CHi Firos, Try to Create this SAMPLE Query Report PLD. Copy and Paste the below Query Report in Query Generator and Save as the Query Manager than Create the QPLD. for example: Outgoing Payments Detai [More]
I have my Finder in list view: always and everywhere (except for the occasional pictures folder). Within Yosemite I encounter a lot of differences. Sometimes a folder opens in icon view. When the file picker windows appear (in Pages for example) it i [More]
hi! i'm using portal v3.0.9.8.4. and application server r1. how can i call the wwctx_api.getuser or similar procedures from a jsp page? if not, is there a java equivalent to it? thx and rgds.Hi, You can go to "http://portalstudio.oracle.com" and [More]
Dear All, I want to display the selection option ("Other sources") which I find in the /nse80 screen painter but cannot be display in the ME22N. /nME22N -> select one Purchase Order for Services -> select one Item Line -> at "Servi [More]
I really hope someone out there can help me out here because I'm at my wit's end!!!! I have a bunch of raw files in a folder, these are just pictures I took for a bit of general practice over Christmas. Now, whilst trying to modify the IPTC Core Fiel [More]
My adobe reader update keeps flashing but every time i click on it and put in my password it hangs up at 97%..I tried it several times:))I have been looking at this most of the day.  What I found was any time "TOOLS" or one of the online buttons [More]
Trying to get it to instill windows 2003, everything goes fine with updating software, identifying windows 2003 server and selecting the 32-bit version, until the identifying distribution page, where it stalls / does nothing when I click next. So I'm [More]
Hello guys, Today I was offered to install the most recent update for my Embedded Compact 7. Great, taking into an account it says 'fixed an issue with filesystem corruption when creating a folder' - that one I suffered from. Ok, I started installer [More]
When I rearrange my ipod shuffle list and do control click on a song for the shortcut menu the play to order command does not show up i the menu. The menu does not look like what was in the other post. I am frustrated because I listen to audiobooks.. [More]
As the title indicates, we've been getting these error messages in our system log from various event services for as long as I can remember: MxEventAgentService:Error running eventagent check It is JobId 0 (makes sense, as it is coming from one or th [More]