Skip to Main Content

Questions

QuestionUpdatedAsked

How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex I am calling https://api.textlocal.in/docs/sendsms...
2 days ago2 weeks ago

When i try to run this code:DECLARE STUDENT_ID NUMBER;BEGIN -- Generate the next value for the sequence SELECT LMS_STUDENT_DETAILS_SEQ.nextval; -- Insert data into LMS_STUDENT_DETAILS table INSERT INTO LMS_STUDENT_DETAILS (STUDENT_ID, STUDEN...
2 days ago12 days ago

According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.Could you please just confirm that 11.2 -> 12.2 is really possible?If so, what about 11.2 -> 19.x ?Or 12.2 -...
2 days ago12 days ago

Tom,I create databases then I run the catalog.sql and catproc.sql. Sometimes, I donot run pupbld.sql. Users may get warning message but they could login and work.But, My friend says that if pupbld.sql is not run as system then users will get the error messages...
2 days ago23.7 years ago

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...
2 days ago7.6 years ago

We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a...
2 days ago3 weeks ago

Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f...
2 days ago2 weeks ago

I have a user defined database package which is used quite heavily. When I need to update the code body, I will get several<code>ORA-04061: existing state of package body "CS.PACKAGE" has been invalidatedORA-04065: not executed, altered or dropped package bod...
4 days ago2 weeks ago

Hi,I used explain plan and got the following results. Based on cost and time, does query 2 perform significantly better than query 1? The runtime for query 1 is approximately 1 minute and 40 seconds, but it shows 07:47:02. Why is the estimated time so differen...
7 days ago13 days ago

Hi, Tom. Please see below script.<code>create table t0326 (id number, num varchar2(100)); declare v_empno number:=125854437665589038536841445202964995521300;begin dbms_output.put_line('v_empno -- ' || v_empno); dbms_output.put_line('to_char(v_empno) -- '||...
7 days ago12 days ago

Hello Tom,A colleague of mine is a big fan of service-oriented architectures and middle-ware. His view is that dblinks are 99.9% of the time a bad idea and that you should go via some sort of message layer in order to pass information between applications.In ...
7 days ago17.1 years ago

We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle da...
12 days ago2 weeks ago

Is 'SELECT * FROM :TABLE_NAME;' available?...
2 weeks ago2 weeks ago

Hello Sir,I am able to get one scenario to work and that scenario was where I had a VM (server) running Oracle 19c with just 1 table 5 records and I did a backup of the whole VM (disk backup) and now I added a new table in my db with 3 records (ensured db is ...
2 weeks ago2 weeks ago

According to https://docs.oracle.com/database/121/SQLRF/functions100.htm#SQLRF00658 the length function should work on a clob and on a varchar2, returning the length of a string in characters, as defined by the input character set.Could you explain why the len...
2 weeks ago2.4 years ago

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...
2 weeks ago8 months ago

Hai all,I have 1000 number of tables. some of the tables got delete rows and updated the fragmentaion is created.How to determine which tables are fragmented ?...
2 weeks ago8.2 years ago

I am migrating 11g database cross endianness from on-prem to EXACS . On-prem database db_block_size is 4k and all the tablespaces are also of 4k block size . <u>Since, I cannot provision non-standard block size database in OCI</u> , I am worried about the per...
2 weeks ago2 weeks ago

How to connect oracle database / data set into Power BI, I already searched from google and youtube but I can't do it please help.Thank you....
2 weeks ago3 weeks ago

Hi,We are trying to compile following class in Oracle database 23c. However, we are encountering surprising error (we are not using ANY database link:Error report -ORA-04054: database link MYOPTIMIUM does not exist04054. 00000 - "database link %s does not exi...
2 weeks ago3 weeks ago