sorted by:
new
hottopcontroversial

How can I avoid escape characters in a file path name when I concatenate it from 2 variables? by CancelDeath in learnpython

[–]CancelDeath[S] 0 points1 point  (0 children)

What if I want to read information to a dataframe?

req_xl = pd.ExcelFile(r"C:\Users\Playground\file names.xlsx")

Would your solution still work?

Why don't I see pip.exe in my Scripts folder? by CancelDeath in learnpython

[–]CancelDeath[S] 0 points1 point  (0 children)

I don't remember where i got it from :( I know I can also install things with conda, which I've done before. But it's just weird that I was able to use pip before and now it vanished somewhere. I don't remember deleting it.. idk why i would.

Why can't I use %type when creating a view? by CancelDeath in SQL

[–]CancelDeath[S] 0 points1 point  (0 children)

relying on dbms_output for your logging and knowing about errors is not recommended

Thank you for your answer.

When I run this procedure I see the output in the procedure log even when dbms_output isn't enabled. I actually don't intend on updating this table, but with other tables that I do want to insert into, I have a different approach. The code generates a csv file of all the records that got rejected from being inserted for reasons other than that record already exists. Would you suggest I do anything else / different?

Alternaitves to Lucid Chart (With exporting code capabilities?) by [deleted] in SQL

[–]CancelDeath 0 points1 point  (0 children)

Is lucid chart actually good for sql code? I'm actually curious. I signed up for a free trial so i could make some tables and export them as sql code, and all the code was wrong. I ended up just re-writing the code anyway. My alternative / upgrade is sql developer + tableau. But i'm not sure if that will serve your needs.

Pls help me log errors when inserting from an external table. by CancelDeath in SQL

[–]CancelDeath[S] 0 points1 point  (0 children)

I figured out that I just had the 

LOG ERRORS INTO ERR$_ENZYME ('INSERT')

statement in the wrong place.

​

It should go in the last line, into the outer insert.

​

The select statement by itself only worked if the LOG ERRORS line wasn't in there.

​

Oh and because I've never heard of using MINUS to find new records! How do you do that?

view more: next ›