Essays, poems, and personal reflections from the desk and drawer.

notes

Non-editionable objects

10 February 2024

When you are create an object in Oracle Database, default object type will be marked editionable. From 12c onwards, you can mark the objects as noneditionable , and same you cannot edit with create or replace . For altering the same you have to alter the object and change to editionable.

This is applicable to View, Funcitons, Procedure, Trigger, Library, Type.

create or replace noneditionable procedure test_proc ( p int ) as
begin
  null;
end;
select editionable from user_objects
where  object_name = 'test_proc ';

//result
EDITIONABLE   
N
create or replace procedure test_proc ( p int ) as
begin
  dbms_output.put_line ( 'Editionable version' );
end;

//result
ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.

With below you can alter the procedure.

alter procedure test_proc editionable;
create or replace procedure test_proc ( p int ) as
begin
dbms_output.put_line ( 'Editionable version' );
end;

exec test_proc (1);

//result
Editionable version
References

Oracle Doc

essay

നിനക്കൊരർച്ചന

9 February 2024

ആളിറങ്ങിയാരവം നിലച്ചപ്പോൾ വസന്തത്തിൻ രാവ് കൊഴിഞ്ഞു. ഇനി ഞാൻ തനിച്ചിവിടെ ഈ തെരുവിൽ.....

notes

മകൾ

9 February 2024

ഒരു നിമിഷാർദ്രം കൊണ്ട്
സ്മൃതിപഥത്തിൽ നീയുണർന്നു.
നമുക്കൊരു ആൾരൂപം
നിൻ്റെയുള്ളിലുണ്ടെന്നുള്ള സത്യം
ശിശിരകാലം പോലെയെന്നിൽ
തണ്ണുപ്പ് നിറക്കുന്നു.

essay

Job commands in Oracle PL/SQL

2 February 2024

Here I am listing the commands using for creating, running, and fetching the scheduler jobs in Oracle database for easy reference.

essay

Nights in Bahrain

1 February 2024

I'm a night owl who loves the dark hours. I often go for walks at night, enjoying the city lights, the yellow glow, and the people around me.

essay

As you start to walk on the way, the way appears

31 January 2024

I would like to share a short story from my college days. As part of our college tech festival,

notes

Export your Kindle book highlights

24 January 2024

If you want to export your Kindle book highlights without the page location and color information, you can follow these steps:

  • Export the content in any format you prefer.
  • Paste the content in Visual Studio Code or any other text editor that supports regular expressions.
  • Use the regular expression Highlight \(yellow\) - Location [0-9]+ in the Find and Replace tool to replace Highlight (yellow) - Location 01.
  • Replace all the matches with an empty string.

This will remove the unwanted details from your highlights and leave only the text you want to keep.

essay

Default Apps 2023

21 January 2024

Read the Defaults app of Chris Coyier and found interesting.

notes

Name attribute in input tag

15 January 2024

The name attribute specifies the name of an <input> element. It is used to reference elements in a JavaScript, or to reference form data after a form is submitted to the server.

Only form elements with a name attribute will have their values passed when submitting a form.

<form action="http://localhost" method="POST">
    <label for="User">User name</label>
    <input type="text" id="User" name="Name" value="bino" />
    <input type="submit" value="submit" />
</form

When you submit the above, server localhost will recive a content like below:

Name=bino
References

w3schools