-
The below three queries result the same data.Please check these queries and let me know your feedback about the best plan.Also, how can I find the overall final cost of a query? *****************......
-
I am trying to figure out what is the minimum and maximum versions or Oracle supported by ORA2PG tool for migrating Oracle database to PostgreSQL. I cannot locate it in their documentation. If ......
-
I am a bit new to SQL Developer and I am getting error "not a group by expression"select cmp.company_name, sum( inv.total_price ), inv.invoice_date FROM companies cmp join invc_header inv ......
-
I want to display all last_name from my employees table in this procedure.Error: ORA-01422: Request returns more than the requested number of linesCode:CREATE OR REPLACE PROCEDURE writeAllEmployees ......
-
There is a statements logging in Oracle SQLDeveloper:Is there any way to export them as plain text or log them to file?UPD: The reason I want to collect statements to file is for easy diff (to ......
-
Hey everyone it's me again, I've just started on a class in my degree on Oracle/Databases, I've posted this a few days ago which was answered promptly and really appreciated it.Learning Oracle, ......
-
I am using SQL Developer to connect to a few Oracle databases on different versions i.e. 18.0.0 and 11.2.0.I have installed both sets of drivers on my PC. It appears that when I use TNSPING (via a ......
-
I have 2 schemas.Schema A , Table TSchema B , Table T1 ---- copy of Schema AI have made some changes to Schema B, Table1.When I am doing the distinct values on both the Schema's, it shows me a ......
-
I am trying to install the Oracle 12c 64bit client on a Windows 10 64bit PC. Whenever I run the setup it just quickly pops up a DOS window then immediately closes it. No error messages, nothing.I ......
-
After server re-boot I have problem to login to EM where I am again redirected to login page. But if I stop all services, then start just ORACLE base_domain_AdminServer service, log-in to EM I do not ......
-
I am securiting a server that has a weblogic 12c installation with Oracle forms componenet. When I visit the url http://my-app:port/forms/ I get the following page:Oracle fusion middleware 12c forms ......
-
I have a query that gets contract_types 1 to 10. This query is being used in an SSRS report to filter out a larger dataset. I am using -1 for nulls and -2 for all.I would like to know how we would ......
-
I´ve been trying to create some customer reports but I keep getting stuck on trying to retrive rows that matches two arguments.I need to retrive all rows containing both the OUT_DATETIME where it ......
-
There is such an SQL request:Select (((('<a href="https://help.company.ru/sd/operator/#uuid:serviceCall$'::text || scall.id) || '">'::text) || (scall.title)::text) || '</a>'::......
-
I am having below error on loading of each form having CALENDAR object. Can anybody guide steps to resolve this issue. I am very new to Oracle and no idea about the issue....