Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
how can i use one cursor inside two or more procedure in oracle pl/sql?
The only way to achieve this is trying to declare that cursor in the package level then you can use it in any procedure or function in that package and the logic behind that is any cursor delcared in any function or procedure the scope for this cursor is only in that function below you can find sampRead more
The only way to achieve this is trying to declare that cursor in the package level then you can use it in any procedure or function in that package and the logic behind that is any cursor delcared in any function or procedure the scope for this cursor is only in that function below you can find sample example :
Note: keep in mind in that example below if you open declared cursor in procedure 1 and you didn’t close it if you trying to open the same cursor in the procedure 2 you will get an exception raising
See lessWhat is the difference between varchar and varchar2 data type?
Currently VARCHAR behaves exactly the same as VARCHAR2. However, this type should not be used as it is reserved for future usage VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL andRead more
Currently VARCHAR behaves exactly the same as VARCHAR2. However, this type should not be used as it is reserved for future usage
See lessVARCHAR
is reserved byOracle
to support distinction betweenNULL
and empty string in future, asANSI
standard prescribes.VARCHAR2
does not distinguish between aNULL
and empty string, and never will.If you rely on empty string and
NULL
being the same thing, you should useVARCHAR2
How to check whether partitioning enabled or not in my database ?
we need to execute this select statement to check select * from v$option where parameter = 'Partitioning'; PARAMETER VALUE Partitioning TRUE
we need to execute this select statement to check
how to concatenate two string or two values in oracle sql ?
It is ||, for example: select 'Mr ' || emp_name from employees; or concatenate two column values by : select first_name || '-' || last_namefrom employees;
It is ||, for example:
or concatenate two column values by :
See lessHow to create array variable in oracle pl/sql ?
Basically VARRAY is varying array type that is typically used when the number of instances to be stored is small that means if we have one customer and this customer have number of phone numbers in our case if we know exact how many phone number he has so we will use VARRAY otherwise we will go forRead more
Basically VARRAY is varying array type that is typically used when the number of instances to be stored is small that means if we have one customer and this customer have number of phone numbers in our case if we know exact how many phone number he has so we will use VARRAY otherwise we will go for using nested tables.
You can use VARRAY data type for:
Now We can use VARRAY for a fixed-size array
Or TABLE for an unbounded array like:
for clarification we submit question and it’s answer to help others, please if you have any addition don’t hesitate to share with others here.
See lessDownload MD50 document
hi you can download it from here Click here also you can find MD70 & MD120 with explanation for each document here AIM Documents (MD50, MD70 and MD120) Templates – Download now
hi you can download it from here Click here
See lessalso you can find MD70 & MD120 with explanation for each document here
AIM Documents (MD50, MD70 and MD120) Templates – Download now
how to Order by string in SQL ?
In standard SQL, you need a case statement Select * From people ORDER BY (case when names = 'john' then 1 when names = 'steve' then 2 when names = 'bob' then 3 when names = 'bill' then 4 else 5 ); You can find this article helpful for you in case you are using Oracle database: Oracle Case StatementRead more
In standard SQL, you need a
case
statementYou can find this article helpful for you in case you are using Oracle database:
Oracle Case Statement : (Simple Case, Searched Case)
Some SQL engines have shortcuts to this, but you don’t mention which database you are using.
See lessFor instance, in MySQL you can do:
How to remove blank line when you create list item in oracle forms 10g ?
as per oracle forms online help: Forms maintains an additional NULL element in a list item List Items and Null Values ... Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if itsRead more
as per oracle forms online help:
See lessForms maintains an additional NULL element in a list item
List Items and Null Values … Setting the Required property for a poplist or TList may affect the values the list will display: When selected, an instance of a poplist will display an extra null value if its current value is Null or if its effective Required property is false.
CLEAR_LIST Built-in Clears all elements from a list item. After Oracle Forms clears the list, the list will contain only one element (the null element), regardless of the item’s Required property.