Can I use UTILS in Oracle?
NickName:user2034269 Ask DateTime:2013-10-14T18:23:51

Can I use UTILS in Oracle?

I want to ask if I can use the following in Oracle:

UTILS.CONVERT_TO_VARCHAR2

for instance:

SELECT insertData,
       UTILS.CONVERT_TO_VARCHAR2(insertData,10,p_style=>104) insert_short  
  FROM students

If it is not possible to use UTILS package, so which alternative I can use?

Copyright Notice:Content Author:「user2034269」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/19358153/can-i-use-utils-in-oracle

More about “Can I use UTILS in Oracle?” related questions

Can I use UTILS in Oracle?

I want to ask if I can use the following in Oracle: UTILS.CONVERT_TO_VARCHAR2 for instance: SELECT insertData, UTILS.CONVERT_TO_VARCHAR2(insertData,10,p_style=>104) insert_short FROM

Show Detail

Why can't I use use crate::utils?

The question is simple: Why can't I use use crate::utils? If I understood correctly, the crate refers to the root of my crate. I've just generated a new library project that by default has a lib.rs...

Show Detail

SOA Suite 12c - oracle.tip.tools.ide.utils.xml.generator.instance.InstanceGenerationException

I am trying to create a composite test case for my application. When I try to generate sample request/ response, I get an error in Jdeveloper. Reported by logger: oracle.tip.tools.ide.utils.xml.

Show Detail

How to compile ADF and JSF Utils and create the JAR files?

I would like to compile the ADF and JSF Utils and make a jar file containing the two so that I can make use of it in my ADF Applications. Please let me know if you have done this before (couldn't...

Show Detail

Can I use Direct Path Loads in Oracle Instant Client?

I have used SQL*LOADER in Oracle full client for bulk upload using ctl files. But I am planning to move to instant client in which SQL*LOADER doesn't work. I found from the Oracle OCI reference htt...

Show Detail

SQL to Oracle Date Issue

Currently in middle of migration from SQL Server to Oracle. Whats the best practices that i should applied across? And we also encounter some problem like the dateadd functions not working in orac...

Show Detail

How can I learn to use Oracle DB with PHP?

I would like to learn to use Oracle some, just for the sake of learning it. Is there a way to do this without spending a lot of money? I looked on the oracle site and the cheapest thing I saw was...

Show Detail

Oracle.Dataaccess is in the GAC. Can I control the version I use?

I have a XCOPY deployable .NET application using Oracle.DataAccess (ODP.NET). We also deploy the Oracle Instant client in the application directory. Everything works OK, but I worry.. From the Ora...

Show Detail

How can I connect to Oracle Database without Oracle Client?

I want to connect to Oracle Database without Oracle Client. After searching that how can I do this, I figure out I must use Oracle Instant Client. But how can I use this? I cant find something abou...

Show Detail

Oracle installation not available locally still can i use some open oracle DBs exposed for training?

I don't have oracle installation on my local but still want to use someones oracle instance which is available to use through public internet just for practice. Can I really think of such possibil...

Show Detail