Login  |   Register    Online Testing (31)  Brain Gym (1)  Certification (0)  Java (9)  Microsoft (7)  Networking (1)  Technology (11)  Testing (2)   Oracle Database Skills Practice Test A User named ABC has created a procedure named SALARY_CALC. Which SQL query allows him to view the text of the procedure?              SELECT text FROM user_source WHERE name =’SALARY_CALC’;              SELECT * FROM user_source WHERE source_name =’salary_calc’;              SELECT * FROM user_objects WHERE object_name = ’SALARY_CALC’;              SELECT * FROM user procedures WHERE object_name =’SALARY_CALC’;              SELECT text FROM user_source WHERE name=’SALARY_CALC’ AND owner =’ABC’;     Question 2 of 69 First  |   Previous  |   Next  |   Last   Related Questions # Question Details 1 When a thread is created and started, what is its initial state 2 How are Java source code files named 3 What Snow Flake Schema 4 What is the Difference between OLTP and OLAP 5 What are the various Reporting tools in the Market 6 What is Fact table 7 What is a dimension table 8 What is Normalization, First Normal Form, Second Normal Form , Third Normal Form 9 What is the difference between Power Center & Power Mart? 10 How do we call shell scripts from informatica? Related Articles Accessing Repository Resources with SQL Accessing Repository Resources with SQL In fact Oracle XML DB repository resources are stored in a set of database tables and indexes which can be accessed via SQL You are not supposed to access those tables directly Instead Oracle XML DB provides two public views RESOURCE VIEW and PATH VIEW through   Performing DML Operations on XML Schema Based XMLType Views Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr   Using XMLType Views Using XMLType Views Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML Once written an XMLType view may be used in various queries making them simpler and so increasing their readability mosgo   Retrieving XML Data Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the   ODP.NET - Working with Bind Variables together with OracleParameter ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m   ODP.NET - Handling Nulls when Working with OracleDataReader ODP NET Handling Nulls when Working with OracleDataReader When we work with OracleDataReader or for that matter even with data rows in a data table we may come across nulls The following is the efficient way to deal in with such scenarios mosgoogle geshibot language VB NET" create connect   ODP.NET - Working with DataTableReader ODP NET Working with DataTableReader DataTableReader is complementary to a DataTable object and is mainly used as a type of Data Reader in the disconnected mode The following is the modified code mosgoogle geshibot language VB NET" create connection to db Dim cn As New OracleConnection D   ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter ODP NET Retrieving a Single Row of Information Using OracleDataAdapter In the previous example we worked with a set of rows in the DataTable object Now we shall work with a particular row using the DataTable object The following code accepts an employee number from the user and gives you the details   SQA Approaches and Methodologies SQA Approaches and Methodologies A scientific approach should have methods As a scientific process a stage or a step should be established or used to ensure the final product is according to the user’ s specifications The method is usually determined through the wishes of the clients the a   jQuery Table Row Filtering jQuery Table Row Filtering Earlier we examined sorting and paging as techniques for helping users focus on relevant portions of a table s data We saw that both could be implemented either with server side technology or with JavaScript Filtering completes this arsenal of data arrangement strategies B