Toad World Issues

Toad World Community

NOTE: This forum is for questions and discussions concerning the Toad World website and not for products/platform.
 
Please post product/platform questions in their respective forums.  Thanks!

Community Discussion

davehepler
Follow / 25 Sep 2014 at 11:29pm / Toad World

MVIEW SCRIPT not 'materialized view query'

Expand content
In viewing a MVIEW in the schema brower there is SCRIPT and 'materialized view query' tab. I am trying to get the script from the oracle tables. Most online help uses -- get mview text from...

In viewing a MVIEW in the schema brower  there is  SCRIPT and 'materialized view query' tab.

I am trying to get the script from the oracle tables.

Most online help uses

  -- get mview text from data dictionary
select dbms_metadata.get_ddl ('materialized_view', mview_name, owner)
into v_mview_sql
from dba_mviews
where owner = v_mview_owner and mview_name = v_mview_name;

But that gives you the 'materialized view query' not the SCRIPT.

I need to check this two parameters in many MVs.

START WITH TO_DATE('27-Jul-2015 11:21:29','dd-mon-yyyy hh24:mi:ss')

NEXT SYSDATE+9999/24

As to can see NEXT SYSDATE+9999/24 is for 400+ days so I need to

see the two Parameters.

THANKS

15 0 / Create an account to join the discussion.
fmolina
Follow / 19 Sep 2014 at 5:02pm / Toad World

Espacios al finalizar consulta.

Expand content
Estoy realizando una consulta a través del TOAD del tipo SELECT '123' FROM DUAL; pero al obtener el resultado aparece un espacio de 32 caracteres después del resultado, por ejemplo...

Estoy realizando una consulta a través del TOAD del tipo SELECT '123' FROM DUAL; pero al obtener el resultado aparece un espacio de 32 caracteres después del resultado, por ejemplo:

Esta misma consulta la realizo en el servidor de desarrollo obteniendo el resultado correcto:

Ya busque las configuraciones y son correctas o en su defecto no se si deje pasar algo por defecto, estoy utilizando rac. 

32 0 / Create an account to join the discussion.
mj.Jernigan
Follow / 8 Sep 2014 at 11:40pm / Toad World
Latest post by on 9 Sep 2014 at 8:10pm

Web pages too wide at Toad World

Expand content
I have my monitors turned portrait at 1080 x 1920 and these pages are too wide to fit by about 10% on Firefox.

I have my monitors turned portrait at 1080 x 1920 and these pages are too wide to fit by about 10% on Firefox.

80 1 / Create an account to join the discussion.
detupc
Follow / 4 Sep 2014 at 8:06pm / Toad World
Latest post by on 5 Sep 2014 at 6:45pm

Howwwwwwwwwwwwwwww to create a new thread ?

Expand content
I wish to create a new thread. I post here your instructions: To post a new thread, click on a community name in the Refine list below and select then select Forum. From this, I understand: 1)...

I wish to create a new thread.   I post here your instructions:

To post a new thread, click on a community name in the Refine list below and select then select Forum.

 

From this, I understand:

1)  Click on a community name in the Refine list below.   DONE.

2)  Select then select Forum.    WHAT ?

 

How do I "Select then select forum"   Can someone please be very specific.   Instead of just mentioning "buttons" or other screen objects, can you also mention a specific location ?

It is NOT at all clear to me what this means.   I have tried several things in an attempt to complete this step and nothing works.

 

 

 

86 2 / Create an account to join the discussion.
jaishree
Follow / 5 Sep 2014 at 5:51am / Toad World

Re: can we pass %row count as a parameter in cursor?

Expand content
oracle. On Thu, Sep 4, 2014 at 7:35 PM, Steve Hilker < bounce-Steve_Hilker@toadworld.com > wrote: RE: can we pass %row count as a parameter in cursor? Reply by Steve Hilker Which database...
oracle.


On Thu, Sep 4, 2014 at 7:35 PM, Steve Hilker <bounce-Steve_Hilker@toadworld.com> wrote:
Reply by Steve Hilker

Which database platform are you working with so that I can post this into the correct forum?

Thx,

Steve

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad World Issues notifications altogether.
Toad World feedback

Flag this post as spam/abuse.



44 0 / Create an account to join the discussion.