I am executing a SQL script which has spaces, semicolons, single-quotes, special characters etc. in of the column called prod_desc. I need to execute the script
How Can I "set server output" on in Jetbrains DataGrip IDE? I am able to do this in SQL Developer and run the SQL script successfully. The same script I try to
I have created view and in this view i have added the below case statement which i need and for which i already create exactly the function based index. The vie
I have migrated mysql database to oracle. When I used sql query with modification as with rownum as following, SELECT id, frameTypeId, ownerId, locationId FROM
I want to make a simple web page using flutter as flutter for web, but I want to use Oracle as database in the backend. I know firebase will be more helpful, bu
I have a column in a oracle table Lic_num char(7 byte) SELECT column1, 'ABC' + Lic_num FROM TABLE One I wanted ABC appended to all the rows that are returned
Create table emp (id varchar2(22), name varchar2(85),hire_date date,department_id varchar2(3)); create table emp_epfo as select id emp_id,name lname,hire_dat
I am calling batch file from my java program which in result execute some .sql files. the batch script is below: set part1= CREATE OR REPLACE DIRECTORY REPORT
I'm trying to set a dynamic column name on my query using "select from dual". Is this possible? If not, kindly recommend alternatives for me to achieve this. I
How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the resulting rows to STDOUT in SQL*PLUS? ORACLE stored pro
I have 2 servers (one for testing, one for production), both have the following Oracle packages (identical output on both of them for SELECT * FROM V$VERSION; :
I have a client app that connects to an Oracle AQ multi-consumer queue. I want to use OracleAQQueue.Listen to listen for new messages on the queue. API docs s
How can I search in (put condition on) blob field in oracle, like text fields? I need someting like: select * from table_name where blob_field like '%00ff00ff
I need to develop in PL SQL using PL/SQL developer but I don't have idea how to make both oracle 11g and pl/sql developer work in the same machine because pl/sq
i would like to return all rows and fields from a table, where neither the tablename nor the fieldnames are known in advance. Something like: select * from [TA
I have two tables Emp and Dept and I am trying to display how many people work in each department along with their department name, but I can't get it to work.