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
I've created a document in InDesign CS5. When i export for PDF some images don't appear in the PDF. The images are either imported JPGs or shapes created in InDesign. Most of the images appear just some don't. I'm not aware of doing anything differen [More]
LRoom 5.5 does not export files under any circumstances.  I've chosen different locations; putting it in Lightroom NEF to JPG, putting it in another program, same conversion.  I get a "win 32 file missing.....".  I did not copy that message as i [More]
I am modifying a database Read script to filter based on data within a related table. However, when this is executed from my iOS app, it hangs. A response is never sent back. Here's what I have. What am I doing wrong? function read(query, user, reque [More]
Usually when you open a new tab that tab is selected and you can start typing an web address. In my case when I open a new tab nothing is selected so I have to select the browser with my mouse and then start using the browser.You can not run executab [More]
I purchased Adobe Acrobat XI Pro product and installed it from AcrobatPro_11_Web_WWMUI.exe into HP PC with Windows 8.1 operating system. When I start the program it tells that "Checking the serial number ..." After some seconds it displays the m [More]
hi i am trying to upgrade hyperion 11.1.2.1 to 11.1.2.3 with maintenance  release . after the configuration with previous database and starting all the serives, when i loging to shared service i cannot see my application in essbase cluster 1 . i trie [More]
What are the requirements for the password for encrypted backup. Cant remember mine so requirements might help.The battery does not constantly draw power. It doesn't even get warm. Feel it if you don't believe me. Just leave everything as it was and [More]
Arkedk over at XDA Developers has added all X10i and X10a firmwares... So far all 93 X10i firmwares have been added... Just make sure you know which one applies to your X10i or your region. In the case of X10a only 1 firmware has been posted (X10a_3. [More]
Hello, I have been using C5.5 for over a year now, but recently had to re-install Windows 7. This means I lost all my programs too - including Dreamweaver. So, I basicaly need to reinstall C5.5 but I can't find where to download this. The only versio [More]
Does anyone know if DigiCert certificates are approved certificates?  Though we have it loaded to the root, we continue to get the "The Exchange Server requires certificates to log on.  Connect your device to your PC on the corporate network to obtai [More]