call form from url oracle forms 12c

Go to the formsweb.cfg file then scroll down and write:

Here test_web will be your project name like sales then location of the forms file.

 [test_web]

form=D:\SIS_Forms\LOGIN_FORM.fmx

usesdi=yes

userid=sales/s@ora19

Some Oracle-Supplied Packages

 • DBMS_OUTPUT 

 • UTL_FILE 

 • UTL_MAIL

 • UTL MAIL 

 • DBMS_ALERT 

 • DBMS_LOCK

 • DBMS_SESSION  

 • DBMS APPLICATION INFO 

 • HTP 

 • DBMS_SCHEDULER

ORA-03113: end-of-file on communication channel

 SQL> startup

ORACLE instance started.

Total System Global Area 4294964000 bytes

Fixed Size                  9143072 bytes

Variable Size            1577058304 bytes

Database Buffers         2701131776 bytes

Redo Buffers                7630848 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 46641

Session ID: 259 Serial number: 54397

SQL> STARTUP MOUNT;

SP2-0642: SQL*Plus internal error state 2133, context 3114:0:0

Unsafe to proceed

ORA-03114: not connected to ORACLE

SQL> sqlplus

SP2-0042: unknown command "sqlplus" - rest of line ignored.

SQL>

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@vmi2001271 ~]$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Sep 10 09:15:03 2024

Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> SHUTDOWN IMMEDIATE;

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Additional information: 4376

Additional information: -896098569

Process ID: 0

Session ID: 0 Serial number: 0

SQL> shutdown abort

ORACLE instance shut down.

SQL> STARTUP MOUNT;

ORACLE instance started.

Total System Global Area 4294964000 bytes

Fixed Size                  9143072 bytes

Variable Size            1577058304 bytes

Database Buffers         2701131776 bytes

Redo Buffers                7630848 bytes

Database mounted.

SQL> ^C

SQL> startup nomount

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL>  alter database clear unarchived logfile group 2;

Database altered.

SQL>  alter database clear unarchived logfile group 1;

Database altered.

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 4294964000 bytes

Fixed Size                  9143072 bytes

Variable Size            1577058304 bytes

Database Buffers         2701131776 bytes

Redo Buffers                7630848 bytes

Database mounted.

Database opened.

CV Design Using PLSQL Dynamic Content

 declare

    cursor c_emp is

        SELECT j.Emp_reg_id,

               (p.First_name || ' ' || p.last_name) Name,

               p.father_name,

               p.mother_name,

               p.Address,

               p.Phone,

               p.email,

               p.date_of_birth,

               p.religion,

               p.blood_group,

               p.Nationality

          FROM job_seeker_registration j

               JOIN Personal_details p ON j.emp_reg_id = p.emp_reg_id

        WHERE j.emp_reg_id = :G_EMP_ID;

    cursor c_academic_details is

        SELECT 

               a.Name_of_degree,

               a.Subject,

               a.Name_of_institute,

               a.Duration,

               a.result

          FROM academic_details a

        WHERE a.emp_reg_id = :G_EMP_ID;

        --

        cursor c_experience is 

           SELECT 

              e.job_title,

               e.dept_name,

               to_number(ROUND((e.End_date - e.Start_date) / 365)) Year_Of_Experience

          FROM experience_details e

WHERE e.emp_reg_id= :G_EMP_ID;

       ---

       cursor  c_skills is  SELECT 

                s.Skill_name,

               s.skill_level

          FROM skills s

WHERE s.emp_reg_id= :G_EMP_ID;

        ---

        cursor   c_references is SELECT 

             r.Reference_name,

               r.Designation,

               r.contact_no

          FROM REFERENCES r

WHERE r.emp_reg_id= :G_EMP_ID;

begin

    for rec in c_emp loop

        htp.p('<div style="border: 1px solid #000; padding: 20px; margin-bottom: 20px; font-family: Arial, sans-serif;">');

        htp.p('<h1 style="text-align: center;padding:0%;">Curiculam Vitae Of</h1>');

        htp.p('<h2 style="text-align: center;padding:0%;">' || rec.Name || '</h2>');

        htp.p('<h4 style="text-align: center;padding:0%;"><strong>Address:</strong> ' || rec.Address || '</h4>');

        htp.p('<h4 style="text-align: center;padding:0%;"><strong>Phone:</strong> ' || rec.Phone || '</h4>');

        htp.p('<h4 style="text-align: center;padding:0%;"><strong>Email:</strong> ' || rec.email || '</h4>');

        htp.p('<h2>Personal Information</h2>');

        htp.p('<p><strong>Father Name:</strong> ' || rec.father_name || '</p>');

        htp.p('<p><strong>Mother Name:</strong> ' || rec.mother_name || '</p>');

        htp.p('<p><strong>Address:</strong> ' || rec.Address || '</p>');

        htp.p('<p><strong>Phone:</strong> ' || rec.Phone || '</p>');

        htp.p('<p><strong>Email:</strong> ' || rec.email || '</p>');

        htp.p('<p><strong>Date of Birth:</strong> ' || rec.date_of_birth || '</p>');

        htp.p('<p><strong>Religion:</strong> ' || rec.religion || '</p>');

        htp.p('<p><strong>Blood Group:</strong> ' || rec.blood_group || '</p>');

        htp.p('<p><strong>Nationality:</strong> ' || rec.Nationality || '</p>');

    end loop;

begin

  

  --academic

    htp.p('<h2>Academic Details</h2>');

    htp.p('<table border="1" style="width: 100%; border-collapse: collapse;">');

    htp.p('<tr><th>Degree</th><th>Subject</th><th>Institute</th><th>Duration</th><th>Result</th></tr>');

    for rec_academi in c_academic_details loop

        htp.p('<tr>');

        htp.p('<td>' || rec_academi.Name_of_degree || '</td>');

        htp.p('<td>' || rec_academi.Subject || '</td>');

        htp.p('<td>' || rec_academi.Name_of_institute || '</td>');

        htp.p('<td>' || rec_academi.Duration || '</td>');

        htp.p('<td>' || rec_academi.result || '</td>');

        htp.p('</tr>');

    end loop;

       htp.p('</table>');

    --Experiences

     htp.p('<h2>Experience Details</h2>');

        htp.p('<table border="1" style="width: 100%; border-collapse: collapse;">');

        htp.p('<tr><th>Job Title</th><th>Department</th><th>Years of Experience</th></tr>');

    for rec_experience in c_experience loop

     htp.p('<tr>');

        htp.p('<td>' || rec_experience.job_title || '</td>');

        htp.p('<td>' || rec_experience.dept_name || '</td>');

        htp.p('<td>' || rec_experience.Year_Of_Experience || '</td>');

        htp.p('</tr>');

        htp.p('</table>');

    end loop;

   

    

--SKILLS

    htp.p('<h2>Skills</h2>');

        htp.p('<table border="1" style="width: 100%; border-collapse: collapse;">');

        htp.p('<tr><th>Skill Name</th><th>Skill Level</th></tr>');

for rec_skills in c_skills

        Loop

        htp.p('<tr>');

        htp.p('<td>' || rec_skills.skill_name || '</td>');

        htp.p('<td>' || rec_skills.skill_level || '</td>');

        htp.p('</tr>');

        htp.p('</table>');

        end loop;

---REFERENCES

          htp.p('<h2>References</h2>');

        htp.p('<table border="1" style="width: 100%; border-collapse: collapse;">');

        htp.p('<tr><th>Name</th><th>Designation</th><th>Contact No</th></tr>');

        htp.p('<tr>');

for rec_references in c_references

        loop

  htp.p('<tr>');

        htp.p('<td>' || rec_references.Reference_name || '</td>');

        htp.p('<td>' || rec_references.Designation || '</td>');

        htp.p('<td>' || rec_references.contact_no || '</td>');

        htp.p('</tr>');

        htp.p('</table>');

        end loop;

    htp.p('</table>');

    htp.p('</div>');

    end;

end;

Algorithms to Live By: The Computer Science of Human Decisions

 Algorithms to Live By: The Computer Science of Human Decisions

In this excellent book, Brian Christian and Tom Griffiths, explain how regular people use algorithms without even realizing it in their day-to-day lives, and how we can learn from computer science to make better decisions in various aspects of our lives, from finding a spouse to finding a parking spot, from organizing our inbox to peering into the future. Here are seven, eye-opening and powerful lessons from the book that I hope will intrigue you:

1. Optimal Stopping:

The book teaches us how to decide when to stop looking for something and settle for the best option we have found so far, whether it is a house, a job, or a partner. The book reveals the surprising mathematical formula that can help us maximize our chances of finding the optimal choice, and why it is sometimes better to act sooner rather than later.

2. Explore/Exploit:

The book shows us how to balance the trade-off between exploring new possibilities and exploiting existing ones, whether it is trying a new restaurant, reading a new book, or sticking to our favorites. The book explains the different strategies that can help us optimize our happiness, and why sometimes randomness can be the best policy.

3. Sorting:

The book demonstrates how to sort and organize our data and information, whether it is our email inbox, our closet, or our bookshelf. The book reveals the different algorithms that can help us sort things faster, easier, and more efficiently, and why sometimes messiness can be a virtue.

4. Caching:

The book illustrates how to manage our limited memory and attention, whether it is our computer's RAM, our brain's working memory, or our smartphone's notifications. The book reveals the different algorithms that can help us decide what to keep, what to discard, and what to retrieve, and why sometimes forgetting can be a blessing.

5. Scheduling:

The book instructs us how to schedule our tasks and activities, whether it is our to-do list, our calendar, or our meetings. The book reveals the different algorithms that can help us prioritize, allocate, and execute our work, and why sometimes procrastination can be a good thing.

6.Bayesian Reasoning:

The book guides us how to update our beliefs and opinions, whether it is our political views, our medical diagnosis, or our personal preferences. The book reveals the different algorithms that can help us incorporate new evidence, weigh probabilities, and make predictions, and why sometimes intuition can be misleading.

7. Networking:

The book advises us how to interact with others and cooperate, whether it is our family, our friends, or our colleagues. The book reveals the different algorithms that can help us negotiate, collaborate, and compete, and why sometimes altruism can be the best strategy.

I hope you enjoyed reading my review of this excellent book, and that it piqued your interest and curiosity to dive into the pages of the book. I highly recommend you satisfy your curiosity by picking this book up! 

BOOK: https://amzn.to/3wCN9gz

You can get the audiobook for FREE by using the same link above when you register on the Audible platform.

How to Export Pluggable database specific user or schema

 C:\export--directory name,manually build in a folder as your wish.

go to cmd as administrator mode.

connect to sys

alter session set container=orclpdb;

create directory exp_schema as 'C:\export';

GRANT read,write on DIRECTORY exp_schema TO SAMITY;

GRANT DATAPUMP_EXP_FULL_DATABASE TO samity;

expdp samity/samity@//107.167.94.211:1521/orclpdb DIRECTORY=exp_schema DUMPFILE=samitydb110524.dmp LOGFILE=samity_lg.log SCHEMAS=samity

Oracle 19c Install on Centos 7

 --First connect the root 

user name :root

password: your root password 

--Now check the Machine Ram

grep MemTotal /proc/meminfo

--Check the Swap Space

grep SwapTotal /proc/meminfo