Questions about toad
Read more about toad
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
ORACLE QUERY to pass date as variable in TOAD
I'm new to oracle and trying to run a simple query to pass date dynamically
DEFINE startdate = TO_DATE(select TRUNC(LAST_DAY(ADD_MONTHS( max(nav_last_calc_dt) ,-1))+1) from tb);
DEFINE enddate = TO_D...
Kavin Israel
Votes: 0
Answers: 1
toad formatter starts next line under trailing comments
I find that toad formatter starts the next line of code under trailing comments.
Is there a way to change this.
This happens regardless of wrapping/stacking options.
e.g.
Original SQL:
SELECT C1, C2, ...
Francois Evert
Votes: 0
Answers: 0
SQL: How to use functions/operations in a where condition
select * from mytable
where date = max(date)
This does not work. I hope my motive is clear. I know I can come around this problem by using sub-queries but is it possible to it without sub-query?
k.dkhk
Votes: 0
Answers: 1
Is there a way to connect to a specific instance of Oracle server?
I am not sure if I am using the right terminology, but I noticed while logged into OEM that my Oracle database server is set up with three instances and it seems to randomly pick one when I log in. Is...
Kelly
Votes: 0
Answers: 2