I have a view which has one dummy column called action. I have a formula {@action}
如果 {abc_view.name} 以“abc” 开头,然后 {abc_view. action} = “ represents actions” = “else {abc_view. action} =“ ”
and when I am calling this formula from the record filter section, all I get is action under the dummy column action in crystal reports 2.0 for eclipse. How do I achieve my purpose. Please help me out.
您可以在 Oracle 视图中创建 COL1 和 COL2 列具有如下等实际值的视图时, 硬码在 Oracle 视图中您可以创建此视图
CREATE OR REPLACE VIEW ABC_VIEW
AS
SELECT
CASE WHEN name like ABC%
THEN Represents action
ELSE
ACB.ACTION
END AS ACTION,COL1,COL2 FROM ABC;
An invalid datatype is returned when I issue following command: CREATE TABLE msg_info ( msgcode PLS_INTEGER, msgtype VARCHAR2(30), msgtext VARCHAR2(2000), msgname VARCHAR2(30), ...
We re getting this error once a day on a script that runs every two hours, but at different times of the day. ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04061: ...
Is it possible for Oracle to right justify column heading along with also right justifying the data?
I have a coworker who came across DBMS_SQL.to_refcursor which would be a great solution for him to pass back the refcursor he needs, however we are running Oracle 10g and this feature is only ...
I want to uninstall Oracle 10g (on Windows 7), but I don t see any uninstall tool. How can I uninstall it?
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
I am writing a program in java where I need to create a copy of a table (without data). for that I am using the following query CREATE TABLE NEW_TABLE AS SELECT * FROM OLD_TABLE I have come across a ...
I have a column called THE_VALUE in a table TABLE_A, that holds data similar to the following, i.e a few sample rows might be: tom:harry, sally, jeff state(vic,nsw), england, qwerty(aaa,bbb, cccc):...