With the code below I am trying to search for certain words (SEED WORDS) inside reviews. Then depending on the number of Seed words inside each review I come up with a rating number. There are …
Tag: oracle-sqldeveloper
How can an Oracle-user query a table in another schema in oracle18c?
I want the oracle-user c##user2 to query the table test in the schema c##user1, but when I query the table, I get the message “no rows selected”. Both users have the permissions “CREATE SESSION” and “…
Display parent records that meet condition of child records
In oracle sql, imagine I have a table of game developers and a table of products sold by a game store. Imagine I am trying to select only game developers that have a total amount of products …
Migration MYSQL to ORACLE
right now am working on database migration from MYSQL TO ORACLE. I have experience in MySQL but not in Oracle, So help me to convert the following MYSQL query to ORACLE Mysql query: SELECT MIN(id) …
Relational Operators Issue With Null
I am having issues with the below select statement not picking up the data when I insert a relational operator. SELECT C.FIRST_NAME, C.LAST_NAME, B.COMPANY,A.ITEMNO, A.REV, A.DESCRIP FROM ARINVT A …
How to find the row and column number of a specific cell in sql?
I have a table in SQL database and I want to find the location of a cell like a coordinate and vice versa. Here is an example: 0 1 2 3 …
How to run .sql file in Oracle SQL developer tool to import database?
I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB. I read about running scripts here, but I didn’t understand the way. Is …
How to use date variable in sql developer’s “Enter Binds” dialog?
I am trying to run a query from sql developer and query has variables (:var). I am having problem with the date variables. I used all the possible combinations to format date using to_date() function….
Creating a new database and new connection in Oracle SQL Developer
I’ve installed SQL Developer on my system. No connections are being shown in my system yet. How do I create a new connection. Must I create a database first? If yes, then how do I create a new database. The SQL Query Editor window is not opening because there is no connection. All of this because there is no database.
Oracle SQL. How to execute query one by one
Could you help me, how can I execute query one by one in Oracle SQL Developer? When there’s one query system works correctly. But when I write 2 or more and press “ctrl” + “enter”, System marks out all queries and trying to execute all of them. Answer Separate each query by semi-colon, then SQL Developer executes them one after