Create Job In Oracle

A user with a Create any job privilege can create a job in any schema except the sys schema. Attaching a job with a particular class requires the execute privileges for that class. Oracle database 10g offers a collection a rich set of functionality for complex scheduling tasks. The component that causes something to be executed at a specified...

Read More

Implicit Cursor

Implicit Cursors Implicit cursors are automatically created by Oracle whenever an we  SQL statement is  process, when there is no explicit cursor for the statement. Programmers cannot control the implicit cursors and the information in it. Whenever a DML statement (INSERT, UPDATE and DELETE) is issued, an implicit cursor is associated...

Read More

PLSQL Interview Questions

1.How Many triggers can be applied to a table? There are maximum 12 triggers can be applied to a table. 2. Difference between Syntax error & runtime error in PLSQL? A Syntax error is easily identified by a PLSQL compiler.For example Incorrect spelling. but runtime error can be handled with the help of Exception Section block in PLSQL. 3.How...

Read More

Example Of Constraints in Sql

Primary Key:- YOU CAN NOW CREATE A PRIMARY KEY IN oracle with the CREATE TABLE STATEMENT.SYNTAXTHE SYNTAX TO CREATE A PRIAMARY KEY USING THE CREATE TABLE STATEMENT IN ORACLE/PLSQL IS: create table empl(employee_id number primary key, last_name varchar2(50), city varchar2(50)) /SyntaxAlter table table_nameAdd column column_definationAdd...

Read More

Oracle-Sql-Basic_Queries

1.Get the first_day of the Month SQL> SELECT TRUNC (SYSDATE, 'MONTH') "First day of current month"   2      FROM DUAL; First day --------- 01-AUG-14 2.Get the Last_day of  the Current Month SELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current month"     FROM DUAL; 3.Write a query...

Read More

Conversion function

Implicit conversion:- A varchar2 or char value can be implicitly converted to Number or date type value by oracle. Similarly, a number or data type can be automatically Converted to character data by oracle server. For example the below select queries .both the queries will Give the same output because oracle internally treats 10000 And '10000'...

Read More

Convert Number Into Words

1. How can you convert a number into words using Oracle Sql Query?Please see the query below:-SELECT TO_CHAR (TO_DATE (523, 'j'), 'jsp') from dualOutput:TO_CHAR(TO_DATE(523,'J'),-------------------------five hundred twenty-three2. Write a pl sql block that count the department wise total salary where more than 5 employees are exists. SELECT ...

Read More

How to create User in Oracle & assign grant revoke privileges

CREATE USER user in Oracle Controlling User Access In a multiple-user environment, you want to maintain security of the database access and use. With Oracle server database security, you can do the following: Control database access. Give...

Read More

What is View in oracle

How to Create SQL ViewIntroduce to SQL ViewSQL View is a virtual table which is used to encapsulate a complex queries. After creating SQL view, you can treat a view as a table and manipulate data on it with only some restrictions. When the data in table changes, the data in view which is dependent on table changes also. View does not occupied the...

Read More

Working With Bfiles

Managing BfilesManipulating Large ObjectsA LOB is a data type that is used to store large, unstructured data such as text, graphic images, video clippings, and soon. Structured data, such as a customer record, may be a few hundred bytes, but even small amounts of multimedia data canbe thousands of times larger. Also, multimedia data may reside in operating...

Read More

Locate a Test Center

1) PROMETRIC TESTING (P) LTD MARWAH HOUSE, SAKI VIHAR ROAD SAKI NAKA, ANDHERI EAST MUMBAI, Maharashtra 400072 Phone: 022-28573160 Site Code: II004 2) NIIT LTD. BANDRA-MUMBAI 2ND FLOOR GURUVIDYA C.H.S 98/A HILL ROAD OPP.BANDRA POLICE STATION BANDRA(W) MUMBAI, Maharashtra 400 050 Phone: 022-26451126/4493 Site Code: II7 3)...

Read More