If I have a table T with 4 rows & 2 columns A & B. A has
values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL
query which can Swap the values of A & B for all records.
(Do not use a sub-query)
Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE)
How many database objects (trigger, packages, sequence etc)
uses a
particular field in a given table.
For ex: I want to know how many database object uses the
ATTRIBUTE1 in
the PO_VENDORS table.
What query will give me the result showing the database
object
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
PO_VENDORS).
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.
42
Is it possible to center an object horizontally in a
repeating frame that has a variable horizontal size ?
i have a web page and in this page i create 3 textbax and a
"summit" button do you have any html code for add text velue
in my web page like link summation(form) sites.
49
i wrote a pl/sql procedure. it must run every sunday 4.40
How can i schedule it with the help of dbms_jobs (or
another other procedure with out creating bat file,exe file)
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
25
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT
QUERY OR MULTIPLE GROUP QUERY ?
along with your userid / name. ThanQ
Site Map