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.
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".
How to get Column Names from a Table in Oracle
To get the list of columns of a table in Oracle, we use to query the view "USER_TAB_COLUMNS" to get the columns of the tables or views owned by the current user. Or use the other view "USER_TAB_COLS". SELECT table_name ,column_name ,data_type ,data_length ,nullable ,data_default FROM user_tab_columnRead more
To get the list of columns of a table in Oracle, we use to query the view “USER_TAB_COLUMNS” to get the columns of the tables or views owned by the current user. Or use the other view “USER_TAB_COLS“.
in the above query, we selected 7 columns to retrieve the most important information that you might be looking for in table columns which are
Note: you have to specify the table name parameter in uppercase.
Note 2: If you use the above view, you will get all unhidden columns, but if you query the view “USER_TAB_COLS” you will get all columns, including hidden columns.
Another view is “ALL_TAB_COLUMNS” this one is the same as “USER_TAB_COLUMNS” except that the “ALL_TAB_COLUMNS” view has a column called “OWNER” in which you can specify the owner of the table that you want to get its columns list.
See lessRead Only Status Monitor function
Yes, It's possible to achieve this by following these steps: 1- create a menu that has status monitor function and two other sub-menu, "Workflow Configuration tab" and "workflow administrator notification tab". 2- assign this menu to your responsibility. 3- create a grant through a functional adminiRead more
Yes, It’s possible to achieve this by following these steps:
1- create a menu that has status monitor function and two other sub-menu, “Workflow Configuration tab” and “workflow administrator notification tab”.
2- assign this menu to your responsibility.
3- create a grant through a functional administrator for your responsibility to all or specific users
4- exclude the above two menus from the responsibility.
That’s it.
And for the detailed steps with screenshots, I will write an article to showcase this process step by step and will update this answer later on by leaving the article link.
stay tuned 🙂
See lessINV_ITEM_CATEGORY_PUB.update_category_assignment API returned status ‘E’ but without error message
Sometimes this due to Item Categories Key flexfields needs to be recompiled. So, follow this steps to recompile Item Categories KFF: Go to System Administrator > Application > Flexfield > Key > Segments Query for: Flexfield - Item Categories Query or Select your KFF Structure Uncheck theRead more
Sometimes this due to Item Categories Key flexfields needs to be recompiled.
So, follow this steps to recompile Item Categories KFF:
Flexfield – Item Categories
Now retest the API again.
See lessWhat are GL Tables in Oracle APPS R12
The list of GL Table are: GL_LEDGER GL_JE_HEADERS GL_JE_LINES GL_CODE_COMBINATIONS GL_BALANCES GL_JE_BATCHES GL_IMPORT_REFERENCES GL_PERIODS GL_CURRENCIES GL_DAILY_RATES Queries and Description of each GL Table: gl_ledgers stores all ledger pieces of information. SELECT * FROM gl_ledgers; gl_je_headRead more
The list of GL Table are:
Queries and Description of each GL Table:
E37: No write since last change (add ! to override) how to solve
Since you didn't change anything in the file, just exit the file using :q! Instead of :q In this way, you will exit the file without saving it. Discard the changes. For your further information: :q! : /* This Command is used to quit without save the changes */ :wq : /* This command is used to save tRead more
Since you didn’t change anything in the file, just exit the file using :q! Instead of :q
In this way, you will exit the file without saving it. Discard the changes.
For your further information:
APP-FND-01388: Cannot Read Value For Profile Option FND_DEVELOPER_MODE In Routine &ROUTINE On Asset Workbench
Error Cause: The profile option FND:Developer Mode is set to Yes Solution: Set the profile option FND:Developer Mode to No If the developer mode is on, this verifies numerous coding standards and ensures that you can see detailed error messages for unexpected exceptions. It is not recommended to usRead more
Error Cause:
The profile option FND:Developer Mode is set to Yes
Solution:
Set the profile option FND:Developer Mode to No
If the developer mode is on, this verifies numerous coding standards and ensures that you can see detailed error messages for unexpected exceptions. It is not recommended to use developer mode for a testing environment as all
the code is not compliant to pass the developer mode coding standards.
As reference from Doc ID 1513711.1
See lessPO Approval Error: Line # 1 Schedule # 1 Distribution # 1 The Accounting date is not in an open encumbrance period
Error Cause: The PO distributions have a GL Date of a Closed period. Therefore, the error message "The Accounting date is not in an open encumbrance period" is correct. Solution: In order to approve the PO, do one of the following: a) Re-open the SEP-15 period, or b) Change the GL Date on the distriRead more
Error Cause:
The PO distributions have a GL Date of a Closed period. Therefore, the error message “The Accounting date is not in an open encumbrance period” is correct.
Solution:
In order to approve the PO, do one of the following:
a) Re-open the SEP-15 period, or
b) Change the GL Date on the distributions to a new date that is within an ‘Open’ period.
The PO cannot be approved/reserved if the dates on the distribution do not fall within an open period.
As reference from Doc ID 2076668.1
See lessWhat is the use of LIMIT and OFFSET in SQL
We will be using below Students table to explain the Example Queries:- If there are a large number of tuples satisfying the query conditions, it might beresourceful to view only a handful of them at a time. The LIMIT clause is used to set an upper limit on the number of tuplesreturned by SQL. It isRead more
We will be using below Students table to explain the
Example Queries:-
If there are a large number of tuples satisfying the query conditions, it might be
resourceful to view only a handful of them at a time.
returned by SQL.
FIRST clauses.
Example Queries to demonstrate LIMIT Clause.
FROM Students
LIMIT 3;
Output of the query gives First three Student Records.
FROM Students
ORDER BY age
LIMIT 3;
Output of the query gives three Student Records in order of Ascending Ages.
The LIMIT operator can be used in situations such as the above, where we need to
find the top N students in a class and based on any condition statements.
Using LIMIT along with OFFSET
LIMIT x OFFSET y simply means skip the first y entries and then return the next x
entries.
OFFSET can only be used with the ORDER BY clause. It cannot be used on its own.
OFFSET value must be greater than or equal to zero. It cannot be negative, else
returns error.
Example query to demonstrate LIMIT and OFFSET.
FROM Students
LIMIT 3 OFFSET 2
ORDER BY roll_no;
Returns 3 Student Records skipping first two records in Table.
What are the differences between SQL and PL/SQL in Oracle
SQL- SQL, is Structural Query Language for database. SQL has no variables. SQL is data oriented languages. SQL is very declarative in nature. SQL is used in manipulating data. SQL tells data what to do ? PLSQL- PL/SQL is a programming language using SQL for a database. PL/SQL has variables, data typRead more
SQL-
PLSQL-
What is the use of ADD, DROP and MODIFY Commands
ALTER TABLE is used to add, delete/drop or modify columns in the existing table. It is alsoused to add and drop various constraints on the existing table. ALTER TABLE - ADD ADD is used to add columns into the existing table. Sometimes we may require to addadditional information, in that case we do nRead more
ALTER TABLE is used to add, delete/drop or modify columns in the existing table. It is also
used to add and drop various constraints on the existing table.
ALTER TABLE – ADD
ADD is used to add columns into the existing table. Sometimes we may require to add
additional information, in that case we do not require to create the whole database
again, ADD comes to our rescue.
Syntax:
ADD (Columnname_1 datatype,
Columnname_2 datatype,
Columnname_n datatype);
ALTER TABLE – DROP
DROP COLUMN is used to drop column in a table. Deleting the unwanted columns from
the table.
Syntax:
DROP COLUMN column_name;
ALTER TABLE-MODIFY
It is used to modify the existing columns in a table. Multiple columns can also be modified
at once.
Syntax may vary slightly in different databases. Syntax(Oracle,MySQL,MariaDB):
MODIFY column_name column_type;
Syntax(SQL Server):
ALTER COLUMN column_name column_type;
Queries
Sample Table:
Student
1 Ram
2 Abhi
3 Rahul
4 Tanu
QUERY:•
To ADD 2 columns AGE and COURSE to table Student
OUTPUT:
1 Ram
2 Abhi
3 Rahul
4 Tanu
• MODIFY column COURSE in table Student
After running the above query maximum size of Course Column is reduced to 20
from 40.
ALTER TABLE Student DROP COLUMN COURSE;
ROLL_NONAMEAGE
1 Ram
2 Abhi
3 Rahul
4 Tanu