Actually, there are some sql editor we can use. One of them is SQL Developer. If we use this editor, we no need to set tnsnames.ora file. Just simply type the server IP address and the database name before we log in. This is the screenshot:
Simple? It could be different answer you get when asking this question. Maybe it’s just every man habit. Oke, get the next cool database experience!