Top "Oracle" questions

Oracle BI Publisher - How to format numbers as text so that leading zeroes don't dissappear

When creating an Oracle BI Publisher rdf template in Microsoft Word, with intended output to Microsoft Excel; is there a …

oracle bi-publisher

ora-1658: unable to creat initial extent for segment in tablespace

i'm getting the error "ora-1658: unable to create initial extent for segment in tablespace MYTBS" when trying to import a …

sql database oracle oracle11g oracle-xe

Get the name of the calling procedure or function in Oracle PL/SQL

Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the …

oracle function plsql procedure

Adding columns to existing index in Oracle

I have a relatively large table (81M rows) and an index on it. I want to add a column to …

oracle indexing oracle11g oracle11gr2

Is there an MD5 Sum function in PL/SQL

In Oracle SQL, is there an MD5 function or something available to me? I would like to do something like... …

oracle md5 md5sum

UpdateError: Receiving Error ORA - 01427 Single-row subquery returns more than one row

I am trying to update a column based on another column in the same table (student table) and a column …

sql oracle sql-update ora-01427

System users password has expired

I have just tried to login to my db via sql developer as system so i can create a new …

oracle oracle11g

Using the MIN function in the having clause

I want to get the name of the employee who has the minimum salary. Is there a way to do …

sql oracle min having

Strange Oracle XMLType.getClobVal() result

I use Oracle 11g (on Red Hat). I have simple regular table with XMLType column: CREATE TABLE PROJECTS ( PROJECT_ID …

oracle xmltype

SQL - CASE WHEN count different values

I need to show how many different values every 'id' has. It should look like this: id | component_a | component_…

sql oracle count having case-when