Always ask yourself: Is this matter?
If it’s a No, move on.
If it’s an Yes, work on it.
notes
Is this matter?
notes
Compounding
Compounding is the most effective thing you can use in your life.
notes
Human
Remember you’re a human, not a content creating machine.
notes
Not others
Impress yourself, not others.
notes
Connecting MySQL from command line
Open the command prompt and type the below to connect the MySQL:
mysql -u username -p
After the above command the command line will prompt you to enter the password and after entering the password you can query the database.
References
notes
Non-editionable objects
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
essay
നിനക്കൊരർച്ചന
ആളിറങ്ങിയാരവം നിലച്ചപ്പോൾ വസന്തത്തിൻ രാവ് കൊഴിഞ്ഞു. ഇനി ഞാൻ തനിച്ചിവിടെ ഈ തെരുവിൽ.....
notes
മകൾ
ഒരു നിമിഷാർദ്രം കൊണ്ട്
സ്മൃതിപഥത്തിൽ നീയുണർന്നു.
നമുക്കൊരു ആൾരൂപം
നിൻ്റെയുള്ളിലുണ്ടെന്നുള്ള സത്യം
ശിശിരകാലം പോലെയെന്നിൽ
തണ്ണുപ്പ് നിറക്കുന്നു.
essay
Job commands in Oracle PL/SQL
Here I am listing the commands using for creating, running, and fetching the scheduler jobs in Oracle database for easy reference.