package specification-3 procedures package body-4 procedures how can i write for other procedure in package body2 5809
what is variable in package specification2 4641
i don't want the message as 14 rows updated just it should update what it will do4 6544
how can i read files from a pl/sq l program3 6255
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?27 36031
what is the command for user data type?2 7122
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.15 37284
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
In testing where do we use sql language and how it helps in testing?2 5604
what command is used to create a table by copying the structure of another table including constraints ?6 12258
How to convert ms-excel file to oracle table?2 7236
What is the command used to fetch the first 5 characters of a string?
What is restrict in sql?
How do you delete a table?
Can we use join in subquery?
what is the difference between truncate and drop statements? : Sql dba
What are the indexing methods?
How do we accept inputs from user during runtime?
What is 19 null in sql?
What is keys and its types?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
How to fetch alternate records from a table?
How to execute a stored procedure?
What is synonyms?
What is mutating trigger?