I am having SQL query as "select * from all_objects where owner = : owner;". Can it be possible to create prompt with this query in cognos 10.2.2.Please suggest me.
Is it possible to pass parameter in the cognos by SQL?
2.8k Views Asked by lucky At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in PLSQL
- How to send message to syslog agent in plsql
- In PLSQL, How to fetch "User Tables" but not limited to Owner wise only, that have been created under different Schemas of different Users
- How to add the decimal point based on the condition in oracle?
- I am writing the sql query to get the latest supervisor and their job
- How to pass a array object to an oracle stored procedure?
- Difference between an "IS" or "AS" function/procedure declaration PL/SQL
- Best way to create a conditional SQL query? CASE, DECODE, or IF/THEN?
- Can anyone please post working code to send email using sendgrid on Azure databse using PLSQL procedure
- Retrieve record specific date and time in Oracle SQL
- Need to use join result into second cursor in PL/SQL
- ORACLE: Build 'INSERT INTO' statements from 'SELECT *' results
- ORACLE: Build 'INSERT INTO' statements from SELECT * results
- Error in Syntax - Oracle APEX - apex_authorization.is_authorized function
- How to convert CLOB to varchar , and separate them by comma
- Please, my Oracle EBS query when creating a custom report still contains duplicate data,
Related Questions in COGNOS-10
- Should always pull the monday of the week beginning
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- Cognos Report not returning the total of a calculation in the report
- Cognos excel report name not showing based on page break while scheduling why?
- Difficulty displaying a date in a Cognos BI 10.2.2 crosstab node member
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Errors in cognos schedule by trigger
- Total value on the x axis using Marimekko widget using IBM Cognos
- How to generate Authentication Token in Cognos Analytics 11.x
- Cognos 10 Row cumulative expression
- Need a help to Run reports without html pagination
- Cognos Analytics Rest Api/Api-docs 404 not found issue
- Cognos 10 Framework manager crashes with 'BMTUI2' error. 'An error is at the origin of this program malfunction. Close the program'
- How to show data label values in Cognos 11
Related Questions in COGNOS-BI
- Should always pull the monday of the week beginning
- Cognos Audit User: Read-Only to Everything
- Cognos External Report Server process BIBusTKServerMain & BmtMDProviderMain cannot be started
- Looking for a few sample XML report files for Cognos 10 or 11
- Cognos Analytics 11 - Decimal length won't exceed 8 decimal places
- Using the Cogos Analytics REST API from PowerShell
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- How to Hide a line in cognos if List does not have any data
- Formatting date - Cognos Report Studio
- Login via URL in IBM Cognos Analytics
- Cognos Report not returning the total of a calculation in the report
- Cognos excel report name not showing based on page break while scheduling why?
- Error: unable to insert an object of type list cell in the selected location
- Invalid Variable After Being Validated (Cognos BI)
- Cognos Calculate Variance between dates
Related Questions in COGNOS-8
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Cognos Report Studio: CASE and IF Statements
- Join and max date with null values
- Filter the data in one query based on the result from another query in Cognos
- CognosTM1 Error: Syntax Error on or before Value
- Cognos : create custom groups in report studio
- Applying custom colors to bar charts in Cognos11
- Migrating Reports From Cognos8 to SSRS Report Builder 3
- CASE statement in Report Studio filters
- Congnos Ranking lowest as Rank 1
- Cognos framework join issue
- sqlopenresult' status='-239' / cognos report error
- Cognos Reports are not distributed to al the mail id's
- Need help building a Data Item in Cognos Report Studio
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can use a prompt macro. The SQL with the macro would look something like this:
The third parameter of the prompt() function specifies a default value. If you supply one, the prompt becomes optional.