I am using oracle sql developer . Whenever we run any table / view sql with blank lines in between, the sql developer ignores it and executes the query perfectly. The feature is good, problem is the query fails in actual deployment where sql plus is used.
So is there a way we can let SQL DEveloper throw error when there is line break in between ?

here a screenshot to let u know what i am talking about even if the resolution is badi want to ask this question out of curiosity, what’s the use of the vertical line in the sql deeveloper worksheet ?

this is the “model” tab I click to generate a relational diagram

CREATE TABLE

anyone here aware of any other ways to connect to Oracle DB apart from the below mentioned ones?
1- user id and password.
2- proxy user connection / Kerberos connection.

I’m trying to write a basic select query to give me all the displayed records from my DB but I want to exclude ones that fall in to two specific categories.

How to update a table having a column name as amount in number data type to comma separated digits followingenter image description here Indian Numbering System

I have built a select query which utilises the SUM function and I’m trying to make the output show with 2 decimal places for the Settlement amount. In this example the actual STTL_AMOUNT is 29999 but I’d like it to output 299.99 so I need to add a decimal place in before the last 2 numbers. The format for STTL_AMOUNT is number(22,4)

I am using a stored procedure in sql developer which filter is (issolved != ‘Y’) now suddnly it is not working and i have to change it (issolved = NULL) to work again as this column either Y or Null
but i wanna know what happens that makes the procedure not working after it was working for a long time ago.

downloading query result to excel from sqldeveloper is taking too long
total row count is around 40000