Sitemap

Amicuk Programming Answers

Query from User_Scheduler_Jobs returns no rows in version 2.1.0.63

-0001-11-30   Views:2

Advertisement

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5. Edited by: User65423 on Feb 8, 2010 9:24 AMRefer to this thread, where the cause seems to be due to SQL Developer not handling null inter

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5.
Edited by: User65423 on Feb 8, 2010 9:24 AM

The replay answer
Advertisement
Refer to this thread, where the cause seems to be due to SQL Developer not handling null interval data types.
bug? F9 gives no output dba_scheduler_jobs, version: 2.1.0.63.73
As mentioned in that thread you can use to_char on the interval columns as a work-around...
SELECT source,
destination,
comments,
flags,
job_name,
job_creator,
client_id,
global_uid,
program_owner,
program_name,
job_type,
job_action,
number_of_arguments,
schedule_owner,
schedule_name,
start_date,
repeat_interval,
end_date,
job_class,
enabled,
auto_drop,
restartable,
state,
job_priority,
run_count,
max_runs,
failure_count,
max_failures,
retry_count,
last_start_date,
TO_CHAR(last_run_duration),
next_run_date,
TO_CHAR(schedule_limit),
TO_CHAR(max_run_duration),
logging_level,
stop_on_window_close,
instance_stickiness,
system,
job_weight,
nls_env
FROM user_scheduler_jobs a;

Go to See the other 3 answers

Query from User_Scheduler_Jobs returns no rows in version 2.1.0.63

Category:DefaultRelease time:-0001-11-30Views:130

Using version 2.1.0.63, "select * from user_scheduler_jobs;" returns no rows. It works ok in version 1.5.5. Edited by: User65423 on Feb 8, 2010 9:24 AMRefer to this thread, where the cause seems to be due to SQL Developer not handling null inter[More]

SQL Query (PL/SQL Function Body returning SQL query) doesn't return any row

Category:DefaultRelease time:2015-10-11Views:130

I have a region with the following type: SQL Query (PL/SQL Function Body returning SQL query). In a search screen the users can enter different numbers, separated by an ENTER. I want to check these numbers by replacing the ENTER, which is CHR(13) ||[More]

Query with XMLTABLE returns null rows

Category:DefaultRelease time:-0001-11-30Views:130

Hello all, I'm trying a query with XMLTABLE, but even thought the number of returned rows is correct, the row content is (null). DB version is: 10.2.0.4.0 Here is my query; SELECT s.DESCRIPTION FROM EXECUTIONPLAN p,   XMLTABLE   ('//executionPlan/exe[More]

Bug Report: ResultSet.isLast() returns false when queries return zero rows

Category:DefaultRelease time:2015-10-11Views:130

When calling the method isLast() on a resultset that contains zero (0) rows, false is returned. If a resultset contains no rows, isLast() should return true because returning false would indicate that there are more rows to be retrieved. Try the foll[More]

Query executed within a plug-in script returns 0 rows, although data exists

Category:DefaultRelease time:2015-10-11Views:130

I created a plug-in script for algorithm entity: Service Quantity Rule. The script calls a business service that I created using query zones. The query returns the values of the bill segment (ci.bseg.bseg_id and ci_bseg.closing_bseg_sw) that is creat[More]

Query to return separate rows for date range including NULLs

Category:DefaultRelease time:2015-10-11Views:130

I'm trying to write a query that will return all customers from table 1. Table 1 also provides a start date and an end date that may be different for different customers. Left join with Table 2  provides all matches and NULL if NO matches. If there i[More]

Query to return ALL rows even those with zero counts

Category:DefaultRelease time:2015-10-11Views:130

Hi, The following query will return only those rows that have a non zero count value: select c.id, a.name, count(*) as XYZ from CON c, CUST a where c.help !='1' and (c.id = a.id) group by c.id, a.name order by c.id; The results are: 1 ME 3 3 YOU 4 Wh[More]

Silly old fogey (me) cannot figure out why this query returns 1 row

Category:DefaultRelease time:2015-10-11Views:130

Hi all, In reference to {thread:id=2456973}, why does select sum(count(decode(job, 'CLERK', 1, null))) CLERKS , sum(count(decode(job, 'SALESMAN', 1, null))) SALESMANS from emp group by job;only return 1 row and not 1 for each job? I actually had to t[More]

XML attributes makes my query return no rows

Category:DefaultRelease time:2015-10-11Views:130

Hello everyone, I've an odd problem. I'm querying some XML, but the attributes in one of the tags make my query return no rows; if I remove the attributes, then the query works as expected. The XML is below; it's the attributes in the Report tag that[More]

Cascading LOV always returns first row in af:query

Category:DefaultRelease time:-0001-11-30Views:130

HI JDEV 11.1.1.3.0 A strange thing is happening with my cascading LOV which is input text with LOV. I have a read only table with a query section. I then also bring up any of the tables rows in a popup with single record view where the row is then in[More]

Query doesn't return rows

Category:DefaultRelease time:-0001-11-30Views:130

Hi, The following query returns no rows, while there is one row in the table: SELECT * FROM (SELECT id,              amt_disburse amt1,              TO_CHAR (dt_disburse, 'RRRRMMDD') date1       FROM (SELECT a.*,                    ROW_NUMBER ()     [More]

Hot
I've been having this problem from day 1 when trying to play music on my pc before I add it to my iphone while its hooked up to my windows 7 pc, it just starts disconnecting and connecting over and over again and as soon as I stop playing music its f [More]
Hi All, I am trying to do some suggested performance tuning in the BW (BI 7) system. My first step was reducing the number of sub chains in the Process Chains. What help I require from you masters is that, I want to compare this modified process chai [More]
and can we use constructor inside a servlet .If yes at what situations we can useServlet is an object. Not sure what you need. You can create objects inside a Servlet, or any Java class... and can we use constructor inside a servlet.Sure, but most pe [More]
I have a fact table, order lines. There are two dimension tables, customer & Product. For each order i want to display on a pivot table: - the cost of the line. -the cost of the total order.  Is this possible? I have been playing with ALL & All ex [More]
Hi everyone! I am wondering if it is possible (or will be possible) to use the Q&A function in another language than English? I am using the Synonyms functionality which is great, but I am referring to the "natual language" part of the quest [More]
Hi, In my production database(primary) machine flashback is ON. So, logs are creating in following directory: /d01/silprod/SILP/db/apps_st/data/archives/SILP01_SER/flashback In my physical standby database flashback is OFF. So, My question is that: C [More]
Hello All: I'm at my wits' end trying to figure this one out; I've searched the forums (and about half of the internet), but I haven't yet run across this particular scenario: Client's Mac: G4/500 running Mac OS X 10.3.9 (there are 6 other Macs in th [More]
I just got a new 2nd gen touch and it will play a song all the way through, but on the second song (or video), the sound disappears after 2 seconds. The ipod still shows that it's playing the song, but without sound. The same goes for video. You can [More]
Hi. When I cut, paste  and move a too late phrase in a Logic Pro region to an earlier spot it does not change anything when played back! May be it has to do with automation I have on it? It asks me move or don't move automation when I move it to the [More]
Hi guys, I installed SpeedFan today and I was wondering which readings correspond to what. I know that FAN 1 is the CPU and FAN 2 is the NB, and TEMP 1 is CPU. Which one is system temperature? TEMP 2 or TEMP 3. I'm getting CPU Temp 29ºC TEMP 2 = 27 C [More]