logs archiveIRC Archive / Freenode / #oracle / 2015 / July / 23 / 1
yottabyte
hey guys if I'm selecting from a table and I just want a column from another table returned how would I do that?
MatheusOl
yottabyte: well, just list the column you want in the SELECT clause
yottabyte: BTW, some days ago you asked if SELECT does dirty read, it does not
yottabyte: It uses the UNDO log to read the correct snapshot
yottabyte
oh cool
MatheusOl: but I mean from another table
MatheusOl
Not clear yet
yottabyte
like I want to select a, b, c from table bob and select d from table john
and give me a 4 column output
MatheusOl
join?
yottabyte
I don;t know how to do that
MatheusOl
Then you'll have to give more information
yottabyte
when you have a file size in the database would it be in bytes or kilobytes
it's stored as a number
         

MatheusOl
That is your call
« prev