You Will Never Get Stuck Again!
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
Join 15000+ Exceptional
Latest Python Wiki's
Python Program to Check Prime Number using While Loop
Prime numbers are an essential concept in mathematics and computer science. They are numbers that are only divisible by 1 and themselves. In ...
Python Delete Variable: How to Free Up Memory Space in Your Code
Introduction: Python is a popular programming language used in a variety of applications, from data analysis to web development. One ...
How to Swap Characters in String in Python – 3 Techniques
Swapping the string is one of the most commonly used operations by programmers. The string is a data type to store the text ...
Latest Data Visualization Wiki's
Python Pandas Date: Parsing, Arithmetic, and Resampling
Pandas is one of the most popular libraries of Python. This data visualization library deals with the operations related to data. In data ...
Exploring Python Pandas Options: Your Data Power Tool
Pandas is a trendy Python library used for data analysis. One of the essential features of data analysis is the options system. This ...
Python Pandas Join: Where Datasets Converge
Introduction The topic of Python Pandas join is crucial for data manipulation and analysis. It is a process of ...
Latest Java Wiki's
Java Variable Types: Are You Using Them Correctly?
Introduction Programs manage data stored in memory. On the machine level, data can only be called by the numeric ...
Java Data Types: The Basics Explained
Introduction Each variable in Java must have a data type. There are several Java data types available. The type determines ...
Java Arrays
Introduction An array is a set of members. Each member can contain an object or primitive value. Arrays in Java ...
Latest Oracle Wiki's
How to Convert Decimal to Hexadecimal in Oracle SQL
Introduction Are you struggling to convert decimal numbers to hexadecimal in Oracle SQL? Don't worry; you are not alone. ...
How to Create Table with Foreign Key in Oracle
Introduction If you are working with large amounts of data in an Oracle database, you may have come across ...
ORA-01034: Oracle Not Available – What is it, Causes, and How to Resolve
Oracle databases are widely used in the industry; sometimes, you may encounter errors when working with them. One such error is the ORA-01034 ...
Latest JavaScript Wiki's
Easily Convert Decimal to Hex in JavaScript Today
As a developer, knowing how to work with different numeral systems is essential. One such system is hexadecimal, which is commonly used in ...
JavaScript Variables
What are JavaScript variables? Variables are simply containers where we can store values. You can simply place the values in ...
JavaScript Syntax
Introduction In HTML documents and webpages JavaScript can be included in two ways. One way is to include the JavaScript ...
Repeat same previous record or item in oracle forms ?
You can use DUPLICATE_RECORD built-in
You can use DUPLICATE_RECORD built-in
See lessHow to find all DB objects that has particular column name ?
Hi,[code] SELECT table_name, column_name FROM user_tab_columns WHERE upper(column_name) LIKE upper('%Last_Name%'); [/code]this in Oracle
Hi,
[code]
SELECT table_name, column_name
FROM user_tab_columns
WHERE upper(column_name) LIKE upper(‘%Last_Name%’);
[/code]
this in Oracle
See lessneed query to display ‘job’ & their counts & then display the no. of distinct ‘dept no’ under each ‘job’ & their counts ?
Hi,[code]SQL> select job, count(*) from scott.emp group by job order by 1;[/code]JOBCOUNT(*)ANALYST2CLERK4MANAGER3PRESIDENT1SALESMAN4 5 rows selected.[code]SQL>select job, count(distinct deptno), count(*)from scott.empgroup by joborder by 1;[/code]JOBCOUNT(DISTINCTDEPTNO)COUNT(*)ANALYST12CLERKRead more
Hi,
[code]
SQL> select job, count(*)
from scott.emp
group by job
order by 1;
[/code]
[code]
SQL>select job, count(distinct deptno), count(*)
from scott.emp
group by job
order by 1;
[/code]
[code]
select job, deptno, count(*)
from scott.emp
group by job,deptno
order by 1,2;
[/code]
In order to put that in a PLSQL procedure, for each SQL you can do
set serverout on
[code]
begin
for i in ( “yoursql” )
loop
dbms_output.put_line( “attributes” );
end loop;
end;
[/code]
hope this help.
See lessWhat is the major differences between ADF and JSF ?
Hi, i found this answer, hope will help you ADF Faces can be used as your JSF implementation or as a component library. If used as your JSF implementation there are differences from the JSF spec such as a longer lifecycle (ADFFaces adds two steps to the original JSF lifecycle) and an additional scopRead more
Hi,
i found this answer, hope will help you
ADF Faces can be used as your JSF implementation or as a component library. If used as your JSF implementation there are differences from the JSF spec such as a longer lifecycle (ADFFaces adds two steps to the original JSF lifecycle) and an additional scope for storing variables longer than request but shorter than session (i.e. in “process scope”).
If you end up using ADF Faces as your JSF implementation, you need to be aware that you are doing things the Oracle JSF implementation way (so you often can only find answers for what you are trying to do in the Oracle documentation, which can be lacking).
See lessHow to show a message in a report at runtime?
hi Albert, You can display a message in Oracle report builder by using the standard built-in srw.message. The basic syntax for using this package is: srw.message(error_no,'YOUR MESSAGE'); the error no will appear along with the message text. and here is the sample to do this in a particular functionRead more
hi Albert,
You can display a message in Oracle report builder by using the standard built-in srw.message.
The basic syntax for using this package is:
the error no will appear along with the message text. and here is the sample to do this in a particular function
See lessConvert number of seconds to Hours:Minutes:Seconds format
Hi, SELECT TO_CHAR(SYSDATE,'SSSSS') FROM DUAL; -- will return like 54071SELECT TO_CHAR(TO_DATE(54071,'SSSSS'),'HH24:MI:SS') FROM DUAL;-- will RETURN like 15:01:11 It will help
Hi,
SELECT TO_CHAR(SYSDATE,’SSSSS’) FROM DUAL; — will return like 54071
SELECT TO_CHAR(TO_DATE(54071,’SSSSS’),’HH24:MI:SS’) FROM DUAL;– will RETURN like 15:01:11
It will help
See lessHow to add “Auto Refresh” feature in EBS submit request form like version 12.2.6?
Hello Beter,here you will find how to implement this functionality inside 12.1.3 + versions:Click Here : Implement Auto Refresh functionality in EBS 12.1.3+
Hello Beter,
here you will find how to implement this functionality inside 12.1.3 + versions:
Click Here : Implement Auto Refresh functionality in EBS 12.1.3+
See lessWhat is the difference between schema and user ?
User is a credential to log-into to the database.Schema is group of objects of databse to be used for same purpose.One schema cam have multiple users to log into
User is a credential to log-into to the database.
Schema is group of objects of databse to be used for same purpose.
One schema cam have multiple users to log into
See lessget number of days between two dates column in oracle sql?
Hi, Like this we can use: SELECT pol_fm_dt, pol_to_dt, ROUND(pol_to_dt - pol_fm_dt) FROM pgit_policy;
Hi, Like this we can use:
See lessHow to execute multiple procedures simultaneously ?
Hi, Its better you can create different jobs for each procedure and setting their time same to start execution.
Hi,
Its better you can create different jobs for each procedure and setting their time same to start execution.
See less