Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DDL "omit schema" option should only ignore current schema

B.DelméeFeb 15 2015 — edited Feb 16 2015

otherwise you get misleading statements for synonyms, e.g:

create synonym XYZ for XYZ;


-- instead of


create synonym target_schema.XYZ for source_schema.XYZ;

note this seems to work correctly for views, though.

Unchecking the "schema" box in the DDL options should only result in the omission of the logged-in (or better yet, current) schema for the connection.

Comments

Zachariah Falgout

So it is separate by chr(13). This seems like a bug in Apex to me.

TexasApexDeveloper
Answer

HTML does NOT use the same carriage return + line feed as database.  You have the CR+LF characters in the field, and the search can't deal with them properly. To html a <br> is a line break. To be honest your database design leaves something to be desired..

I would save this as MTWTHF and get rid of the break between..

Thank you,

Tony Miller

Los Alamos, NM

Marked as Answer by Zachariah Falgout · Sep 27 2020
Zachariah Falgout

It is broken up to be on separate lines so the different schedules for a class line up the same.

So MWF 9-950 Building A

     TR    11-150 Building B

where days, times, and buildings are in their own column. Makes it easy for students to read.

Lol, probably but I am stuck with how the university stored the data, so I only have control over the table that combines the data from various per-existing tables.

So it is a bit difficult getting things to work and look nice in the app when the data that was originally stored isn't very neat.

But your answer makes sense, and honestly wouldn't have thought it as a html not being able to handle those characters. Still new to apex.

Thanks for your help.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 16 2015
Added on Feb 15 2015
#sql-developer
3 comments
819 views