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 …
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-…