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.
Search all columns of the database oracle SQL
To find The tables which contain a particular column name, you can use the following query: SELECT owner, table_name, column_name FROM all_tab_columns WHERE column_name LIKE '%TRANSACTION_QUANTITY%'; The output of this select statement would be: You can get the result from a specific owner schema liRead more
To find The tables which contain a particular column name, you can use the following query:
The output of this select statement would be:
You can get the result from a specific owner schema like ‘INV’ and so on.
You may also be interested in checking my answer to other related questions from here Get Column Name from Table in Oracle
See lessHow to copy a table without data in oracle?
To copy a table without copying its data, you can simply use this SQL statement: CREATE TABLE xx_oraask_tbl_bkp AS SELECT * FROM xx_oraask_tbl WHERE 1=0; But there is a limitation to using the above statement that you have to pay attention to: The following database objects are not copied to the newRead more
To copy a table without copying its data, you can simply use this SQL statement:
But there is a limitation to using the above statement that you have to pay attention to:
The following database objects are not copied to the new version of your table
Or you can use another way to do this:
In the above statement, you will get the DDL statement of a specified table, and then you can easily change the table name, the indexes, etc.
See lessHTTP request failed ORA-29270: too many open HTTP requests
This error is thrown because there is a limit of 5 open HTTP connections per session in the Oracle database server. Usually, the application intends to open one connection at a time. However, this error might occur due to the application not closing the connection properly after being finished. So,Read more
This error is thrown because there is a limit of 5 open HTTP connections per session in the Oracle database server.
Usually, the application intends to open one connection at a time. However, this error might occur due to the application not closing the connection properly after being finished.
So, it’s recommended to review your code and to make sure you are ending the response after you have finished as well as in the exception part also, ending the request like the below code.
Catch too many requests exception to handle it by closing the request and response:
Ending the request at the end of your program
See lessIs it recommended to increase the length of a DFF attribute in standard table
It's not as simple as changing the ATTRIBUTE column size because there are a lot of dependencies that you need to pay attention to e.g. Changes to other tables that may be related to your table, like (interface tables). Check the form that is used in this ATTRIBUTE. Check code that may require a chaRead more
It’s not as simple as changing the ATTRIBUTE column size because there are a lot of dependencies that you need to pay attention to e.g.
That’s why it is not simple; moreover, DFF ATTRIBUTES default length of “150” characters is a coding standard used for most standard tables.
See lessHow can I define a global variable in java
There is no global variable in Java. However, we have a static keyword that we can use to define a global variable by doing something like the below: public class A { public static String var1 = "Oraask"; public static int var2 = 37; } A.var1; A.var2; But be careful because if this class gets unloadRead more
There is no global variable in Java. However, we have a static keyword that we can use to define a global variable by doing something like the below:
public class A { public static String var1 = "Oraask"; public static int var2 = 37; }But be careful because if this class gets unloaded, you will end up with an undefined null error that is difficult to catch.
See lessORA-01417: a table may be outer joined to at most one other table
Before Oracle database release 12c, the error ORA-01417 is raised when you have more than one table on the left-hand side of an outer join. To overcome this limit, we can convert the join to an ANSI syntax, e.g.: SELECT * FROM EMPLOYEES E LEFT JOIN DEPARTMENTS D ON (D.DEPARTMENT_ID = E.DEPARTMENT_IDRead more
Before Oracle database release 12c, the error ORA-01417 is raised when you have more than one table on the left-hand side of an outer join. To overcome this limit, we can convert the join to an ANSI syntax, e.g.:
From the 12c version, Oracle has supported having multiple tables on the left-hand side of the join.
See lessTablespace size
Find below the query to find the free space of a tablespace: SELECT DFQ.TABLESPACE_NAME "Tablespace Name" ,DFQ.TOTALSPACE "Total Size MB" , (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) "Free Space MB" ,ROUND (100 * ( (DFQ.TOTALSPACE - DSQ.TOTALUSEDSPACE) / DFQ.TOTALSPACE)) || '%' "Free Space %" FROM (SELECRead more
Find below the query to find the free space of a tablespace:
Also, you can refer to this article to find a handful of detail about the tablespace:
Check Tablespace Usage in Oracle
See lessCreate Item not showing up in Personalize Table
You went in-depth, and to reach this point, I believe it's better to log SR with Oracle to ask them if they have something else (I doubt) or to get a confirmation that these attributes are used as DFF attributes. They are updatable through the backend without any other impact. If they verified to upRead more
You went in-depth, and to reach this point, I believe it’s better to log SR with Oracle to ask them if they have something else (I doubt) or to get a confirmation that these attributes are used as DFF attributes. They are updatable through the backend without any other impact.
If they verified to update these columns, you could do that by extending the controller to do the job on your own.
See lessCreate Item not showing up in Personalize Table
Firstly, It's ok to use dates in varchar attributes; that's why Oracle makes it varchar to accept multiple data types in the form of character, and later on, we can deal with it by converting that to date or number. The second point is the VO; try to look into this VO instead of the ones you were loRead more
Firstly, It’s ok to use dates in varchar attributes; that’s why Oracle makes it varchar to accept multiple data types in the form of character, and later on, we can deal with it by converting that to date or number.
The second point is the VO; try to look into this VO instead of the ones you were looking at
oracle.apps.pos.supplier.server.BCAttrVO oracle.apps.pos.supplier.server.BCAttrEO
This one is updateable VO.
Finally, you can add one of the general attributes that exist on the POS_BUS_CLASS_ATTR table
See lessby extending above VO and making this field updatable.
Create Item not showing up in Personalize Table
There are two columns already that may fits your need. START_DATE_ACTIVE Date when the classification becomes active for the supplier END_DATE_ACTIVE Date when the classification becomes inactive for the supplier However, if you need to capture more additional informations in any standard tables, OrRead more
There are two columns already that may fits your need.
START_DATE_ACTIVE
Date when the classification becomes active for the supplier
END_DATE_ACTIVE
Date when the classification becomes inactive for the supplier
However, if you need to capture more additional informations in any standard tables, Oracle recommended to capture those additional information through out a DFF attributes. In this table you have 5 addition attributes to use them. Therefore, Oracle not recommended to add any additional physical columns on any standard table.
See less