Is it possible to create a file system directory from a procedure in Oracle 10g?
I got a Database link from Oracle 10gR2 to Postgre 9.5 and i'm having an issue when trying to run a few commands.
I executed a few queries from pl/sql and it works sometimes but sometimes…
I have levels as below ps_level
level1 level2 level3 level4 level5 level5 level6
101 101 101 101 101 101 101
101 102 102 102 102 102 102
101 102 …
I am migrating MSSQL db to Oracle 12c , using the migration tool in sql developer. I am not getting any data after the data move final step.
Migration steps …
hi i have the following cursor in my 12c database
am geting the above error but in 11g is ok am running this in plugable database
hi am having this error when starting my db
I have below command , it is giving only some part of BLOB. Can you please suggest some modification through which I get all the text from the blob (output).
I am looking for some detailed documentation on Creating Indexes on a Materialized view. I googled, but did not find any thing recent.
I'm working with a MS Access database that was developed by someone else.
I've converted this database to work in the Windows 10 environment with MS Access 2016. Since converting the database to …
I need a skeleton Oracle function that does the following:
1. Enter record into table1
2. Get ID of entered record
3. Enter 5 records into table2 using the ID from the first table and 5 passed …
The following statements return numbers from a-z but I need a new column to calculate the change as a number.
For example, if the letter for Q1 is B and Q2 is D, then the output would be +2. If Q1 …
Iam trying to run the below code , Iam getting the below error.
type t_empid is varray(2) of EMPLOYEES.EMPLOYEE_ID%type;
cursor c1 is
Select brand_dsc …
Im trying to help a coworker figure out why this query isnt working in SQL Developer. Its a procedure in a package and the Insert doesnt work. The Select that is feeding the Insert brings back plenty …
How to find the creation date for each pdb
We are unable to find out each PDB creation time in our 12c database. Tried scn_to_timestamp(create_scn) from v$containers but it errors:
In the below code
If the query has no rows returned I want to do the following
INSERT INTO AUDIT_DEVDB_HIST (DATABASENAME,TIME,MACHINE,USERNAME,SESSIONS,LOG)
VALUES ( …
I have a scenario where I have to run a query on multiple databases from a database "A" using database links from "A" database.
I have a table in "A" database which should insert the pulled data from…
I have been following the troubleshooting article for an ORA-12154: TNS error issue.
Hello. I have a question pertaining to preventing a commit of one record, while still going through and comitting all other records that have changes.
Basically, it's a form that displays multiple …
Need to know where the actual time values come from in my Oracle database. For example for columns DATETIME, SYSTIME, or SYSTIMESTAMP - the values for these datatyped-columns is the time on the …
I had this question after viewing pl/sql - query very slow (https://www.experts-exchange.com/questions/28999908/pl-sql-query-very-slow.html).
The query takes 20 seconds
I am to connect to SQL server 2016 from sql developer using Third Party JDBC Drivers. Used windows authentication
basically following Migration …
We have certain field whose name has a special character, in this case its an spanish "Ñ" the field name is "año" (Year) and when we execute the next sentence it returns the next error:
We just moved to Windows 10 as a company and I have VBA code that uses and ODBC to connect and pull data from an oracle database.
When I try to launch the code in Excel 2016 in windows 10 I was …
hi experts, this query is very slow
SELECT LTRIM(TO_CHAR(cccnumcot, '099999')) "Numero",
TO_CHAR(cccfeccot, 'DD/MM/YYYY') "Fecha",
SUBSTR(cccnomatn, 1, 30) "Atencion",
The query below returns results that only equal the minimum PAY_CLASS which is 01. How can I return only one result per EMPLOYEE_NO where their minimum PAY_CLASS could be higher than 01? Thanks!