I am working presently as a junior level DBA in Oracle . I plan to switch to full time developer. I want to know which areas that I can learn from my present job can be possibly used for development ...

When I go to crystal reports, I don't see an ODBC connection option when picking a data source. What could be causing this?
I'm thinking downloading something, like a service pack, will solve this. ...

I have Sql Developer installed in my MacBook Pro, 64-bit. I am trying to manually uninstall all of Sql developer components, but I need help locating those components on my computer. If there isn't a ...

I'm new to Oracle and I'm curious to know if there is a way to search a database and find out which tables are empty and which have data. I will be migrating some data to another system and it would ...

I am working on building a query report where i have multiple types of segment with priority ranking on one table and second table with all types of segment with date, time etc. (as shown below) The ...

Apologies for sharing little information than needed. Should have provided the entire thing. Here's it.
we are sending pre-check patching information from many DB's via a tool to some logs on another ...

I am connected to a database using SQL Developer.
I can make queries, but to "open description in popup" on a stored procedure, it throws an "Object not found" message. If I try to open the browser ...

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...

I want to do some rewriting and changing results of query. I've done this in mysql and postgres using proxies like ProxySQL, MysqlProxy and PGPool.
But I could not find any Proxy server on the web for ...

I am relatively new to SQL so please be gentle! I have a table that holds by month a list of statuses for a particular structure element. This only holds records where a status has been changed (for ...

In a given schema (having thousands of procedure and other objects) how can I find that procedure/trigger/view or relevant object that populates the table?
I am using Oracle SQL Developer.
Any help ...

I am trying to create a pl/sql function (my first take at pl/sql functions) that converts base 10 number to base 26 string (my base 26 will be A..Z).
create or replace function generateId(numericId ...

I have any oracle table that sometimes has valid null values is some cells. In SQL Developer it displays in the null cell as (null). This is not a problem but in a grid I have on a jsp page is also ...