Saturday, May 4, 2024

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are some popular animation styles: 1. **Traditional Animation**: - Also known as cel animation, this style involves drawing each frame by hand. It's the oldest form of animation and was used in classic films like Disney's "Snow White and the Seven Dwarfs." 2. **2D Animation**: - This style has two dimensions, width and height. It's widely used for creating cartoons, marketing videos, and explainer videos. 3. **3D Animation**: - 3D animation adds depth to the images, creating a more lifelike experience. It's commonly used in movies, video games, and virtual reality. 4. **Motion Graphics**: - This style involves animating graphic elements, often used in advertisements, promotional videos, and informational content. 5. **Stop Motion**: - A technique where objects are physically manipulated and photographed frame by frame, creating the illusion of movement when the series of frames is played as a continuous sequence. 6. **Typography Animation**: - This style focuses on animating text to express ideas or convey messages, often used in title sequences and lyric videos. 7. **Clay Animation (Claymation)**: - A form of stop motion that uses malleable clay figures which are reshaped and moved for each frame. 8. **Cut-out Animation**: - Involves characters and backgrounds cut from materials like paper, which are then animated frame by frame. 9. **Rotoscope Animation**: - A technique where animators trace over live-action footage frame by frame for realistic movements. 10. **Experimental Animation**: - This style encompasses a wide range of non-traditional techniques, often pushing the boundaries of visual storytelling. Each style has its own unique charm and applications, and many animators blend different styles to create something truly unique¹²⁴⁵. Whether you're looking to create something whimsical, realistic, or somewhere in between, there's an animation style that can bring your ideas to life! Source: Conversation with Bing, 4/5/2024 (1) 31 Types of Animation Styles [Examples & Sources] - Yans Media. https://www.yansmedia.com/blog/types-of-animation-styles-and-techniques. (2) Types of Animation — Styles, Genres & Techniques - StudioBinder. https://www.studiobinder.com/blog/types-of-animation-styles/. (3) 10 Types of Animations [With inspiring examples]. https://www.animaker.com/blog/10-types-of-animations/. (4) What Are The 5 Main Types of Animation? (2024 Guide). https://academyofanimatedart.com/types-of-animation/. (5) What Are The 5 Main Types of Animation? (2024 Guide). https://bing.com/search?q=popular+animation+styles. (6) en.wikipedia.org. https://en.wikipedia.org/wiki/Animation.

How to convert normal video to animation video

Certainly! There are several tools and software options available to convert normal videos into animated videos. Here are some popular choices: 1. **Media.io Video Cartoonizer**: - This online browser-based tool allows you to create cartoons from videos instantly and for free. It's easy to use and doesn't require any software download. - **How to use**: 1. Launch the **Media.io AI Restyle** in your browser. 2. Select your preferred cartoon template from options like K-pop, Cyberpunk, Fantasy, Disney, Graffiti, and other trending effects. 3. Upload your video file, and the AI animation video maker will automatically convert your video into a cartoon. 4. Download the resulting video with the cartoon filter applied⁴. 2. **AILab Video Cartoonizer**: - AILab's video cartoonizer can transform real-life videos into cartoons instantly with just a few clicks. - **How to use**: 1. Upload your video file to the AILab platform. 2. The video cartoonizer will automatically create a cartoon-style video. 3. You can customize the cartoon level and add different filters and styles. 4. Download the cartoonized video⁵. 3. **Adobe Animate**: - Adobe Animate is a powerful tool for creating 2D animations. While it's not free, it offers top-notch video-to-animation conversion capabilities. 4. **Adobe After Effects**: - Although primarily used for visual effects, Adobe After Effects can also be used to convert videos into anime-style animations. 5. **AKVIS Sketch**: - AKVIS Sketch provides batch processing for video cartoonization. It's a versatile tool for creating artistic effects. 6. **PowToon**: - PowToon is an online platform that specializes in creating animated presentations. While it's not specifically for video cartoonization, it can be used creatively to achieve cartoon effects. Remember that each tool has its own features and limitations, so choose the one that best suits your needs and preferences. Whether you're a professional animator or just experimenting with creative videos, these tools can help you achieve impressive results! 🎥🎨⁶⁷. Source: Conversation with Bing, 4/5/2024 (1) Free Video Cartoonizer - Media.io. https://www.media.io/video-cartoonizer.html. (2) Turn Video Into Cartoon Instantly And Free - AILab Video Cartoonizer. https://ailab.wondershare.com/tools/video-cartoonizer.html. (3) Best Video Cartoonizer to Convert Your Video to Animation - Windows Report. https://windowsreport.com/video-cartoonizer-software/. (4) 11 Best Video Cartoonizer Software in 2024 - FixThePhoto.com. https://fixthephoto.com/best-video-cartoonizer-software.html. (5) Convert Any Video Into Animation With Ai | Video To Animation Ai | Ai Video Generator | Ai Animation. https://www.youtube.com/watch?v=7MrdY96bJ0U. (6) 2 Free Ways To Turn Any Video Into Animation With Ai | Free Video To Animation Ai. https://www.youtube.com/watch?v=_gaFl7aFrUM. (7) Using A.I to Convert Real Footage To Animation | Computer Generated Cartoonization. https://www.youtube.com/watch?v=n5DZFbQTOus.

Thursday, March 30, 2023

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, improving the quality of the content, and promoting the blog to attract more readers. Here are some suggestions that may help: Optimize your website's technical infrastructure: 1 Use a fast and reliable web hosting service. 2 Optimize your images and other media files to reduce page load times. 3 Use caching and other performance optimization tools to speed up your website. 4 Ensure that your website is mobile-friendly and responsive. 5 Focus on high-quality content: 6 Make sure your content is well-written, engaging, and informative. Use headlines and subheadings to make your content easy to read and navigate. Incorporate multimedia elements such as images, videos, and infographics to make your content more visually appealing. Research your topic thoroughly and provide accurate information. Write for your audience, not for search engines. Promote your blog: 1 Use social media to promote your blog and engage with your audience. 2 Participate in online communities related to your blog's topic and share your content with them. 3 Build an email list and use it to keep your subscribers updated on new content. 4 Consider guest blogging on other websites to gain exposure and backlinks to your blog. 5 Use search engine optimization (SEO) techniques to improve your blog's visibility in search engine results. Measure and analyze your performance: 1 Use analytics tools to track your website's traffic and user behavior. 2 Monitor your website's search engine rankings and use this information to make improvements. 3 Test different strategies and see what works best for your audience. 4 continuously monitor and adjust your approach to ensure that you are meeting your goals.

Sunday, October 9, 2022

Query to Get Profile value at any level

Query to Get Profile value at any level  

SELECT 

  distinct pot.user_profile_option_name Profile, 

  DECODE (

    a.profile_option_value, '1', '1 (may be "Yes")', 

    '2', '2 (may be "No")', a.profile_option_value

  ) Value, 

  DECODE (

    a.level_id, 10001, 'Site', 10002, 'Application', 

    10003, 'Responsibility', 10004, 'User', 

    '????'

  ) Level_identifier, 

  DECODE (

    a.level_id, 10002, e.application_name, 

    10003, c.responsibility_name, 10004, 

    d.user_name, '-'

  ) Level_Name 

FROM 

  applsys.fnd_application_tl e, 

  applsys.fnd_user d, 

  applsys.fnd_responsibility_tl c, 

  applsys.fnd_profile_option_values a, 

  applsys.fnd_profile_options b, 

  applsys.fnd_profile_options_tl pot 

WHERE 

  1 = 1 

  AND UPPER (pot.user_profile_option_name) LIKE UPPER ('%&v_profile%') 

  AND pot.profile_option_name = b.profile_option_name 

  AND pot.language = userenv('lang') 

  AND b.application_id = a.application_id(+) 

  AND b.profile_option_id = a.profile_option_id(+) 

  AND a.level_value = c.responsibility_id(+) 

  AND a.level_value = d.user_id(+) 

  AND a.level_value = e.application_id(+) 

  AND e.language(+) = userenv('lang') 

  AND (

    UPPER (e.application_name) LIKE UPPER ('%&appname_respname_username%') 

    OR UPPER (c.responsibility_name) LIKE UPPER (

      '%&&appname_respname_username%'

    ) 

    OR UPPER (d.user_name) LIKE UPPER (

      '%&&appname_respname_username%'

    )

  ) 

ORDER BY 

  Profile, 

  Level_identifier, 

  Level_name, 

  Value


Bom Explosion Query

Below query can be handy to explode and Query BOM Details

SELECT 

  DISTINCT LPAD (' ', LEVEL * 2) || LEVEL order_level, 

  msib.segment1 assembly_item, 

  msib.description assembly_description, 

  msib.inventory_item_status_code assembly_item_status, 

  SYS_CONNECT_BY_PATH (msib2.segment1, '/') PATH, 

  msib2.segment1 AS component_item, 

  msib2.description component_item_description, 

  msib2.inventory_item_status_code component_item_status, 

  bic.item_num, 

  bic.operation_seq_num, 

  bic.component_quantity 

FROM 

  bom.bom_components_b bic, 

  bom.bom_structures_b bom, 

  inv.mtl_system_items_b msib, 

  inv.mtl_system_items_b msib2, 

  mtl_parameters mp 

WHERE 

  1 = 1 

  AND bic.bill_sequence_id = bom.bill_sequence_id 

  AND SYSDATE BETWEEN bic.effectivity_date 

  AND Nvl(bic.disable_date, SYSDATE) 

  AND bom.assembly_item_id = msib.inventory_item_id 

  AND bom.organization_id = msib.organization_id 

  AND bic.component_item_id = msib2.inventory_item_id 

  AND bom.organization_id = msib2.organization_id 

  AND mp.organization_id = msib.organization_id 

  AND mp.organization_code = : p_org_code 

  /* organization here */

  AND bom.alternate_bom_designator IS NULL START WITH msib.segment1 = : p_item_number 

  /*  component item to be used here */

  CONNECT BY NOCYCLE PRIOR bic.component_item_id = msib.inventory_item_id 

ORDER BY 

  PATH 

Oracle ERP - Hierarchical BOM Query

The query below shows the use of hierarchical query syntax to list the parts of an assembly in a typical bill of material (BOM). The parts are setup in a hierarchical (assembly - component/part) or indented manner.

 


SELECT 

  CONNECT_BY_ROOT q_bom.assembly_num root_assembly, 

  q_bom.assembly_num, 

  q_bom.component_num, 

  q_bom.qty, 

  SUBSTR(

    SYS_CONNECT_BY_PATH(q_bom.assembly_Num, ' <-- '), 

    5

  ) assembly_path, 

  LEVEL bom_level, 

  CONNECT_BY_ISCYCLE is_cycle 

FROM 

  (

    SELECT 

      mb1.segment1 assembly_num, 

      mb2.segment1 component_num, 

      bc.component_quantity qty 

    FROM 

      bom.bom_components_b bc, 

      bom.bom_structures_b bs, 

      inv.mtl_system_items_b mb1, 

      inv.mtl_system_items_b mb2 

    WHERE 

      bs.assembly_item_id = mb1.inventory_item_id 

      AND bc.component_item_id = mb2.inventory_item_id 

      AND bc.bill_sequence_id = bs.bill_sequence_id 

      AND mb1.organization_id = mb2.organization_id 

      AND bs.organization_id = mb2.organization_id 

      AND bc.disable_date Is Null 

      AND bs.alternate_bom_designator IS NULL 

      AND mb1.organization_id = 90101110109

  ) q_bom START WITH q_bom.assembly_Num = '&i_comp' CONNECT BY NOCYCLE PRIOR q_bom.component_num = q_bom.assembly_num ORDER SIBLINGS BY q_bom.assembly_Num;


Converting rows into columns using pivot function


we can convert rows into columns using the pivot function

let us consider the following data as sample data


DEPTNO ENAME JOB

10 ALLEN ANALYST

10 JONES CLERK

10 FORD MANAGER

10 ABCD PRESIDENT

10 CLARK SALESMAN

20 MILLER ANALYST

20 SMITH CLERK

20 WARD MANAGER

20 efgh PRESIDENT

20 MARTIN SALESMAN

30 SCOTT ANALYST

30 TURNER CLERK

30 ADAMS MANAGER

30 BLAKE PRESIDENT

30 KING SALESMAN


now create a table as emp_jobs with this data



using pivot function

we are converting rows into columns

select * from emp_jobs pivot( min(ename) for job in ('PRESIDENT','MANAGER','CLERK','ANALYST','SALESMAN'));



the output is in the form

DEPTNO PRESIDENT' MANAGER' CLERK' ANALYST' SALESMAN'

20 efgh WARD SMITH MILLER MARTIN

10 ABCD FORD JONES ALLEN CLARK

30 BLAKE ADAMS TURNER SCOTT KING

but while using pivot function aggregate function should be used 


we can also achieve this conversion without using pivot function using this sql query

 select

   a1.deptno,

   a1.ename  AS PRESIDENT,

   a2.ename AS MANAGER,

   a3.ename AS CLERK

from

   emp_jobs  a1,

   emp_jobs a2,

   emp_jobs  a3

   where

   a1.deptno=a2.deptno

   and a2.deptno=a3.deptno

   and a3.deptno=a1.deptno

   and a1.job = 'PRESIDENT'

   and a2.job = 'MANAGER'

   and a3.job ='CLERK';

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...