This is what is displayed when I tried to view a row. The last column is supposed to display COMM for commission but truncates the fucking name every time. If I have more columns it won't display them too. I've set linesize 1000; etc. Though I did edit the properties menu when opening SQL Plus. Perhaps that is causing my issue? I've allows the default window size to be expanded larger. It allows me to type longer strings into Oracle but I does not display larger table lengths.

Anyone know what I can do to make SQL Plus display full length of table names before wrapping the text around again or truncating it?

http://www.sql-workbench.net/

that's a JDBC-based IDE. i doubt you can use packages/snippets and whatnot, but it works great for DML, table browsing, etc

is your problem only for select * or every select statement? i only use sqlplus for compiling packages, i dont use it for general use.

there's also TOAD and SQL Developer.

This post was edited by carteblanche on Mar 2 2014 06:43pm

I'm taking a class in Oracle SQL so I have been using SQL Plus for all of the assignments.

It's any select statement to be honest. It seems to cut off and/or wrap around after a certain number of characters. Rather annoying and aggravating. (Just like this class.)

are those assignments specific to sql plus or not? eg: click this button, then this button, then take a screenshot.

if it's not, use the link i posted. you can do all your dml there.

I was about to write out a fuck load of shit when I realized my problem. My COMM column is set to a CHAR(1) which obviously limits it to 1 character. Well how do I force it to display the entire columns title while still limiting it to 1 char? I forgot.

Edit: Derp. Column alias I believe..

So can I set a default column alias so each time a query that table it will automatically display the alias?

This post was edited by NinjaSushi2 on Mar 2 2014 07:16pm

1) why aren't you using varchar2(1)? char(1) is ok, but you should almost never use it for more than length 1. it's best to stay away from it altogether.
2) that has nothing to do with the length of the title. 1 char is for the rows, not the header.



why dont you post your full sql?

This post was edited by carteblanche on Mar 2 2014 07:13pm

I would like this:



to display like this:



I think it should make more sense if I phrase it like that. It was rather confusing eh?

This post was edited by NinjaSushi2 on Mar 2 2014 07:19pm

I'm using CHAR(1) because the value will always be 1 in length. COMM defaults to Y but can also be N.

i wasnt referring to the length of 1. i was referring to your datatype. why are you using CHAR instead of VARCHAR2? for length 1 it doesnt really matter, but for any other length it matters and VARCHAR2 is preferred. so it's best to get in the habit.

I know. CHAR is preferred for character lengths up to four that are also constant. VARCHAR and VARCHAR2 are for characters that vary is size though I only use VARCHAR2 and never varchar because it's worthless old ass scripting. Frankly I fucking SQL or at least this fucking oracle class and am only doing it because that's the way the assignment is written.


Right now I am fucking furious because I can't figure out this stupid question and my book doesn't help. This fucking book worthless too. Maybe you can help before I put my fist through my computer monitors.



The rows referenced are rep_ID. Currently table book_stores column rep_ID is the foreign key of table store_reps column rep_ID. I don't fucking get what they are asking without dropping the constraint completely and I am going crazy berserk pissed at this bullshit. I fucking hate class dude. (never taking an online class again too.)